Client Management Suite

I am generating the report which show me the ms office application systems count and name, how can i generate the report

Report

Reports > All Reports, then expand Reports > Discovery and Inventory > Inventory > Cross-platform > Software/Applications > Installed Software or Installed Software by Computer.  For example, using the Installed Software report, type '%office%' for the Company OR '%Microsoft%' for the Name

Check this thread

https://www-secure.symantec.com/connect/forums/installed-software-report-location-included

try this query,  

SELECT vc.Name, arp.DisplayName,arp.DisplayVersion

FROM vComputer vc

JOIN Inv_AddRemoveProgram arp ON arp._ResourceGuid=vc.Guid

WHERE DisplayName LIKE 'Microsoft Office' AND arp.InstallFlag=1

I wrote a different version to show me the latest version of office - in my enviroment we can have multple version of office installed. 

Also remember that add/remove install date is broken in 7.1 and will reflect last patch date install instead of first installed date if you use the addremove install date 

I also prefer to name the office version to what is corporate - even though I know that I have home version installed. 

select 
ac.Name,

convert(varchar, ac.[client date], 101) as 'ScanDate',

ac.name,ac.[OS Name] AS 'OS Name',
COALESCE(case when office1.[Display Version]='15' then 'Office 2013' ELSE NUll end,
     case when office1.[Display Version] ='14' then 'Office 2010' ELSE NUll end,
      case when office1.[Display Version] = '12' then 'Office 2007'ELSE NUll end,
      case when office1.[Display Version] = '11' then 'Office 2003'ELSE NUll end,
      case when office1.[Display Version] = '9.' then 'Office 2000'ELSE NUll end     ) 
     as 'Office Name' , 
             office1.[Display Version] as 'Office Version',
 convert(varchar,Officeuse.[Last Run],101) as 'Office Last Run',
Officeuse.usage,
officeuse.[Run Count],
CAST ((officeuse.[Total Run Time]/60) AS DECIMAL (10,2)) as 'Office Usage in minutes'

 FROM dbo.Inv_AeX_AC_Identification ac
 left JOIN  vcomputer i    ON i.Guid = ac._ResourceGuid 
left join vAsset on vasset._ResourceGuid = ac._ResourceGuid
left join vComputer vc on vc.Guid =ac._ResourceGuid 
left join (            select  MAX  (Left(prog.DisplayVersion,2))as 'Display Version', i.[guid]
        FROM  dbo.vComputer i  INNER JOIN dbo.Inv_AddRemoveProgram prog
        ON i.[Guid]= prog._ResourceGuid 
                    where (
        prog.DisplayName ='Microsoft Office Professional Plus 2007'
        or prog.DisplayName ='Microsoft Office Professional Plus 2010'or prog.DisplayName ='Microsoft Office Professional Edition 2003'
        or prog.DisplayName ='Microsoft Office 2010'or prog.DisplayName ='Microsoft Office Standard 2010'
        or prog.DisplayName ='Microsoft Office 2000 SR-1 Professional'or prog.DisplayName ='2007 Microsoft Office system'
        or prog.DisplayName ='Microsoft Office Enterprise 2007'or prog.DisplayName ='Microsoft Office Basic Edition 2003'
        or prog.DisplayName ='Microsoft Office 2000 SR-1 Disc 2' or prog.DisplayName ='Microsoft Office Professional Plus 2013'
        )group by i.guid )                office1 
     on i.Guid =office1.[guid]
      left join ( SELECT DISTINCT vc.guid, vc.Name,adrp.InstallDate, adrp.DisplayName,vms.[Run Count],vms.[Total Run Time], vms.[Last Start] AS [Last Run], 
            CASE WHEN vms.[Run Count]>= 1 THEN 'Yes' ELSE 'No' END usage 
                FROM Vcomputer vc 
                LEFT JOIN Inv_AddRemoveProgram adrp ON vc.Guid = adrp._resourceguid
                LEFT JOIN vAMMonthlySummary vms ON adrp._resourceguid = vms._resourceguid
                  AND vms.[Last Start] = (SELECT max(vms.[Last Start]) FROM vAMMonthlySummary vms WHERE vms._ResourceGuid = vc.Guid)
                LEFT JOIN Inv_InstalledSoftware ins ON vms._ResourceGuid = ins._ResourceGuid
                WHERE adrp.DisplayName in
                        (         'Microsoft Office Professional Plus 2007',         'Microsoft Office Professional Plus 2010','Microsoft Office Professional Edition 2003'
                     ,'Microsoft Office 2010','Microsoft Office Standard 2010'        ,'Microsoft Office 2000 SR-1 Professional','2007 Microsoft Office system'
                        ,'Microsoft Office Enterprise 2007','Microsoft Office Basic Edition 2003'        ,'Microsoft Office 2000 SR-1 Disc 2' ,
                        'Microsoft Office Professional Plus 2013'        ) )
            Officeuse on ac._ResourceGuid  = officeuse.Guid

WHERE ac.[Client Date]>GETDATE ()-20
and ac.[OS Name] not like '%server%'
and vAsset.[Status] ='active'

order by  ac.Name asc

so I use 2 reports for Office..

the first one is what im gathering you have listed in your request of count....this will give all name and count...
 

SELECT  t0.DisplayName, Count(*) AS Total
FROM  Inv_AddRemoveProgram t0
    join [vFixedAssetResourceStatus] t1 on t0._ResourceGuid = t1.Guid
WHERE t1.status = 'active' and ((( t0.DisplayName) Not Like '%Service%' And ( t0.DisplayName) Like 'Microsoft Office%' 
    And ( t0.DisplayName) Not Like '%Security%' And ( t0.DisplayName) Not Like '%Project%' 
    And ( t0.DisplayName) Not Like '%Visio%' And ( t0.DisplayName) Not Like '%Disc 2%' 
    And ( t0.DisplayName) Not Like '%Communicator%' And ( t0.DisplayName) Not Like '%Viewer%' 
    And ( t0.DisplayName) Not Like '%Visual%' And ( t0.DisplayName) Not Like '%Resource%' 
    And ( t0.DisplayName) Not Like '%Share%' And ( t0.DisplayName) Not Like '%Publisher%' 
    And ( t0.DisplayName) Not Like '%proof%' And ( t0.DisplayName) Not Like '%Powerpoint%' 
    And ( t0.DisplayName) Not Like '%outlook%' And ( t0.DisplayName) Not Like '%onenote%' 
    And ( t0.DisplayName) Not Like '%live%' And ( t0.DisplayName) Not Like '%infopath%' 
    And ( t0.DisplayName) Not Like '%frontpage%' And ( t0.DisplayName) Not Like '%converter%' 
    And ( t0.DisplayName) Not Like '%access%' And ( t0.DisplayName) Not Like '%web%' 
    And ( t0.DisplayName) Not Like '%excel%' And ( t0.DisplayName) Not Like '%groove%' 
    And ( t0.DisplayName) Not Like '%word%' And ( t0.DisplayName) Not Like '%interop%') 
    AND (( t0.Publisher) Like 'Microsoft%'))

GROUP BY  t0.DisplayName
ORDER BY  t0.DisplayName

that report will give a incorrect count if you have multiple office installs on machines. which is why i wrote mine with a MAX verison statement 

interesting I will have to look at that..

thanks!