0.Collection Job Group

The MySQL Solution Collection group collects high level summary information from targeted MySQL Servers. Other jobs in the MySQL Solution Set use this information for further analysis and to produce respective reports.

The jobs in the 0.Collection Job Group are:

• MySQL_Configuration Job – Collects MySQL server instance and database configuration settings for use in the following analysis jobs and respective reports
• MySQL_SensitiveDataScan Job – Discovers sensitive data in MySQL databases based on pre-defined or user-defined search criteria
• MySQL_TablePrivileges Job – Collects MySQL table privileges from all the targeted servers.

Workflow

1. Set a Connection Profile for the 0.Collection Job Group with the permissions listed in the Recommended Configurations section. See the Connection topic for additional information.
2. For Sensitive Data Discovery Auditing – Ensure the Sensitive Data Discovery Add-On is installed on the StealthAUDIT Console server.
3. Schedule the solution to run daily or as desired.
4. Review the reports generated by the jobs.