/bundles/itninjaweb/img/Breadcrumb_cap_w.png
Hi Folk,

I'm new to K1000 and I need help on generate a report of the number of OS version and MS Office. I thought I could do this with the report of the K1000 box, but I can't seem to figure that out.

Thanks.

TP
Answer Summary:
Cancel
0 Comments   [ - ] Hide Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity

Answers

0

Reporting > Choose Action: > Add New SQL Report >


SELECT MACHINE_0.NAME AS 'Computer Name', MACHINE_0.USER_FULLNAME, MACHINE_0.USER_LOGGED, 

MACHINE_0.IP AS 'IP Address', MACHINE_0.OS_NAME, MACHINE_0.OS_VERSION, MACHINE_0.SERVICE_PACK, 

SOFTWARE_0.DISPLAY_NAME AS 'Microsoft Office', SOFTWARE_0.DISPLAY_VERSION AS 'Office Version'

FROM ORG1.MACHINE MACHINE_0, ORG1.MACHINE_SOFTWARE_JT MACHINE_SOFTWARE_JT_0, ORG1.SOFTWARE SOFTWARE_0

WHERE MACHINE_SOFTWARE_JT_0.MACHINE_ID = MACHINE_0.ID AND MACHINE_SOFTWARE_JT_0.SOFTWARE_ID = SOFTWARE_0.ID AND SOFTWARE_0.DISPLAY_NAME Like 'Microsoft Office Professional%'

Answered 04/09/2012 by: Aaron Cool
Red Belt

Please log in to comment