Skip to main content

Task Instances

The Task Instances tab displays the detailed information specific to the task.

Select the module from the Select Module drop-down.  You can view the details of three modules – RDBMS, RDS and Azure. It displays the list of all the task instances and the name of the Column and Table across which the data was detected. Different tabs display other set of information such as sensitive type discovered, count of hits for each sensitive type in the selected collection, unique count of each sensitive type, error logs in case of any error, names of the tables which do not contain sensitive information, etc.

  1. Task Instances Panel

    The Task Instances Panel displays the details of the task instances, e.g., ID, Name, Status etc. Select the task to view the details. Details of the task will appear in the bottom panel. The Status field in the panel displays the task status. Following are the available values:

    1. Started- This status will be displayed when scanning is initiated.

    2. Running - This status will be displayed when scanning is in process.

    3. Pause – This status will be displayed when the user paused the execution of the task.

    4. Completed with Errors – This status will be displayed when scanning is completed with errors. An error can occur due to any of the reasons such as missing privileges on the scanned tables, external table, missing tables, etc. In this scenario, the logs are generated in the Logs tab with error message and its description.

    5. Completed This status will be displayed when scanning is completed successfully without any errors.

    6. Failed – This status will be displayed when any task fails due to connection error, database connection error, server issue, etc. In this scenario a log is generated in the Logs tab with error message and its description.

       

    7. With Results: Check the With Results checkbox to view only those instances of the tasks in this panel, for which the results get generated.

    8. Results Review: When the Results Review checkbox is checked, the Results Review Status column appears in the Detailed Results tab in the panel below.

    9. Click Maximize icon to see this panel in full screen. Click Double Window icon to resize the panel.

    10. Click Refresh icon to refresh the Task Instances panel with the updated information.

    11. Click Resume icon to resume the paused task. This icon will appear when the Status of the task is Paused.

    12. Click Pause icon to pause a running task. This icon will appear when the Status of the task is Running.

    13. Click this icon to queue the task for result review. This option allows you to queue the task for results review, manually. Once the task has been queued for results review, after completion, the same could be seen in the Results Review Status column in the Detailed Results tab below.

    14. Click Execute icon to execute a task again. This triggers the selected instance of the task again.

  2. Overview Panel

This panel displays information associated to the task selected in the Task Instances panel. It shows data under the following tabs:

  1. Details: This tab displays information of all the instances for the task that have been executed to detect sensitive data. It contains four sub-tabs.

    1. Details: This sub-tab displays information of all the instances for the task that have been executed to detect sensitive data. It displays ID (system generated), Task Name, Status, Start Time, Remediated, etc. information.

       

    2. Connections: This sub-tab displays information for the connections that are associated with the task. It displays name of the connection, connection type, and host name. To view all the database/schemas selected for the selected connection, click the expand arrow available with the connection name. 

       

    3. Policies/Sensitive Data Types: This tab displays the name of the policies and sensitive data types associated with the tasks.

       

    4. Database Object Filter: The tab displays only those databases/tables/columns that match the filter applied. The columns display information such as, Operator, Connection Information, Table/View operator, Table/View Filter, etc.

      This tab displays the progress bar for the scanning. The progress bar displays the total number of tables and the databases scanned during the detection process. Click the Cancel button if you want to stop the execution of the task. 

       

  2. Results: This tab provides the summary of the detection task performed. It gives the information about the Sensitive Data discovered in the selected database during the detection process. Apart from the Sensitive Data Group column, it also gives details about the Database name, Table name to which the Sensitive Type Group is associated to; The column name, which is associated to the Sensitive Type Group, the Sensitive Group Confidence, etc. There are some other functionalities, click the Three Dot icon on top right corner of the panel to view the options.

     

  3. Result Summary: This tab provides a graphical representation of the data which was scanned during the detection process. It shows the graphical representation in the form of pie chart. The chart consists of the list of all the sensitive data which are discovered. It also lists down the other information such as the Task Name, Search Type, list of Sensitive Data, number of scanned tables, etc.

    The Sensitive Data Detected field displays the list of all the selected Sensitive Types detected during the detection process.

    Hovering over the pie chart displays the name of the Sensitive Type and its column count. To download this report in PDF format, click the Export As PDF button.

  4. Detailed Results: This tab provides the in-depth information of the Sensitive types discovered during the task execution. A user can view the details for each sensitive type discovered such as Hostname, Database name, Table Name, Column Name, etc. Using this tab, you can review results, upload a safelist, edit an existing safelist, and view the summary of the results in the form of pie chart.

    There are few other common functionalities through which you can sort the column header, filter the data, download the results in CSV or PDF format etc. To know more, visit RDBMS Common Controls.

     

