
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-22-2015 04:26 PM
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?
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?
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-23-2015 10:55 AM
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
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-23-2015 10:55 AM
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
