‎10-14-2021 11:28 AM
Solved! Go to Solution.
‎10-29-2021 01:57 PM
Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypename,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassets.Lastseen,
tblassets.Lasttried,
Case
When CGuard.Value = '1' Then 'On with UEFI Lock'
When CGuard.Value = '2' Then 'On without Lock'
Else 'Not Configured'
End As 'Credential Guard Status'
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Left Join (Select tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.AssetID
From lansweeperdb.dbo.tblRegistry
Where tblRegistry.Regkey Like '%\CurrentControlSet\Control\Lsa%' And
tblRegistry.Valuename Like '%LsaCfgFlags%') CGuard On CGuard.AssetID =
tblassets.AssetID
Where tblassetcustom.State = 1
‎11-02-2021 11:19 AM
‎10-29-2021 01:57 PM
Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypename,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassets.Lastseen,
tblassets.Lasttried,
Case
When CGuard.Value = '1' Then 'On with UEFI Lock'
When CGuard.Value = '2' Then 'On without Lock'
Else 'Not Configured'
End As 'Credential Guard Status'
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Left Join (Select tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.AssetID
From lansweeperdb.dbo.tblRegistry
Where tblRegistry.Regkey Like '%\CurrentControlSet\Control\Lsa%' And
tblRegistry.Valuename Like '%LsaCfgFlags%') CGuard On CGuard.AssetID =
tblassets.AssetID
Where tblassetcustom.State = 1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now