I groom alerts monthly to reclaim disk space. This month when trying I get the following error . Anyone have a suggestion on what I can do or...
SQL Compliance Manager
Idera dashboard core service locking my service account
Hi, I changed the password for our service account and now notice that this account keeps getting locked and narrowed it down to the idera dashboard...
Fixed table column width on the certain Add forms.
When in database properties, the tables names in the Before-After Data tab is the only place I could extend the column to view table names. The...
Changing from auditing a node to auditing a listener
If SQL Compliance manager service is already installed on both nodes in a cluster, is there a way to change from auditing the node to auditing the...
Issue setting up Before-After Report
I want to use Idera Compliance Manager to keep an audit of who did what on some specific tables in a database. I registered my...
Fatal error during SQL Compliance Manager upgrade
When I try to upgrade SQL Compliance Manager 5.7.1 to 5.8.0, I receive “A fatal error occurred” near the end of the upgrade...
Issue with SQLcm after upgrading OS
I recently upgraded the OS on my SQLcm server to 2019. I currently have two registered servers and initially was having trouble with ...
One or more servers are in critical condition.
In Idera SQL compliance manager under System Status, I get an error message saying "One or more servers are in critical condition" When I...
Alert Statistics Report
Working on generating a report showing only alert counts total and per monitored database for a given time period. Currently, the...
Can PowerShell be used to change setting in Compliance Manager
I am looking for a way to make to various setting in Compliance Manager using poinstead on going into each monitored instance. Things I'm...
Mirror Database – How to setup SQL compliance manager on a Mirrored database.
I need to setup SQL Compliance Manager, for both the Principle and Mirrored database. I got the Principle setup just fine, but the mirror one does...
Can SQL Compliance Manager store audit logs as a flat file?
I understand that SQL Compliance Manager has a tamper proof repository to store its audit logs, but our security department uses Splunk and wants...
SQLcm Alert help
I would like to generate an alert in SQL Compliance Manager if someone attempts to login with a login that doesn't exist in SQL Server. ...
SQL Compliance Mgr – Flood of error log messages due to SQL Trace start/stop
Using SQL Compliance Manager 5.6 with SQL Server 2016 and older servers, the SQL Server error log gets flooded by messages such as: SQL Trace ID 3...
Alert request on number of failed logins in a period of time
I would like to create a login failure alert that triggers if a login results in x number of failures in a period of time, say 5 minutes. Does...
Compliance Manager Job State
What does the different state in the compliance Manger job table mean? Why are the files in the Collectionservertracefiles...
Destination URLs or IPs on the web for SQLCM
We are installing SQL Compliance Manager and our IT security guys will not allow us to open access to the Internet without a list of websites or IP...
How to audit multiple user types
At the server level, I want to audit privileged users for certain DDL, Security changes, failed logins, etc. At the same time, how can I...
Compliance Manager: Auditing Thousands of Similar Databases
I am in the process of running a POC for CM to see if it will fit our needs. We have 60,000 databases - most similar in schema - across 70 or so...
Compliance Manager and mirrored databases
I have two sets of mirrored databases that I would like to add to CM; any recommendations on how to proceed? I have single servers and clustered...
CM not unloading Program FilesIderaSQLcomplianceCollectionServerTraceFiles folder
Hi Today I noticed that I hadn't received any notification from CM in many hours. Upon further investigation (and testing by creating some...
Audit Event – DML Transaction Events are Server Level
We recently started getting a large quantity of DML Begin/Commit/Rollback Transaction Audit Events recorded. There is no database listed, the...
Filtering RESTORE LABELON
We just installed Compliance Manager in our environment and I'm working on configuring it. One of the things I'm trying to figure out...
New Login Audit Event
I'm setting up and testing Compliance Manager for the first time and trying to understand what it reports on for the default...