AnsweredAssumed Answered

Custom SQL query, combine data from different report

Question asked by emmanuel.rasamoely Advocate on Apr 18, 2018
Latest reply on Feb 25, 2019 by Viktors

Hello,

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

Outcomes