Software Management Group

I need help on creating a simple software report for visio, the built-in 'Installed Software' doesn't meet the requirement, since it aggregates the software install.  What I need is a simple report that can be ran against a filter and with fields of computername, OS, user, and Visio (this report should include all version of Visio.

Thanks in advance

Try this:

select distinct

vc.Name as 'PC Name',

acid.[Last Logon User],

acid.[OS Name],

ad.DisplayName as 'Software Name',

ad.DisplayVersion as 'Software Version',

ad.InstallDate

from vComputer vc

join Inv_AeX_AC_Identification acid on vc.Guid = acid._ResourceGuid

JOIN CollectionMembership cm ON cm.ResourceGuid = acid._ResourceGuid

JOIN vCollection cc ON cc.Guid = cm.CollectionGuid

join Inv_AddRemoveProgram ad on acid._ResourceGuid = ad._ResourceGuid

Join vAsset va on va._ResourceGuid = vc.Guid

where

vc.IsManaged = 1

and va.Status = 'Active'

and cc.Guid = '' --collection guid here

and ad.DisplayName like 'Microsoft%Visio%'

order by vc.Name asc

you can go to 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 '%Visio%' for the Company OR '%Microsoft%' for the Name.

See the below thread comment for your requirement

https://www-secure.symantec.com/connect/forums/how-get-report-altiris-71