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.

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

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
Answered 07/02/2012 by: dugullett
Red Belt

Please log in to comment
0

Thank you both! Looks like the MAP Tool Kit 6.5 will help me with what I'm looking for. Thanks again! :)

Answered 07/02/2012 by: kirkfondren
Orange Belt

Please log in to comment
0

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

 

Answered 06/29/2012 by: jagadeish
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity