‎06-07-2013 06:33 PM
‎06-07-2013 07:09 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain As [Domain\Workgroup],
tsysIPLocations.IPLocation As Location,
tblAssets.IPAddress As [IP Address],
tsysOS.OSname As OS,
TsysChassisTypes.ChassisName As [Chassis Type],
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblSystemEnclosure.SerialNumber,
tblAssets.LastActiveScan,
tblAssets.Scanserver
From tblAssets
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On tblSystemEnclosure.ChassisTypes =
TsysChassisTypes.Chassistype
Where tblAssets.AssetID Not In (Select tblRegistry.AssetID From tblRegistry
Where tblRegistry.Regkey Like '%Nimbus.Nim' And tblRegistry.Valuename = ' ')
And tblComputersystem.Domainrole > 1
Order By tblAssets.AssetUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now