AnsweredAssumed Answered

Custom SQL query, combine data from different report

Question asked by emmanuel.rasamoely Advocate on Apr 18, 2018
Latest reply on Apr 20, 2018 by emmanuel.rasamoely

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