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.
Community Chosen Answer
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.