→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
MR1371
Engaged Sweeper II
Hello again,

After scanning through the software of some of my PC's, I've noticed some malicious software that was installed on some of them. Is there a way to make something of a report that will scan alert me when a specific software has been installed on a computer?
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
Either you could regularly open Reports\Software overview (one of the special reports in the right column of the Reports menu) or you build your own custom report which lists computers having specific software installed. This report could be used in a Data Report widget on your Dashboard or in an automatic email alert. Please find an example report below.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblSoftwareUni.softwareName In ('Software Example 1', 'Software Example 2')
And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
software,
version

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
Either you could regularly open Reports\Software overview (one of the special reports in the right column of the Reports menu) or you build your own custom report which lists computers having specific software installed. This report could be used in a Data Report widget on your Dashboard or in an automatic email alert. Please find an example report below.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblSoftwareUni.softwareName In ('Software Example 1', 'Software Example 2')
And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
software,
version