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.
I created custom report that combines the information from WMI and Server features.
Maybe it will help you.
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