Lansweeper logo
Home Download Features Demo Buy now Help Support forum
 
    Most requested support articles:
  Lansweeper troubleshooting guide.
  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  WMI Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
  How to configure the windows firewall using group policies.
  Support:  
 support@lansweeper.com  
Skype: Lansweeper  
  Mo-Fri 9h-17h CET  
Welcome Guest Search | Active Topics | Log In | Register

Untag as favorite
Reporting a list of non-allowed software
Options
Previous Topic Next Topic
Bart van den Bosch
#1 Posted : Tuesday, September 16, 2008 12:47:22 PM

Rank: Premium user

Groups: Member, Premium Users
Posts: 13
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
Back to top
Lansweeper
#2 Posted : Tuesday, September 16, 2008 1:09:22 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,379
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
Back to top
Bart van den Bosch
#3 Posted : Tuesday, September 16, 2008 1:21:51 PM

Rank: Premium user

Groups: Member, Premium Users
Posts: 13
Location: NL
[quote=Lansweeper]...quote]

Thanks, working my way through learning SQL scripting. Some examples like these will help a lot :)
Back to top
alee
#4 Posted : Tuesday, November 11, 2008 11:47:24 PM
Rank: Freeware user

Groups: Member
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
Back to top
james_mitchell
#5 Posted : Wednesday, November 12, 2008 3:37:16 AM
Rank: Freeware Member

Groups: Member
Posts: 24
Location: Bathurst, NSW, Australia
Why not make the subquery a left join and then condition a tblapprovedsoftware.software= NULL?
Back to top
Tomasz
#6 Posted : Thursday, July 01, 2010 12:12:08 PM
Rank: Freeware user

Groups: Member
Posts: 3
Hi, how can I export a list of approved software to another instance of lansweeper? Can you help me please? Thanks.
Back to top
Lansweeper
#7 Posted : Thursday, July 01, 2010 5:43:49 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,379
Tomasz wrote:
Hi, how can I export a list of approved software to another instance of lansweeper? Can you help me please? Thanks.

If you have msaccess you can directly link to the database with an ADP project and copy/paste the data.
Back to top
travis.pickle
#8 Posted : Tuesday, January 24, 2012 12:32:15 AM

Rank: Premium user

Groups: Member, Premium Users
Posts: 7
james_mitchell wrote:
Why not make the subquery a left join and then condition a tblapprovedsoftware.software= NULL?


I am trying to do this, but can not figure it out. I am just wanting a report of all approved software, number of pcs its on. I also want a report for all non approved software with, computer name , uninstall cmd linked to psexec cmd if possible. Thanks.
Back to top
Lansweeper
#9 Posted : Wednesday, January 25, 2012 6:08:36 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,379
Not approved software:

Quote:
Select tblSoftware.softwareName As Software, tblSoftware.softwareVersion As
Version, tblSoftware.SoftwarePublisher, Count(tblComputers.Computername) As
Total
From tblSoftware Inner Join
tblComputers On tblSoftware.ComputerName = tblComputers.Computername
Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername
Group By tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher
Having tblSoftware.softwareName Not In (Select tblApprovedSoftware.Software
From tblApprovedSoftware)
Order By Count(tblComputers.Computername)


Approved software:

Quote:
Select tblSoftware.softwareName As Software, tblSoftware.softwareVersion As
Version, tblSoftware.SoftwarePublisher, Count(tblComputers.Computername) As
Total
From tblSoftware Inner Join
tblComputers On tblSoftware.ComputerName = tblComputers.Computername
Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername
Group By tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher
Having tblSoftware.softwareName In (Select tblApprovedSoftware.Software
From tblApprovedSoftware)
Order By Count(tblComputers.Computername)
Back to top
Users browsing this topic
Guest
Untag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Contact: E-mail Lansweeper - Skype : Lansweeper
Copyright 2004 - 2011 © Hemoco bvba