Sort by OU

[fen12]

Hi,

I'm currently using the premium version and I have activated the active scanning and OU filter is set to scan 3 OUs. May I know i is it possible to sort the computer by OU?

[Hemoco]

something like this :

Select tblComputers.Computername, tblComputers.Domain, tblADComputers.OU
From tblADComputers Inner Join
  tblComputers On tblComputers.Computername = tblADComputers.Computername
Where tblADComputers.OU Like 'yourOUname'

replace yourOUname by the correct ou

[fen12]

Hi,

We have 3 OUs which contain the PCs from different countries, namely Malaysia, Singapore and Thailand. How do I create report that shows all PCs from each of these countries.

Eg, 1st report - PCs from Singapore OU
2nd report - PCs from Malaysia OU
3rd report - PCs from Thailand OU

Thanks in advance.

[Hemoco]

Please let me know which fields you want in the report.

[fen12]

Hi,

Do you have the step on how to create the report for sorting OU?

[Hemoco]

If you add the found OU to a report you will be able to sort on this field.