The Safelist feature in PK Protect allows you to mark the column as safe if the data in that column is not sensitive and will not expose the crucial information of the user. There are two ways to mark the column name as safe.

  1. By uploading the safelist file through the Upload Safelist option.

  2. By editing the current safelist through the Edit Safelist option.

     

  3. Upload Safelist: This option allows you to upload the file containing the list of records which are marked as safe i.e., they do not hold any sensitive information. To upload the safelist, perform the following steps.

    1. Click the Export As CSV option to download the results data as CSV file.

    2. Open the downloaded file and mark the records as safe by changing the value under the Safe column to ‘Y’ i.e., YES. This marks the specific records as non-sensitive in the table.

       

    3. Click the Upload Safelist button to import the data file containing the list of all records which are either marked as safe or not. The Import Sensitive Data dialog box appears.

    4. Now, click the Browse button to select the file on your machine and click Import button to upload the data file with the changes.

       

    5. The updated file changes are displayed in the Detailed Results tab. The records which are marked as safe will be greyed out in the tab.

  4. Edit Safelist: This is the second way of editing a safelist in the PK Protect. This option allows you to mark the records as safe within the PK Protect. The list of records which are marked as safe or not, will be displayed in the Safelist for Detection panel when the Edit Safelist button is clicked.

    When Edit Safelist button is clicked, the Safelist for Detection panel appears. Perform the following steps to edit the Safelist.

     

    1. Click the Edit Safelist button and the Safelist for Detection panel appears. The list of all the records which are marked as safe or not will be displayed in the Safelist for Detection panel.
      This panel is divided into two sections. The top section contains the total number of records available after the detection process has been completed and the bottom section contains the list of records which are marked as safe i.e., they do not hold any sensitive data.

    2. Check the checkbox available with the record which you want to mark as safe and click Add to Safelist. This adds the selected records in the Columns Marked as Safe section by marking them as non-sensitive.

    3. To remove the selected records from the Columns Marked as Safe section, check the checkbox available with the record which need not to be marked as safe and click Remove from Safelist button.

    4. Click the Save button to make the changes effective. The changes are reflected in the Detailed Results tab. The records which are marked as safe will be greyed out.

  5. Review Results: The Review Results button allows the user to review any result in the Detailed Results tab. This button provides functionality of declaring records non-sensitive, sensitive or increasing/decreasing the confidence factor. To remediate any result, perform the following steps:

     

    1. Select the result in the Detailed Results tab and click the Review Results button. On clicking this button, review results pop-up appears.

       

    2. Now, enter the details for Results Review Action and Results Review Value (%) field in the pop-up.

      The Host Name, DB Name, Table Name, Field Name and Sensitive Type fields are already populated. Following are the options in Results Review Action field.         

      1. Mark as Non-Sensitive: Select this option to mark the record as Non-Sensitive. The system ignores these records in future re-run.

      2. Mark as Correct: Select this option to mark the record as Sensitive. The system does not ignore these records in future re-run.

      3. Decrease the Confidence Factor: Select this option to decrease the confidence factor in Results Review Value (%) field.

      4. Increase the Confidence Factor: Select this option increase the confidence factor in Results Review Value (%) field.

        The Results Review Value (%) field will be enabled when Decrease Confidence Percentage or Increase Confidence Percentage is selected in the Results Review Action field. Enter the results review value in percentage.

        This field will be enabled when you select Decrease or Increase the Confidence Factor in Results Review Action field. Once the results review value has been set and saved, the same can be seen under Saved Results Review tab. To know more about Saved Results Review tab, visit Saved Results Review section.

  6. Skipped Columns: This tab displays the list of all the column names which are skipped during the process because they do not hold any sensitive data. This tab also displays the name of the database and the table to the connection which they are associated to as well as the data type for the column name.

     

  7. Logs: This tab lists the errors which are occurred during the task execution. This tab gets populated when a task is either completed with errors or failed due to some reason. It displays the database name, directory path, table name, error description, etc.

  8. Data Scanned: This tab displays the list of all the tables which are scanned during the Detection process. It displays the Hostname, Database name, table name, number of rows scanned, etc.

     

  9. Non-Sensitive Scanned Tables: This tab lists down the table names along with database name which were not scanned because they do not hold any sensitive information. The details contain the Hostname, Database Name, Directory Path, and the Table name.

  10. Metadata Results: This tab displays the list of all the columns names along with the other information such as column size, column type, constraints (primary key, foreign key, surrogate key etc.). This tab displays the association of a column name with a table and database name. The highlighted records in the tab are the results of Metadata Discovery.

  11. Metadata Relation Results: This panel displays Relation column based on which a relationship between the child and parent tables can be inferred. The Relation column display the name of the column along with the key type. It also includes other information such as column names as Child Column, Parent Column and Relation.

  12. Topic Results: This panel displays the results for Topics detected in the structured databases along with the threshold of each detected topic. This panel displays the list of all databases names under which the topic is detected along with the name of the table, subcategory count and sub-category proportion count.

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.