→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
evanb
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

3 REPLIES 3
Hemoco
Lansweeper Alumni
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
Engaged Sweeper
Version 5.0
Hemoco
Lansweeper Alumni
Which Lansweeper version are you using? 4.2 or 5.0?