Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-03-2015 09:31 AM
Hey all,
i have the following question on how i can make a report that will give me all my assets that do not have "McAfee VirusScan Enterprise" installed.
i can get it to work with showing the ones that have it installed but i want to see the ones that dont.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Username,
tblSoftwareUni.softwareName
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName = 'McAfee VirusScan Enterprise' And
tblAssetCustom.State = 1
this is what i have to show all my assets with the software installed. but how do i tell it to "IS NOT" because i cant get that to work.
hope to hear from you guys!
Thanks in advance
i have the following question on how i can make a report that will give me all my assets that do not have "McAfee VirusScan Enterprise" installed.
i can get it to work with showing the ones that have it installed but i want to see the ones that dont.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Username,
tblSoftwareUni.softwareName
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName = 'McAfee VirusScan Enterprise' And
tblAssetCustom.State = 1
this is what i have to show all my assets with the software installed. but how do i tell it to "IS NOT" because i cant get that to work.
hope to hear from you guys!
Thanks in advance
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
‎09-04-2015 05:03 PM
This page describes how to create a report on computers not having a specific software installed.
Note that Lansweeper uses two ways of scanning anti-virus information: List of installed software and additional status information scanned from WMI. You can find details in this KB article.
Note that Lansweeper uses two ways of scanning anti-virus information: List of installed software and additional status information scanned from WMI. You can find details in this KB article.
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-04-2015 05:03 PM
This page describes how to create a report on computers not having a specific software installed.
Note that Lansweeper uses two ways of scanning anti-virus information: List of installed software and additional status information scanned from WMI. You can find details in this KB article.
Note that Lansweeper uses two ways of scanning anti-virus information: List of installed software and additional status information scanned from WMI. You can find details in this KB article.