→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

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

View solution in original post

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