cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cvhyatt
Engaged Sweeper II
Hello all! I have the following report I am trying to modify. It currently detects two conditions to determine if encryption software is loaded: 1) If it has Dell Data Protection in the Add/Remove list or it contains wsscane.exe. I would like to add a second software package to detect but am having problems. Please let me know your thoughts.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When DellSoftware.AssetID Is Null Then 'No'
Else 'Yes'
End As [Software Installed],
Case
When DellFile.AssetID Is Null Then 'No'
Else 'Yes'
End As [File Found]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblPortableBattery On tblPortableBattery.AssetID =
tblAssets.AssetID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join (Select tblSoftware.AssetID
From tblSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
And tblSoftwareUni.softwareName Like 'Dell Encryption%' or Like 'Dell Data Protection%') As
DellSoftware On DellSoftware.AssetID = tblAssets.AssetID
Left Join (Select tblFileVersions.AssetID
From tblFileVersions
Where tblFileVersions.FilePathfull Like '%wsscan.exe%' And
tblFileVersions.Found = 1) As DellFile On DellFile.AssetID =
tblAssets.AssetID
Where tblState.Statename = 'Active' And DellSoftware.AssetID Is Null And
DellFile.AssetID Is Null
Order By tblAssets.Domain,
tblAssets.AssetName
0 REPLIES 0