‎01-24-2013 06:33 PM
Select Top 1000000 tblADusers.Displayname As Store,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblOperatingsystem.Caption,
tblOperatingsystem.ServicePackMajorVersion,
tblAssets.Memory,
tblAssets.Processor,
tblProcessor.NumberOfCores,
tblProcessor.MaxClockSpeed,
tblADComputers.OU
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblADusers On tblADusers.Username = tblAssets.Username
Where tblADComputers.OU Like '%EU99-Stores%' And tsysAssetTypes.AssetTypename =
'Windows' And tblAssetCustom.State = 1
Group By tblADusers.Displayname
‎01-25-2013 10:39 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now