New column in my report - Warranty and Purchased

[mdias_software]

Hi everyone!

 I have a report that to bring any informations of the my customers and I need just to add the column Warranty and Purchased of my asset in this report.

Thsi information:

In here:

My report actual:

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tsysOS.OSname,
  tblAssets.AssetName,
  TsysChassisTypes.ChassisName,
  tblAssets.Domain,
  tblAssets.Username,
  tblADusers.Department,
  tblADObjects.sAMAccountName As Manager,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblADusers.OU,
  tblADusers.Title,
  Stuff((Select ', ' + Cast(t2.MonitorModel As varchar(10)) From tblMonitor t2
    Where t1.AssetID = t2.AssetID For Xml Path('')), 1, 2, '') As Monitors
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID And
      tblAssetCustom.State = 1
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode And
      tblAssets.oscode Not Like '%s'
  Inner Join tblSystemEnclosure On
      tblAssets.AssetID = tblSystemEnclosure.AssetID
  Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
      tblSystemEnclosure.ChassisTypes
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
      tblAssets.LocationID
  Left Join tblADusers On tblADusers.Username = tblAssets.Username And
      tblADusers.Userdomain = tblAssets.Userdomain
  Left Join tblADObjects On
      tblADObjects.ADObjectID = tblADusers.ManagerADObjectId
  Inner Join tblMonitor On tblAssets.AssetID = tblMonitor.AssetID
  Inner Join tblMonitor t1 On tblAssets.AssetID = t1.AssetID
Order By tblAssets.Domain,
  tblAssets.AssetName

Could you help me with the change in my report below please?

[Mister_Nobody · Accepted solution]

[mdias_software]

Hello,

Thank you very much!

[Obi_1_Cinobi]

Hello there!

You can find the PurchaseDate and the Warrantydate fields in the database table tblAssetCustom. This information and much more can be found in the database documentation: https://community.lansweeper.com/t5/reporting/access-lansweeper-database-documentation/ta-p/64481