The IDERA SQL Compliance Manager SQL Compliance Manager Agent Details window lets you view a subset of SQL Compliance Manager Agent properties. To view all properties for the SQL Compliance Manager Agent, use the Management Console.
- Name of the virtual SQL Server audited by this SQL Compliance Manager Agent
- Name of the Collection Server computer that is processing events collected by the SQL Compliance Manager Agent
- Name and location of the trace directory where the SQL Compliance Manager Agent is storing trace files
- Name and location of the CLR trigger assemblies used to collect before and after data for audited DML events
- Name of the SQL Compliance Manager Agent Service under which the SQL Compliance Manager Agent is running
- Name and path of the SQL Compliance Manager Agent Service registry key that is replicated across the cluster nodes
Available actions
To copy either the SQL Compliance Manager Agent Service name or the registry key, click the copy button beside the corresponding field, and then click OK.
Copy the SQL Compliance Manager Agent Service name
Allows you to copy the name of the SQL Compliance Manager Agent Service to your clipboard. Use this feature to specify the service name when registering the SQL Compliance Manager Agent Service through Microsoft Cluster Administrator. You can paste the copied service name into the required field.
Copy the SQL Compliance Manager Agent Service registry key
Allows you to copy the path of the SQL Compliance Manager Agent Service registry key that will be replicated across the cluster nodes. The registry path is copied to your clipboard. Use this feature to specify registry replication when registering the SQL Compliance Manager Agent Service through Microsoft Cluster Administrator. You can paste the copied service name into the required field.