‎01-15-2018 09:15 PM
‎01-19-2018 04:07 PM
‎01-19-2018 03:20 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Username
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblPortableBattery
On tblAssets.AssetID = tblPortableBattery.AssetID
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where tblAssets.AssetID Not In (Select tblAssets.AssetID
From tblAssets Inner Join tblRegistry On tblAssets.AssetID =
tblRegistry.AssetID
Where tblRegistry.Regkey Like '%SOFTWARE\gppreauth' And
tblRegistry.Valuename = 'Expires') And tsysAssetTypes.AssetTypename =
'windows' And tblAssets.Lastseen <> '' And tblAssetCustom.State = 1 And
tblPortableBattery.AssetID Is Not Null And tblADComputers.OU = 'Your OU '
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now