Software Authorization - Once approved

[TasiaNAF]

Hello, I appologize if this has been asked already, but I did not find any posts on this issue. We have been marking software as "Approved" in the Sofware Authorization, but these seems to only show when the software is currently installed on a device. I am curious if its possible to list all software that we have approved in the past even if it is not currently installed on a device? 

[DavidPK]

Hi,

We've created a sample report. Instructions for adding this report to your Lansweeper installation can be found here: https://www.lansweeper.com/knowledgebase/how-to-add-a-report-to-your-lansweeper-installation/

If you are interested in building or modifying reports, we do recommend:
• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial: https://www.w3schools.com/sql/
• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here: https://www.lansweeper.com/knowledgebase/accessing-the-lansweeper-database-documentation/
Checking out our report library: https://www.lansweeper.com/report/

Select Distinct Top 1000000 tblSoftwareUni.softwareName As 'Software',
  tblSoftwareUni.SoftwarePublisher As 'Publisher',
  tblSoftwareUni.Approved as 'Approval Status'
From tblSoftwareUni
Order By Software

[TasiaNAF]

Thank you for the response. That report does show everything that was at one point marked as approved.  I forgot to mention that main concern here was to be able to mark previously approved software as unrated or unapproved after the software was already removed from the device. I see no way of doing this.