Skip to main content

PgSQL_SensitiveData Job

The PsSQL_SensitiveData Job is designed to provide information on all the sensitive data that was discovered in the targeted PostgreSQL servers based on the selected scan criteria.

Analysis Tasks for the PgSQL_SensitiveData Job

Navigate to the Jobs > Databases > PostgreSQL > Sensitive Data > PgSQL_SensitiveData > Configure node and select Analysis to view the analysis tasks.

CAUTION: Do not modify or deselect the selected analysis tasks. The analysis tasks are preconfigured for this job.

pgsqlsensitivedataanalysis

The default analysis tasks are:

  • Sensitive Data Details - Returns details around sensitive data in PostgreSQL
  • Database Summary - Summarizes sensitive data in PostgreSQL by database
  • Enterprise Summary - Summarizes PostgreSQL sensitive data for the organization

In addition to the tables and views created the analysis task, the PgSQL_SensitiveData Job produces the following pre-configured report.

ReportDescriptionDefault TagsReport Elements
Enterprise SummaryThis report shows a summary of the criteria matches found in the EnterpriseNoneThis report is comprised of two elements: - Bar Chart – Displays exceptions by match count - Table – Provides exception details
Sensitive Data OverviewThis report highlights objects which contain sensitive data crtieria.Sensitive DataThis report is comprised of three elements: - Bar Chart - Displays top databases by Sensitive Data Hits - Table - Provides information on databases with sensitive data - Table - Provides details on sensitive data