How to get a list of installed software in a domain

[Nikki]

Hi,
I need to get a report on list of software installed in a domain. How do I get this report. Please help.
Thanks,

[Hemoco · Accepted solution]

Please try the report below. Replace "YourDomain" with the domain you're after.

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