‎11-07-2019 02:57 PM
‎02-24-2020 06:03 PM
sunshine wrote:
Have you come across a custom report, to report on the feature being enabled? I'm surprised that Lansweeper is taking so long to provide a solution, for us, the customers.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Description,
tblAssets.Lastseen,
tsysOS.Image As icon
From tblAssets
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID Inner Join tsysantivirus On
tblSoftwareUni.softwareName Like tsysantivirus.Software) And
tblAssets.AssetID Not In (Select tblAntivirus.AssetID
From tblAntivirus) And tblAssets.AssetUnique Not In (Select
tblAssets.AssetUnique From ((Select a.assetid As assetid,
a.software As software,
a.version As version,
'software comparison' As RetrievedFrom,
'' As Enabled,
'' As Uptodate
From (Select tblSoftware.AssetID As assetid,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version
From tblSoftware
Inner Join tblSoftwareUni On tblSoftware.softID =
tblSoftwareUni.SoftID
Inner Join tsysantivirus On tblSoftwareUni.softwareName Like
tsysantivirus.Software) a)
Union
(Select tblAntivirus.AssetID As assetid,
tblAntivirus.DisplayName As software,
Null As version,
'WMI' As RetrievedFrom,
Case
When tblAntivirus.onAccessScanningEnabled = 1 Then 'Yes'
Else 'No'
End As Enabled,
Case
When tblAntivirus.productUpToDate = 1 Then 'Yes'
Else 'No'
End As Uptodate
From tblAntivirus)
Union
(Select tblFeature.AssetId As AssetID,
tblFeatureUni.featureName As Software,
Null As version,
'Features' As RetrievedFrom,
'' As Enabled,
'' As Uptodate
From tblFeature
Inner Join tblFeatureUni On tblFeature.featUniId =
tblFeatureUni.featUniID And tblFeatureUni.featureCaption =
'Windows Defender')) As unioned Inner Join tblAssetCustom On
unioned.assetid = tblAssetCustom.AssetID Inner Join tblAssets On
tblAssets.AssetID = unioned.assetid Inner Join tsysOS On
tblAssets.OScode = tsysOS.OScode Left Join tsysIPLocations On
tblAssets.LocationID = tsysIPLocations.LocationID
Where tblAssetCustom.State = 1) And tblComputersystem.Domainrole >= 2 And
tblAssetCustom.State = 1
‎01-24-2020 04:55 PM
‎01-15-2020 06:23 PM
‎11-14-2019 02:33 PM
‎11-14-2019 09:15 AM
‎11-14-2019 05:39 PM
Ryan.G wrote:
Anti-virus information is retrieved from either the wmi or comparing the installed software with known anti-virus software.
In Windows servers, the anti-virus wmi class does not exist, so this option is not available. For some builds, Windows defender is a feature and not actual software, meaning it's not necessarily picked up by Lansweeper. In this case, the assets will indeed show up in the 'no anti-virus' list.
‎11-14-2019 05:44 PM
RKCar wrote:Ryan.G wrote:
Anti-virus information is retrieved from either the wmi or comparing the installed software with known anti-virus software.
In Windows servers, the anti-virus wmi class does not exist, so this option is not available. For some builds, Windows defender is a feature and not actual software, meaning it's not necessarily picked up by Lansweeper. In this case, the assets will indeed show up in the 'no anti-virus' list.
Taught me something here about the class not existing on servers.
‎11-13-2019 02:48 PM
‎11-11-2019 04:32 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now