• State Not Answered
  • Locked Locked
  • Replies 9 replies
  • Subscribers 32 subscribers
  • Views 4594 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

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

mohamed_rizwan_mohamed_haneef
over 6 years ago

I'm referring to the enterprise reporter template for security policy under Computer Policies field.

We have an audit policy and currently this report generated data for all machine in our environment and I don't see any option to filter to selected OU. I want to apply this report only for Domain Controller OU and need your team help to modify the template by adding OU field in the report so that I can create a Parameter for OU and choose the selected OU.

 

 

 

Fields that used for the reports are per below

- Audit - Account Logon

- Audit - Account Management

- Audit - Directory Services

- Audit - Logon

- Audit - Object Access

- Audit - Policy Change

- Audit - Privilege Use

- Audit - Detailed Tracking

- Audit - System

- Domain

- Computer Name 

Parents
  • 0 over 6 years ago
    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.
Reply
  • 0 over 6 years ago
    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.
Children
No Data