Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Reporting-Trying to get list of all Computers/Users and what version of Office they have

Created: 24 Oct 2012 • Updated: 26 Oct 2012 | 3 comments
This issue has been solved. See solution.

If anyone can even point me in the right direction, I would appreciate it.

Comments 3 CommentsJump to latest comment

JimChud's picture

So what you do is go to Reports and all reports and right click on the folder you want to create the new report, select create a new SQL Report. Then in the query section put:

 

SELECT
   vC.Guid,
   vC.[Name],
   vC.[User],
   addrem.DisplayName,
   addrem.DisplayVersion
FROM
   [vComputer] vC
      INNER JOIN [Inv_AddRemoveProgram] AS [addrem]
         ON ([vC].[Guid] = [addrem].[_ResourceGuid])
WHERE
  [addrem].DisplayName like 'Microsoft Office%'
and [addrem].DisplayName NOT LIKE '%Proof%'
and [addrem].DisplayName NOT LIKE '%Service Pack%'
and [addrem].DisplayName NOT LIKE '%MUI%'
and [addrem].DisplayName NOT LIKE '%Components%'
and [addrem].DisplayName NOT LIKE '%File Validation%'
and [addrem].DisplayName NOT LIKE '%Runtime%'
and [addrem].InstallFlag = 1

Regards Jim.
Connect Etiquette: "Mark as Solution" those posts which resolve your problem and give a thumbs up to useful comments, articles and downloads.

SOLUTION
JimChud's picture

not a problem, i would recommend getting access to the SQL DB and having a look through the database to see what you can see.

Also if you go to a computer in resource manager you can view the inventory from there. The locations with the information are pretty much identical to the table names in the database and very useful to help you find and write queries.

 

also the reporting forum on here has alot of videos and guides which are fairly recent and would help move you forward some more :)

Regards Jim.
Connect Etiquette: "Mark as Solution" those posts which resolve your problem and give a thumbs up to useful comments, articles and downloads.