Software by OU

[mattgbarnes]

We seperate our domain by division in AD and I'd like to do a software inventory for each OU. Does anyone have a report for it? Thanks!!

[mattgbarnes]

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.

Thanks,
Matt

[Hemoco]

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.

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

[Hemoco · Accepted solution]

Try this

Select tblADComputers.OU, 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
Order By tblADComputers.OU, tblSoftware.softwareName,
tblSoftware.SoftwarePublisher, tblSoftware.softwareVersion

[TerrellYoung]

Thanks for saving my day.