→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
tfrank
Engaged Sweeper
Hi, I'm looking to create a report where (if possible) you type the computer name or asset name you're looking for and it will output the Service Tag, Warranty Expiration, and Last Logged On User. If it's possible I'd love to get the OU of the last logged on user in it also but that part isn't necessary. I'm just lost on the create your own report thing in Lansweeper but if there was a report that gave me a headstart I'm sure I can reverse-engineer how it works and apply what I need (that's how my brain seems to work!).

Any help or headstart is greatly appreciated.

Thanks!
1 REPLY 1
MikeMc
Champion Sweeper II
This should get you started.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Serialnumber,
tblAssetCustom.Warrantydate,
tblAssets.Userdomain,
tblAssets.Username,
tblADusers.OU
From tblAssets
Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Left Join tblADusers On tblADusers.Userdomain = tblAssets.Userdomain
And tblADusers.Username = tblAssets.Username
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Order By tblAssets.AssetName