|
|
Rank: Premium user
Groups: Member
, Premium Users
Joined: 9/2/2008
Posts: 4
Location: NL
|
Hi,
Any suggestions on how i could export a list with non-allowed software.
When possible this list should also contain the computers on which this software is installed.
Thanks
|
|
Rank: Administration
Groups: Administration
Joined: 2/10/2005
Posts: 1,388
Location: Hamme Belgium
|
Code:SELECT 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
|
|
Rank: Premium user
Groups: Member
, Premium Users
Joined: 9/2/2008
Posts: 4
Location: NL
|
[quote=Lansweeper]...quote]
Thanks, working my way through learning SQL scripting. Some examples like these will help a lot :)
|
|
Rank: Freeware user
Groups: Member
Joined: 11/5/2008
Posts: 3
Location: Los Angeles, CA, USA
|
on a related topic, what is the script for creating a report to list the allowed software? As I'm not generating a list of computers, just a list of the approved software that I allowed on the GUI console. Thank you
|
|
Rank: Freeware Member
Groups: Member
Joined: 9/5/2008
Posts: 21
Location: Bathurst, NSW, Australia
|
Why not make the subquery a left join and then condition a tblapprovedsoftware.software= NULL?
|
|
|
Guest |
