cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
MrVal
Engaged Sweeper III
Can we have the parent OU's generate a report as well? So I can get a list of all PC's within that OU and all child OU's?
1 REPLY 1
Hemoco
Lansweeper Alumni
This is not currently possible, but we have added this feature to our customer wish list. A workaround for now is to create a custom report that covers both parent and child. An example report can be seen below.
Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, tblComputers.Description, Web40OSName.OSname As OS, Web40OSName.SP, web40ProcessorCapacity.NrOfProcessors As [Proc], web40ProcessorCapacity.MaxClockSpeed As Speed, web40CorrectMemory.Memory, tblComputers.LastknownIP As IP, tblComputers.Lastseen From tblComputers Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join web40ProcessorCapacity On web40ProcessorCapacity.Computername = tblComputers.Computername Left Join web40CorrectMemory On web40CorrectMemory.Computername = tblComputers.Computername Left Join tblADComputers On tblComputers.Computername = tblADComputers.Computername Where tblADComputers.OU Like '%ParentOU%' Order By tblComputers.ComputerUnique

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.