‎11-21-2011 07:38 PM
Solved! Go to Solution.
‎11-29-2011 03:04 PM
dteague wrote:
I don't think this will not work for me, as I would have to know what version I am wanting to look for. What I wrote is more dynamic, and would find what the newest version I had, and display all the ones that do not match.
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Order By tblSoftware.softwareName Desc, tblSoftware.softwareVersion Desc
‎11-28-2011 06:59 PM
Select Distinct Top 1000000 dbo.tblSoftware.softwareName As Software,
dbo.tblSoftware.softwareVersion As Version,
Count(dbo.tblSoftware.SoftwareID) As Total
From dbo.tblSoftware
Inner Join dbo.tblComputers
On dbo.tblSoftware.ComputerName = dbo.tblComputers.Computername
Inner Join dbo.web40ActiveComputers
On dbo.tblComputers.Computername = dbo.web40ActiveComputers.Computername
Where dbo.tblSoftware.softwareName Like 'java%'
Or dbo.tblSoftware.softwareName Like '%j2se%'
Or dbo.tblSoftware.softwareName Like '%jdk%'
Or dbo.tblSoftware.softwareName Like 'adobe acrobat%'
Or dbo.tblSoftware.softwareName Like 'macromedia shockware%'
Or dbo.tblSoftware.softwareName Like 'mcafee%'
Or dbo.tblSoftware.softwareName Like '%forefront%'
Or dbo.tblSoftware.softwareName Like 'adobe air%'
Or dbo.tblSoftware.softwareName Like 'adobe flash player%'
Or dbo.tblSoftware.softwareName Like 'adobe reader%'
Or dbo.tblSoftware.softwareName Like 'adobe shockwave%'
Group By dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion
Order By dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion
‎11-28-2011 08:14 PM
joegasper wrote:
I use the following to give me a list of all the commonly exploitable software and my anti-virus installations:Select Distinct Top 1000000 dbo.tblSoftware.softwareName As Software,
dbo.tblSoftware.softwareVersion As Version,
Count(dbo.tblSoftware.SoftwareID) As Total
From dbo.tblSoftware
Inner Join dbo.tblComputers
On dbo.tblSoftware.ComputerName = dbo.tblComputers.Computername
Inner Join dbo.web40ActiveComputers
On dbo.tblComputers.Computername = dbo.web40ActiveComputers.Computername
Where dbo.tblSoftware.softwareName Like 'java%'
Or dbo.tblSoftware.softwareName Like '%j2se%'
Or dbo.tblSoftware.softwareName Like '%jdk%'
Or dbo.tblSoftware.softwareName Like 'adobe acrobat%'
Or dbo.tblSoftware.softwareName Like 'macromedia shockware%'
Or dbo.tblSoftware.softwareName Like 'mcafee%'
Or dbo.tblSoftware.softwareName Like '%forefront%'
Or dbo.tblSoftware.softwareName Like 'adobe air%'
Or dbo.tblSoftware.softwareName Like 'adobe flash player%'
Or dbo.tblSoftware.softwareName Like 'adobe reader%'
Or dbo.tblSoftware.softwareName Like 'adobe shockwave%'
Group By dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion
Order By dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion
‎11-28-2011 04:36 PM
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblSoftware.softwareName
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblSoftware.softwareName Like 'java(TM) 6%' And
tblSoftware.softwareName Like '%Update%' And tblSoftware.softwareVersion Not
In (Select Top 1 tblSoftware.softwareVersion From tblSoftware
Where tblSoftware.softwareName Like 'java(TM) 6%' And
tblSoftware.softwareName Like '%Update%' Order By
tblSoftware.softwareVersion Desc)
Order By tblSoftware.softwareVersion, tblComputers.Computername
‎11-28-2011 05:54 PM
dteague wrote:
Do you see any issue with this?Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblSoftware.softwareName
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblSoftware.softwareName Like 'java(TM) 6%' And
tblSoftware.softwareName Like '%Update%' And tblSoftware.softwareVersion Not
In (Select Top 1 tblSoftware.softwareVersion From tblSoftware
Where tblSoftware.softwareName Like 'java(TM) 6%' And
tblSoftware.softwareName Like '%Update%' Order By
tblSoftware.softwareVersion Desc)
Order By tblSoftware.softwareVersion, tblComputers.Computername
This would give me a list of all machines that don't have the latest version that at least 1 machine in my network has. It won't tell me if there is a new version, but will give me a list of all that don't match whatever the newest version I have on at least 1 machine.
So you see anything wrong with it?
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain
From tblComputers
Where tblComputers.Computername Not In (Select tblSoftware.ComputerName
From tblSoftware Where tblSoftware.softwareName Like '%YourSoftware%')
Order By tblComputers.ComputerUnique
‎11-28-2011 08:11 PM
Lansweeper wrote:
The report should be written like the one below. Replace "YourSoftware" with the software package you want to report on. The query will then return a list of computers that do not have this software package installed.Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain
From tblComputers
Where tblComputers.Computername Not In (Select tblSoftware.ComputerName
From tblSoftware Where tblSoftware.softwareName Like '%YourSoftware%')
Order By tblComputers.ComputerUnique
‎11-29-2011 03:04 PM
dteague wrote:
I don't think this will not work for me, as I would have to know what version I am wanting to look for. What I wrote is more dynamic, and would find what the newest version I had, and display all the ones that do not match.
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Order By tblSoftware.softwareName Desc, tblSoftware.softwareVersion Desc
‎11-23-2011 03:44 PM
dteague wrote:
I wish there was a report that would tell me computers that needed updated for Java - Flash - Adobe.
‎11-28-2011 02:39 PM
Lansweeper wrote:
This cannot easily be accomplished.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now