cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
mattgbarnes
Engaged Sweeper
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!!
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

4 REPLIES 4
mattgbarnes
Engaged Sweeper
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
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
Lansweeper Alumni
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

Thanks for saving my day.

I'm in a tight spot with limited time to finish my research paper. I found a solution online at https://studyclerk.com/pay-for-research-paper website. This is a great help because it lets me pick the right writer for my paper, and they're really good at meeting deadlines.