‎04-04-2022 09:52 PM
‎04-05-2022 11:28 AM
Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypename,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassets.Lastseen,
tblassets.Lasttried,
Case
When [Correct-Reg].Value Is Not Null And [Correct-Reg].Value =
'98.0.2 (x64 en-GB)' Then 'OK'
When [Correct-Reg].Value Is Not Null And [Correct-Reg].Value Not Like
'%98.0.2% ' Then 'Wrong Value'
When [Correct-Reg].Value Is Null Then 'Blank'
End As Status
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Left Join (Select tblRegistry.Valuename,
tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Value
From lansweeperdb.dbo.tblRegistry
Where tblRegistry.Valuename = 'CurrentVersion' And
tblRegistry.Regkey Like '%SOFTWARE\Mozilla\Mozilla Firefox%' And
tblRegistry.Value Is Not Null) [Correct-Reg] On [Correct-Reg].AssetID =
tblassets.AssetID
Where Case
When [Correct-Reg].Value Is Not Null And [Correct-Reg].Value =
'98.0.2 (x64 en-GB)' Then 'OK'
When [Correct-Reg].Value Is Not Null And [Correct-Reg].Value Not Like
'%98.0.2% ' Then 'Wrong Value'
When [Correct-Reg].Value Is Null Then 'Blank'
End Not Like '%OK%' And tblassetcustom.State = 1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now