Unauthorized Software list

[david20100]

What can i modify, to create the Authorized software list report?

thanks

[Hemoco · Accepted solution]

See this example:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblSoftware.softwareName, tblSoftware.softwareVersion From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Where tblSoftware.softwareName Not In (Select tblapprovedsoftware.Software
From tblapprovedsoftware)

[david20100]

I want to create a report, but that only show the approved instead of the unauthorized, i want to know what tables i need to modify from the unauthorized software report

thanks

[Hemoco]

In the configuration tool you can add new software to the "approved" software list.