Kace MS Office reports to match SCCM
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!
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
dugullett
12 years ago
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.
