‎11-20-2014 03:56 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblAssets
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where tblRegistry.Regkey Like '%internet explorer' And tblAssets.Assettype = -1
Order By tblAssets.AssetName
‎08-18-2015 05:31 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now