How to I create a report of unauthorized software on all computers being scanned on a network?

[itadmin2]

How do I create a report of unauthorized software on all computers being scanned on a network?
Would the entries of ALL Installed software be in this report?

Under software licence compliance there are only a few applications which we have legally purchased.
Is there something other report which clearly states what is authorized and what is not?

Cheers,

[Hemoco]

Yes, on the left is all software found in your network, on the right the software that you approved.

[itadmin2]

How do I do this step? Are you refering to the configuration console, allowed software option?

[Hemoco]

Did you authorize the software using the configuration tool/configuration/Approved software?

[itadmin2]

Do we have any news on this topic, it is urgently required.

[itadmin2]

This sql query was executed sucessfully on the lansweeper database.
I have exported this to an excel file and it contains all installed software from all systems which were scanned.
There is not distinction between authorized and unathorized.

[itadmin2]

The sql query was successful. How do we distinguish between the unauthorized software from the authorised ones?

[Hemoco]

itadmin wrote:
The sql query was successful. How do we distinguish between the unauthorized software from the authorised ones?

Could you please rephrase the question, I don't understand what you mean.

[Hemoco]

This is the needed SQL code:

SELECT     TOP 100 PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblOperatingsystem.Description, dbo.tblSoftware.softwareName AS Software, 
                      dbo.tblSoftware.softwareVersion AS Version, dbo.tblSoftware.Lastchanged
FROM         dbo.tblSoftware INNER JOIN
                      dbo.tblComputers ON dbo.tblSoftware.ComputerName = dbo.tblComputers.Computername INNER JOIN
                      dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
WHERE     (NOT (dbo.tblSoftware.softwareName IN
                          (SELECT     software
                            FROM          tblapprovedsoftware)))
ORDER BY dbo.tblComputers.Computername

[itadmin2]

i have attached a snapshot of the web console.
I can not find the option unathorized reports.
please let me know if there is something else which needs to be configured in order to get a report of all unauthorised software.