 Rank: Administration Groups: Administration, Premium Users
Posts: 10,378
|
Please try the report below. Replace "YourDomain" with the domain you're after. Quote:Select Top 1000000 tblSoftware.softwareName As Software,
tblSoftware.softwareVersion As Version, 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
Where tblComputers.Domain = 'YourDomain'
Group By tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher
Order By Count(tblSoftware.ComputerName) Desc
|
