User Software Report

[sandve]

Management requested a report that would include software such as 'Office' and 'Adobe Reader', and would exclude software such as 'Visual C++ 2005 Redistributable', 'Java 7 Update 55', and 'Microsoft .NET Framework 1.1'.

Any suggestions for creating a report of software that has direct user interaction?

[Daniel_B · Accepted solution]

@MakeBug: Thx, indeed user interaction with software is not being scanned.

@sanve: Software names need to be explicitely filtered. Even for the same software product you often have different entries in Programs and Features. The following report lists the software you mentioned as example together with the last logged on user on the computer it was scanned.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblSoftwareUni.softwareName,
  tblSoftwareUni.SoftwarePublisher,
  tblAssets.Username,
  tblAssets.Userdomain
From tblAssets
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where ((tblSoftwareUni.softwareName Like N'Microsoft Office % 20%' And
      tblSoftwareUni.softwareName Not Like '%viewer%' And
      tblSoftwareUni.softwareName Not Like '%tools%' And
      tblSoftwareUni.softwareName Not Like '% designer%') Or
    (tblSoftwareUni.SoftwarePublisher Like 'adobe%' And
      tblSoftwareUni.softwareName Like '%Reader%')) And tblAssetCustom.State = 1
Order By tblAssets.AssetName

[MakeBug]

I think the only way is to list everything you want separately. Afaik there's no option to scan for software with user interaction or such.