‎01-26-2016 06:58 PM
Solved! Go to Solution.
‎01-28-2016 04:14 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblPortableBattery
On tblAssets.AssetID = tblPortableBattery.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssets.AssetID Not In (Select Top 1000000 tblRegistry.AssetID
From tblRegistry
Where tblRegistry.Regkey Like '%SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\CMGShield' And
tblRegistry.Valuename = 'LogFileDir') And
tblAssets.AssetID Not In (Select Top 1000000 tblRegistry.AssetID
From tblRegistry
Where tblRegistry.Regkey Like '%SOFTWARE\WINMagic\securedoc'
And tblRegistry.Valuename = 'productname') And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
‎01-28-2016 04:32 PM
‎01-28-2016 04:14 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblPortableBattery
On tblAssets.AssetID = tblPortableBattery.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssets.AssetID Not In (Select Top 1000000 tblRegistry.AssetID
From tblRegistry
Where tblRegistry.Regkey Like '%SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\CMGShield' And
tblRegistry.Valuename = 'LogFileDir') And
tblAssets.AssetID Not In (Select Top 1000000 tblRegistry.AssetID
From tblRegistry
Where tblRegistry.Regkey Like '%SOFTWARE\WINMagic\securedoc'
And tblRegistry.Valuename = 'productname') And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now