→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎04-15-2015 02:03 PM
Solved! Go to Solution.
‎04-16-2015 01:22 PM
Select Top 1000000 tblAssets.AssetName,
tblADusers.Name,
tblADusers.Description,
tblADusers.Office,
tblAssets.IPAddress,
tblOperatingsystem.Caption,
tblAssets.Memory,
tblAssets.Processor,
tblAssets.NrProcessors,
tblSystemEnclosure.Manufacturer,
tblAssetCustom.Model,
TsysChassisTypes.ChassisName,
tblBIOS.ReleaseDate As [BIOS release date]
From tblADusers
Inner Join tblAssets On tblAssets.Username = tblADusers.Username
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On tblSystemEnclosure.ChassisTypes =
TsysChassisTypes.Chassistype
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
‎04-16-2015 01:22 PM
Select Top 1000000 tblAssets.AssetName,
tblADusers.Name,
tblADusers.Description,
tblADusers.Office,
tblAssets.IPAddress,
tblOperatingsystem.Caption,
tblAssets.Memory,
tblAssets.Processor,
tblAssets.NrProcessors,
tblSystemEnclosure.Manufacturer,
tblAssetCustom.Model,
TsysChassisTypes.ChassisName,
tblBIOS.ReleaseDate As [BIOS release date]
From tblADusers
Inner Join tblAssets On tblAssets.Username = tblADusers.Username
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On tblSystemEnclosure.ChassisTypes =
TsysChassisTypes.Chassistype
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now