0.Collection Job Group

The PostgreSQL Solution Collection Job Group is designed to collect high level summary information from targeted PostgreSQL Servers. This information is used by other jobs in the PostgreSQL Solution Set for further analysis and producing respective reports.

The jobs in the 0.Collection Job Group are:

• PgSQL_Configuration Job - Designed to return additional configuration settings from PostgreSQL servers
• PgSQL_SensitiveDataScan Job - Designed to discover sensitive data in PostgreSQL databases based on pre-defined or user-defined search criteria
• PgSQL_TablePrivileges Job - Designed to collect PostgreSQL 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 Access Analyzer Console server.
3. Schedule the solution to run daily or as desired.
4. Review the reports generated by the jobs.