Request to create a computer policies custom template by adding OU which we want to filter only for Domain controllers

Hello,

Someone is looking at your request and will respond shortly.

Thank you!

Hello again,

I am working on a custom query report for this as the Security Policy report type does include OU for filtering.

Can you please confirm the version of the product you are using? Thank you.

Hello,

I have prepared a custom report based on your request. Please download from the following location:

https://www.quest.com/community/products/enterprise-reporter/m/custom-reports/185#

Let me know if you have any comments or questions.

Thank you.

Hi Angela, Thank you for providing the custom report. Currently we are using the product version of 2.5.1. I have tested the custom report and I was unable to set the parameter for OU, seems like no option to select OU and I also ran the report and noticed that the report only generated for computers not for domain controllers. Appreciate if you can modify the report.

Hello again,

I have now created two reports for you to try with Enterprise Reporter v2.5.1.

1) Audit Policies by Organizational Unit.
This is created for Enterprise Reporter v2.5.1. Note: In order to use the organizational unit filter there is a SQL statement you have to run on the database. Instructions for this are included with the report definition, which can be download here:
www.quest.com/.../186

2) Computer Policies for Domain Controllers.
I have customized the library report "Computer Policies" by adding a hidden filter for server type that contains "Domain Controller". By using this report you do not have a dependency on running the Active Directory discovery.
Download here: www.quest.com/.../187

Let me know if you need anything further.

Thank you.

Hi, I tried both but still not working. 1st report still the same cannot filter by OU and the 2nd report gives me the empty report. Please advise.

Hello,
I apologize for the issues you are experiencing.

For the first report did you run the SQL statement I included in the report description. The OU filter is not supported in v2.5.1 so you need to run the following statement on your Enterprise Reporter database.

INSERT INTO dbo.tblCustomQueryParameters
VALUES('OU', 'Full Canonical Name', 'Declare @UserSupplied nvarchar(255) Select CanonicalName From tblDomainOU WHERE CanonicalName like @UserSupplied ORDER BY 1 ASC')
Also please confirm that you have run both the Active Directory and Computer discoveries.

For the second report this is triggered off of the computer attribute "ServerType" and the hidden filter looks for a server type that contains "Domain Controller".

Let's try to get the first report working for you. Please run that SQL statement and let me know how things work.

If issues persist I would suggest you contact support directly and a support engineer will be able to help you.

Thank you.

Hi Angela,

This SQL statement is already in the database and we have both Active Directory and Computer discoveries run in enterprise reporter. Can you provide me your email address so that I can forward the screen shot so that you can have look on it.

Kindly advise.

Hello,

Again apologies for the issues you are experiencing. Please contact your support rep directly and they will be able to diagnose the issue and provide specific information to the R&D team.

Thank you.
-Angela