cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
mdias_software
Engaged Sweeper III

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:

mdias_software_0-1707491983751.png

In here:

mdias_software_1-1707492165605.png

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?

 

Kind Regards,
Mateus Dias
1 ACCEPTED SOLUTION
3 REPLIES 3
Mister_Nobody
Honored Sweeper II

Mister_Nobody_0-1707795084214.png

 

Hello,

Thank you very much!

Kind Regards,
Mateus Dias
Obi_1_Cinobi
Lansweeper Tech Support
Lansweeper Tech Support

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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now