report for all software on 2 OUs only

[Asdfzxcvm]

hi everyone,

I tried to get a list of all the software installed on 2 different OUs (something similar to the general software tab where I can see a list of all the software and the total number of devices). did anyone else got something similar or helpful in this regard? I did something but it doesn't really help:

Thanks

[Asdfzxcvm]

for some reason I couldn't add the code in the original post,but there it is:

Select Top 1000000 tblAssets.AssetName,
tblAssets.IPAddress,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftware.Installdate,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where (tblADComputers.OU Like '%site1%' Or tblADComputers.OU Like '%site%')
Order By tblAssets.AssetName