Software by organizational unit

[SimplyClueless]

Hello- I have been searching the forums and I have seen a few posts; but nothing very salient for my situation;

I need to pull internet explorer versions; filtetered by OU; That is to say;

"I want to see all computers that are running internet explorer 10 in the Utah OU"

I have never been able to join an OU query properly; any help would be much appreciated-thanks!

[Hemoco · Accepted solution]

Please use the following report. Replace the red word with the ou path that you want to filter on.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblADComputers.OU,
tblSoftwareUni.softwareName
From tblAssets
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 tblADComputers.OU = 'ou path' And tblSoftwareUni.softwareName =
'Windows Internet Explorer 10'