→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
sandve
Engaged Sweeper III
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?
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
@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

View solution in original post

2 REPLIES 2
Daniel_B
Lansweeper Alumni
@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
Champion Sweeper
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.