This report provides the detailed summary of the scanning of all the data for a specific time range, month wise. By default, the report displays the data for the current month.
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.
Date – To view the data for specific time range, enter the year and month in From_YYYYMM and To_YYYYMM textbox.
You need to enter the data in the format <Year><Month>. For instance, if you want to view the data in the report from January, 2000 to February, 2020, then it will be written as 200001 in From_YYYYMM field and 202002 in To_YYYYMM field.
Source Name – This filter lets you opt for all source systems or specific source systems, as per requirement.
Top section displays the size of scanned data along with the count of tables for all Source Names in the form of bar charts.
E.g., with reference to the above screenshot, the first row displays the total 146.83 MB of data, in eight tables, that was scanned in MySQL-192.168.0.47.
Hovering over any bar icon displays the data label that will provide the details of the scanned data. The detail includes the name of the source system, scanned size in kilobytes and the scanned size of the data in the form of tables.
To sort the data in ascending or descending order in Source Name column, click Sort icon before the Source Name column. If you want to sort the data in ascending order i.e. A-Z, then the symbol on the icon will be displayed as A-Z with downward arrow. If you want to sort the data in descending order i.e., Z-A, then the symbol on the icon changes to Z-A with downward arrow.
Similarly, to sort the bar charts based on the scanned size, click Sort icon as highlighted in the screen.
The bottom section displays the data in the tabular form. This section gives more detailed information for the scanned data by providing the total size and count of the tables in which the data was exposed, protected and safe.
This section of the report segregates the scanned data month-wise. The Server Type column will have two values, i.e. On-Premises and Cloud based on which the Source Name can be distinguished. The data size in Scanned Size column is the total of data scanned in a schema and the total number of tables scanned within schema is given in brackets.
The data in the Scanned Size (Table) column is the total of Exposed Size (Table), Protected Size (Table), and Safe Size (Table)
Scanned Size (T) = Exposed Size (T) + Protected Size (T) + Safe Size (T)
Where T stands for the Table in the report.
E.g., With reference to below screenshot, in the second row of the table for month Jul 2018, the total of 449.01 KB (i.e., 46 tables scanned) of data was scanned in TCBTest10 schema of SQLServer-192.168.6.149 which hosted on On-Premises.
To sort the data within the table in ascending or descending order, click the Sort icon next to the column header names.
To view data at month level, click the Minus icon next to the Scan Month column. This roll-up the data at month level and hide the details of the Server Type, Source, Schema Name columns.
Similarly, you can view the data at Server, Source and Schema level.