MS Office version with SP Reporting
Has anyone had any success in creating a report that breaks down computers by machine name, user, office version and SP version?
I can do it through a software advance search, but I'm having trouble creating a report. We are about to upgrade to Exchange 2010 and this report would help tremendously for our end users who are running Office 2003 with less than SP3.
Answers (3)
If you could include your management tool. This is a query for KACE.
Maybe I'm overlooking if Kace inventories SP, but this will include the version.
SELECT MACHINE.NAME, USER, SOFTWARE.DISPLAY_NAME, SOFTWARE.DISPLAY_VERSION FROM MACHINE JOIN MACHINE_SOFTWARE_JT ON MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID JOIN SOFTWARE ON MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID WHERE (SOFTWARE.DISPLAY_NAME LIKE '%MICROSOFT OFFICE PROFESSIONAL%') ORDER BY DISPLAY_VERSION ASC
What deployment tool you are using? SCCM? This can be achived easily using SCCM.
or else you can use MAP Tool Kit 6.5
http://technet.microsoft.com/en-us/library/bb977556.aspx
Have a look at the sample report available in the following link
http://www.microsoft.com/en-us/download/details.aspx?id=7826