Client Management Suite

Hello.

I am looking for a report to show me which machines have which versions of office throughout our organisation.

Any ideas on how to create this report, or maybe it is one of the default reports.

Please advise.

Thanks.

If you look at the default reports, there is a software report that will give you what you're looking for. It's under inventory > software ... I believe. I'm not in front of my lab right now, but will get you the exact location tomorrow.

Hi, I tried to find the report that you mentioned, it wasnt in the list unfortunately.

I havent managed yet to create any kind of report to show which office versions are installed on which computers and which versions of office are on which computer.

Hello. I have attached a screenshot. I just copied a application metering poilcy to monitor 'MS Project'

and will then create another to show office versions.

Am I on the right track?

And where do i see the report for this?

thanks in advanced.

No application metering is totally different.

Goto Reports -> discovery and Inventory -> Baseline Reports -> Software / applications -> General Software. you can use the Count of products by version and manufacturer.

Next to group by box put in "microsoft office standard" and this should filter out the versions...

Here is the raw SQL to create a report for all MS Office versions. It display Computer Name, User, OS Name, and Application Name. You can modify it to report individual office apps you want to report by changing the  Not Like statement, as in (ARP.DisplayName) Not Like '%Powerpoint%', to a Like statement.

You can also narrow down the search to specific MS Office versions by adding to the (ARP.DisplayName) Like 'Microsoft Office%' statement.

##

Select
  ID.Name as 'Computer Name',
  ID.[User],
  ID.[OS Name],
  ARP.DisplayName as 'Application Name'
From
  Inv_AddRemoveProgram ARP Join
  vComputer ID On ARP._ResourceGuid = ID.Guid
Where
  (ARP.DisplayName) Like 'Microsoft Office%' And
  (ARP.Publisher) Like 'Microsoft%' And
  (ARP.DisplayName) Not Like '%Service%' And
  (ARP.DisplayName) Not Like '%Security%' And
  (ARP.DisplayName) Not Like '%Validation%' And
  (ARP.DisplayName) Not Like '%Component%' And
  (ARP.DisplayName) Not Like '%Lab%' And
  (ARP.DisplayName) Not Like '%Sound%' And
  (ARP.DisplayName) Not Like '%Add-in%' And
  (ARP.DisplayName) Not Like '%MUI%' And
  (ARP.DisplayName) Not Like '%Project%' And
  (ARP.DisplayName) Not Like '%Visio%' And
  (ARP.DisplayName) Not Like '%Disc 2%' And
  (ARP.DisplayName) Not Like '%Communicator%' And
  (ARP.DisplayName) Not Like '%Viewer%' And
  (ARP.DisplayName) Not Like '%Visual%' And
  (ARP.DisplayName) Not Like '%Resource%' And
  (ARP.DisplayName) Not Like '%Share%' And
  (ARP.DisplayName) Not Like '%Publisher%' And
  (ARP.DisplayName) Not Like '%Producer%' And
  (ARP.DisplayName) Not Like '%proof%' And
  (ARP.DisplayName) Not Like '%Powerpoint%' And
  (ARP.DisplayName) Not Like '%outlook%' And
  (ARP.DisplayName) Not Like '%onenote%' And
  (ARP.DisplayName) Not Like '%live%' And
  (ARP.DisplayName) Not Like '%infopath%' And
  (ARP.DisplayName) Not Like '%frontpage%' And
  (ARP.DisplayName) Not Like '%converter%' And
  (ARP.DisplayName) Not Like '%access%' And
  (ARP.DisplayName) Not Like '%web%' And
  (ARP.DisplayName) Not Like '%excel%' And
  (ARP.DisplayName) Not Like '%groove%' And
  (ARP.DisplayName) Not Like '%word%' And
  (ARP.DisplayName) Not Like '%interop%' 

##

Thanks for the repliles, I will try these solutions and let u know :)

JoeShmo- ty for the reply i couldnt find the report u was referring to, my reporting layout may be different with ds 7.1 sp1

fattese - very good, cant thank you enough. this report gave me the information that I was looking for.

hi do you have any other scripts like this to share, or can you point me in the right direction. Thanks.