Reports by OU

[schellmp]

Need some help.... I have several containers in my OU. I need to break out HW and SW reports by OU and can't find anything on the forum. Has anyone done this that could help me?

best....

[Hemoco]

You cannot recreate the exact layout of the "Computer OU overview" webpage through a report. The closest you can get is using the report below.

Select tblComputers.Computername, tblComputers.Domain, tblADComputers.OU,
tblComputers.Computer, tblComputers.Username, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher,
tblSoftware.Installdate, tblSoftware.Lastchanged
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Inner Join
tblADComputers On tblComputers.Computername = tblADComputers.Computername
Where tblSoftware.softwareName Like '%microsoft office%' And
tblSoftware.SoftwarePublisher Like '%microsoft%'
Order By tblComputers.Domain, tblADComputers.OU, tblComputers.Computer,
tblSoftware.softwareName

[schellmp]

Awesome.... thx... Is there a way to group it by OU name? Like in the Computers by OU so I can just look at each container?

[Hemoco · Accepted solution]

OU info can be found in tblADComputers. Please try the modified report below.

Select tblComputers.Computername, tblComputers.Domain, tblComputers.Computer,
tblComputers.Username, tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher, tblSoftware.Installdate,
tblSoftware.Lastchanged, tblADComputers.OU
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Inner Join
tblADComputers On tblComputers.Computername = tblADComputers.Computername
Where tblSoftware.softwareName Like '%microsoft office%' And
tblSoftware.SoftwarePublisher Like '%microsoft%'
Order By tblADComputers.OU, tblComputers.Domain, tblComputers.Computer,
tblSoftware.softwareName

[schellmp]

So I took this sql (thanks) -

Select tblComputers.Computername, tblComputers.Domain, tblComputers.Computer,
tblComputers.Username, tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher, tblSoftware.Installdate,
tblSoftware.Lastchanged
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblSoftware.softwareName Like '%microsoft office%' And
tblSoftware.SoftwarePublisher Like '%microsoft%'
Order By tblComputers.Domain, tblComputers.Computer, tblSoftware.softwareName

is there a way to order/group by OU? I need something like the Computers by OU layout.