‎11-10-2021 03:13 PM
‎11-10-2021 06:22 PM
‎11-10-2021 06:02 PM
dipeshn wrote:
Hi all I have the following Code but its retuning all results as "Yes" , which is not the case
(Select (Case
When Exists(Select Top 1 tblAssets.AssetName From tblAssets
Where Exists(Select tblProcesses.AssetID From tblProcesses
Where tblProcesses.AssetID = tblAssets.AssetID And
tblProcesses.Caption = 'SenseCE.exe')) Then 'Yes'
Else 'No'
End)) As MMDE_Installed,
Looking for assistance on how i can modify the search to ensure it reflects the results correctly
Regards
Dipesh
Select Distinct Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypename,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassets.Lastseen,
tblassets.Lasttried,
tblProcesses.Caption
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join lansweeperdb.dbo.tblProcesses On tblassets.AssetID =
tblProcesses.AssetID
Where tblProcesses.Caption = 'iexplore.exe' And tblassetcustom.State = 1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now