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   [ + ] Show 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.

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
Answer this question or Comment on this question for clarity