Report for Specific Computer Info - Service Tag/WarrantyDate/LastLoggedOnUser

[tfrank]

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!

[MikeMc]

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