Report of Operating System and MS Office only
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
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
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
Aaron Cool
12 years ago
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%'
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
