‎05-31-2010 02:08 PM
‎06-08-2010 12:43 PM
‎06-04-2010 04:44 PM
Select Top 1000000 dbo.tblSoftware.softwareName As Software, dbo.tblSoftware.softwareVersion As Version, dbo.tblSoftware.SoftwarePublisher As Publisher, Count(dbo.tblSoftware.ComputerName) 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 Group By dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion, dbo.tblSoftware.SoftwarePublisher Order By Count(dbo.tblSoftware.ComputerName) Desc
‎06-04-2010 03:47 PM
‎06-03-2010 04:11 PM
‎06-03-2010 02:23 PM
‎05-31-2010 05:26 PM
‎05-31-2010 03:35 PM
‎05-31-2010 03:23 PM
‎05-31-2010 03:18 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now