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