AnsweredAssumed Answered

Custom SQL query, combine data from different report

Question asked by emmanuel.rasamoely Advocate on Apr 18, 2018
Latest reply on Jul 21, 2019 by RuthSam


I would like to get data from different report with one query.

I would like to use informations from the "Applications per computer" report, and add the following:


 - Status (I found a "StatusCode" in the "tblComputerInfo" table but I don't know if it's the good one)

 - Type and Last discovered, from the "Application installation history" report


I have access to the SnowLicenceManager DB so a SQL query will be perfect

Thank you all for the help