Report to analyze Office licenses

[GS1US]

I'd like to create a report to figure out how many Microsoft Office licenses we are using. I want it to cover Office 2003, Office 2007, Visio, and Project. I haven't seen a standard report that will do this, and I can't figure out how to create a custom report to show what I want it to show. Any ideas? Thanks

[GS1US]

Exactly what I was looking for!! Thank you!

[Cobra7]

Try this:

SELECT 
  tblSoftware.ComputerName,
  tblSoftware.softwareName
FROM
  tblSoftware
WHERE
  tblSoftware.softwareName LIKE '%Microsoft Office%' OR 
  tblSoftware.softwareName LIKE '%Visio%' OR 
  tblSoftware.softwareName LIKE '%Publisher%'

You will have to tweak this some, possibly add each version instead of the generics I put in.

Hope this helps