→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
david20100
Engaged Sweeper
What can i modify, to create the Authorized software list report?

thanks
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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)

View solution in original post

3 REPLIES 3
Hemoco
Lansweeper Alumni
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
Engaged Sweeper
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
Lansweeper Alumni
In the configuration tool you can add new software to the "approved" software list.