‎11-04-2011 12:00 PM
‎11-04-2011 02:37 PM
essdeeay wrote:
I would like to ignore all minor version differences of software and treat them all as one. Can it be done yet?
Select Top 1000000 tblSoftware.softwareName As Software,
tblSoftware.SoftwarePublisher As Publisher, Count(tblSoftware.ComputerName) As
Total
From tblSoftware Inner Join
tblComputers On tblSoftware.ComputerName = tblComputers.Computername
Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername
Group By tblSoftware.softwareName, tblSoftware.SoftwarePublisher
Order By tblSoftware.softwareName
essdeeay wrote:
Also, we only have a smallish network but there are 1,296 software titles listed - I can't manage this many! Can some be set to "ignore" - things like the standard Microsoft .NET stuff which is free anyway?
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now