I need to try and run a report on Kace that will give me just all of the versions of office suites. We used to use SCCM and this is what that report looked like.

Computer Domain Computer Name Office Version IE Version Software Inventory Top Console User (AI) Last Logged on User (HW) Hardware Inventory
test user-pc Office 2007 8.00.6001. 5/15/2012 19:22 test\user test\Support 5/16/2012 11:30

Im not really too concerned about the IE Version. My SQL knowledge is limited at best. I appreciate all the info you guys can supply.

Thanks! 

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

5

I'm not really sure if top console user is tracked. Although I'm sure you can do that with a custom inventory.

SELECT Domain, NAME, SOFTWARE.DISPLAY_NAME, SOFTWARE.DISPLAY_VERSION, USER_LOGGED

FROM MACHINE

LEFT JOIN MACHINE_SOFTWARE_JT ON MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID

LEFT JOIN SOFTWARE ON MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID

WHERE SOFTWARE.DISPLAY_NAME LIKE '%MICROSOFT OFFICE PROFESSIONAL%'

ORDER BY NAME, DOMAIN

You can also take a look at John's post to help you in the future.

http://www.itninja.com/blog/view/primer-for-writing-select-statement-queries-on-the-k1000-w-custom-sql-report-example

Answered 07/20/2012 by: dugullett
Red Belt

Please log in to comment

Answers

This content is currently hidden from public view.
Reason: Removed by user request
For more information, visit our FAQ's.

Answer this question or Comment on this question for clarity