How do I get a software report for computers in an OU

[James847]

I would basically like to get a report for software installed on computers located in an OU. Is this possible..... I have several computer OU's for different offices and would like to see what software each office is using and how many licenses. I am new to this and any help you can provide will be appreciated.

[Hemoco]

Please use this sql code:

Select Top 1000000 tblADComputers.OU,
tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher,
Count(tblSoftware.SoftwareID) As Total
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblAssetCustom.State = 1
Group By tblADComputers.OU,
tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher
Order By tblADComputers.OU,
tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher