Asset Query (only show active computers)

[evanb]

I’m trying to create a query that includes the following information with only active computers showing up.

Computer
IdentifyingNumber (Alias “Service tag”)
LastknownIP
BranchOffice
Location
Custom1 (Alias “Current User”)
OrderNumber
PurchaseDate
WarrantyDate

Thanks

[Hemoco · Accepted solution]

Please use the report below for the information you are after.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssetCustom.Serialnumber,
tblAssets.IPAddress,
tblAssetCustom.Branchoffice,
tblAssetCustom.Location,
tblAssetCustom.Custom1,
tblAssetCustom.OrderNumber,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName

[evanb]

Version 5.0

[Hemoco]

Which Lansweeper version are you using? 4.2 or 5.0?