 Rank: Administration Groups: Administration, Premium Users
Posts: 10,378
|
mattgbarnes wrote:That report worked perfect for what I was looking for at the time. Thanks.
I was wondering if I can make seperate reports for each OU to give the total software. I'm trying to do a count on total amount of software for each OU. For software counts of a specific OU, please use the report below. Replace "YourOU" with the OU you want to report on. Quote:Select tblSoftware.softwareName, tblSoftware.SoftwarePublisher,
tblSoftware.softwareVersion, Count(tblSoftware.SoftwareID) As Total
From tblComputers Left Join
tblADComputers On tblComputers.Computername = tblADComputers.Computername
Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Group By tblADComputers.OU, tblSoftware.softwareName,
tblSoftware.SoftwarePublisher, tblSoftware.softwareVersion
Having tblADComputers.OU = 'YourOU'
Order By tblADComputers.OU, tblSoftware.softwareName,
tblSoftware.SoftwarePublisher, tblSoftware.softwareVersion
|
