This report provides the detailed summary for the Sensitive Types scanned in DBMS data sources. The report is divided into three sections.
You can apply filter by clicking the icon on the top left corner of the report. On clicking, it will display two dimensions based on which the data in the report can be filtered.
Sensitive Type – This filter displays the list of sensitive types which were scanned during the process.
Source Type – This filter lets you opt for all or specific source systems, as per requirement.
If you want to select a Source type, check the checkbox available with the option displayed. Using this option, you can filter out the data in the report based on the Source Type selected.
The first section in the report displays the list of sensitive types scanned in all DBMS source systems. The data is represented in the form of bar chart which displays the total number of columns scanned where the sensitive type was detected.
For example, in the below screenshot, the sensitive type Address was scanned in 272 columns of DBMS source systems. Similarly, Custom_CCNO was scanned in 14 different columns.
Hovering over any bar, displays the data label with the name of sensitive type and the number of scanned columns where it was detected.
To drill-down the report at Source and Database level, click Plus icon in the bottom left corner of the chart.
Click Plus icon once to drill-down the report at source level. This displays the number of scanned columns in a source system where sensitive types were detected. Hover over any bar, displays the data label having information about the name of the Source, Sensitive Type, and the number of Scanned Columns.
E.g., in the above screenshot, the sensitive type Address was detected in two source systems i.e. Oracle and Teradata. Also, the total count of scanned columns for each database is given. For an instance, in Oracle-192.168.1.208 source system the Address was scanned in 206 columns. Similarly, in Teradata 66 columns were scanned where Address was detected.
Click Plus icon twice to drill-down the report at more granular level where you can view data at both Source and Database level. Here, you can view the count of scanned columns at different database level where sensitive type was detected.
You can hover over any bar, to view the data label that provide details such as the name of the Sensitive Type, Database Name, Source details and the number of scanned columns.
E.g., in the above screenshot, the sensitive type Address was detected in two source systems i.e. Oracle and Teradata. Also, the total count of scanned columns for each database is given. For an instance, in Teradata-192.168.1.20 source system total 27 columns were scanned in DBC database where sensitive type “Address” was detected.
To view the data at Sensitive Type level again, click Minus icon on top left corner of the chart.
To sort the data in the chart in ascending or descending order, hover over the label name of y-axis and click the option as required.
The first option sorts the data in ascending order
The second option sorts the data in descending order
The third option let you view the bar chart data in the tabular form. It allows you to view data in two tabs:
The Summary tab provides the list of sensitive type along with their count which were detected during scanning. To download the data in the text file, click Download all rows as text file hyperlink.
The Full Data tab provides the list of all sensitive types along with their count in each source systems which were detected during the scanning. To download the data in the text file, click Download all rows as a text file hyperlink.
To view the detailed version of this report, check the Show all columns checkbox.
The second section in the report displays the data in form of pie chart. This chart displays the name of the sensitive type and the count of scanned columns where it was detected during the process.
Hovering over the section of a pie chart, displays the details such as name of the Sensitive Type and the count of Scanned Columns.
The third section in the report displays the information in the tabular form for all the sensitive types that are discovered within the source system. This report displays the name of the sensitive type and their number of occurrences in total number of scanned columns for each database which associated to a particular source system.
E.g., in the below screenshot, total 513 occurrences of Address sensitive types were found in 27 columns of DgControl database for Oracle-192.168.1.208 source system. Similarly, in the same source system the total of 6128 count address sensitive types was detected in 179 columns of DSM Administrator database.
To view the report where table and column name are listed in which the sensitive type was detected, select the database name specified in the Database Column. Hover the cursor over the selected database name, this displays the data label having a hyperlink named as ‘DrillDown-> <source> - <database name>’.
Once you click the hyperlink, it will re-direct you to the new report which will provide information at Table and Column level. This report will be specific to the selected record.
The data label with the hyperlink can also be viewed on selecting any Scanned Columns or Sensitive Count.
E.g., when you click the DrillDown-Oracle-192.168.1.208-DGCONTROLLER, it is re-directed to the new report which has data for the selected record. In the bottom table, all the column names are listed with their table names where sensitive type was scanned. Apart from this, the occurrence of sensitive type in each column is also mentioned in Sensitive Count column.
You can hide the Database Name by clicking the Minus icon in the column header next to the Source. Similarly, you can also hide the Source column by clicking the same icon next to the Sensitive Type column.
Similarly, if you want to unhide the Database Name, click Plus icon in the column header next to the Source.
To sort the values in ascending or descending order within the table, click Sort icon before to the column names. If you want to sort the data in ascending order i.e. A-Z, then the symbol on the icon will be displayed as .
If you want to sort the values in descending order i.e., Z-A, then the symbol on the icon will be changed as .