Creating Your Own Custom Reports

 

• Overview

• Actions by Locations

• Example Report 1: Social Security Numbers

• Age Profiling

• Example 2: Discover the Age of Your Records

• Classifications by Location

• Data Type Summary

• Matches by File Type

• Matches by Location (Structured)

• Matches by Location (Unstructured)

• Creating Your Own Custom Reports

Overview

Sensitive Data Platform (SDP) Custom Reports can be created to support different use cases for your data.

Use cases and report details are provided below.

Actions by Locations

Match locations with remediation or management actions applied via playbooks:

• Endpoints:

  • Target Name

• Locations:

  • Location

  • Classifications

• Matches:

  • Data Type Name

  • Match Count: Aggregate: Sum

  • Resolution

  • Action

  • Action Start Date/Time

• Filter(s):

  • Resolution

  • Does Not Equal

  • Unmanaged

Example Report 1: Social Security Numbers

Create a report that shows which company laptops contain Social Security Numbers (SSN)

Using the Matches by Location you can determine the physical location of specific data value(s): Which company laptops have Social Security Numbers (SSN) on them?

1. Click Add Report.
   
   

2. The Create Report wizard is displayed.

3. On the Basic Information screen, our example uses the following:

   • Name: SSN Location

   • Description: Which company laptops contain Social Security Numbers
     
     

4. Click Next .

5. In the Columns Setup screen Available Columns section, select the following to move to the Selected Columns section:

6. Locations Settings:

   • Match Count

   • Location

7. Matches:

   • Data Type
     
     

8. Click Next .

9. On the Filters screen, add the following:

10. From the left column, select Data Type from the drop-down list.
    
    

11. From the center column, select Contains from the drop-down list.
    
    

12. From the right column, click the ellipse to open the Select Items pop-up window.
    
    

13. In the Select Items pop-up window:

    1. Enter Social in the search box.
       
       

    2. In the left column, locate Social Security Number and click the right arrow to select the value.
       
       

    3. Click OK to add.
       
       

14. Click Next .

15. On the Export Schedule screen, leave the No Schedule (Export manually) option selected to manually run the report. (See Working with Custom Reports for other scheduling options.)
    
    

16. Click Next.

17. On the Summary screen, click Generate Report Preview to preview your report (optional).
    
    
    

18. Click Confirm to generate the preview.
    
    

    Note: The report preview will load up to 100 rows of data for review. For complex reports this can take several minutes to complete.

19. The report preview is displayed.
    
    

20. Click Finish & Save to save the report.

21. To view the report:

    1. Locate the new report in the Custom Reports section.

    2. Click the more options menu then click View Report.
       
       

22. To export the report:

    1. Locate the new report in the Custom Reports section.

    2. Click the more options menu then click Export Report.
       
       

23. A Report Export notification message is displayed.
    
    

    Note: It may take several minutes to generate the report. You can view the report progress in the REPORT DOWNLOADS tab.

24. You receive an email notification when the report is ready.
    
    

25. Locate your report in the REPORT DOWNLOADS tab and click on the link to download to your computer to use the data in your report software.
    
    

Age Profiling

Modified date of unstructured match result locations:

• Endpoints: Target Name

• Locations: Location

• Locations: Date/Time Modified

• Locations: File Owner

• Filter(s):

  • Date/Time Modified

  • Not Empty

Example 2: Discover the Age of Your Records

Use Date/Time Modified to discover the age of your records.

Procedure:

1. Click Add Report.
   
   

2. The Create Report wizard is displayed.

3. In the Name box, type the name of the report.

4. In the Description box, type a summary of intent of the report, such as the age of the records.

5. Click Next.

6. In the Columns Setup page Available Columns section, move the following columns to the Selected Columns section:

   • Endpoints: Target Name

   • Locations: Location

   • Locations: Date/Time Modified

   • Locations: File Owner
     
     

7. Click Next.

8. On the Filters screen, select Date/Time Modified and Not Empty from the drop-down lists.
   
   

9. Click Next.

10. On the Export Schedule screen, leave the No Schedule (Export manually) option selected to manually run the report. (See Working with Custom Reports for other scheduling options.)

11. Click Next.

12. On the Summary screen, click Generate Report Preview to preview your report (optional).

    Note: The report preview loads up to 100 rows of data for review. For complex reports this can take several minutes to complete.

13. Click Finish & Save to save the report.

14. To view the report:

15. Locate the new report in the Custom Reports section.

16. Click the kebab menu then click View Report.
    
    

Export the Report

Procedure:

1. To export the report:

2. Locate the new report in the Custom Reports section.

3. Click the kebab menu then click Generate Export.
   
   

4. A report notification message is displayed.
   
   

   .Note: It may take several minutes to generate the report. You can view the report progress in the Downloads tab.

5. When the report is ready you will receive an email notification.
   
   

6. Locate your report in the REPORTS DOWNLOAD tab. Click the link to download the ZIP file to your computer to use the data in your report software.
   
   

Classifications by Location

• Individual locations with classification labels

• Endpoints: Target Name

• Locations: Location

• Locations: File Type

• Locations: Classifications

• Filter(s):

  • Classification Names

  • Is Not Empty

Data Type Summary

Count of matches found for each data type:

• Matches: Data Type Name

• Matches: Match Count

  • Aggregate: Sum

• Filter(s):

  • N/A

Matches by File Type

Total match count by file type:

• Locations: File Type

• Locations: Match Count

  • Aggregate: Sum

• Filter(s):

  • N/A

Matches by Location (Structured)

Match summary of structured data scans:

• Endpoints: Target Name

• Locations: Location

• Matches: Database Column Names

• Matches: Data Type Name

• Matches: Match Count

  • Aggregate: Sum

• Locations: Classifications

• Filter(s):

  • Database Column Name

  • Is Not Empty

Matches by Location (Unstructured)

Match summary of unstructured data scans:

• Endpoints: Target Name

• Locations: Location

• Matches: Data Type Name

• Matches: Match Count

  • Aggregate: Sum

• Locations: Classifications

• Locations: File Type

• Locations: Internal Location Type

• Locations: Date/Time Created

• Locations: Date/Time Modified

• Locations: Date/Time Accessed

• Locations: File Owner

• Locations: File Size

• Filters(s):

  • Internal Location Type

  • Does Not Equal

  • Database Table