→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎05-22-2013 06:03 PM
‎05-28-2013 05:15 PM
joekos wrote:
Is there a way to add the Model of each of these items
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname,
tblAssets.SP,
tblAssets.Memory,
tblAssets.IPAddress,
tblAssets.NrProcessors,
tblAssets.Processor,
TsysChassisTypes.ChassisName,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Where tblAssetCustom.State = 1
Order By TsysChassisTypes.ChassisName,
tblAssets.Domain,
tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now