Data Loss Prevention

 View Only

  • 1.  Specify DB Table to Scan

    Posted Oct 30, 2018 03:21 PM

    Hello,

     

    Can someone help me out with the syntax to only scan a DB table. I can't find it online or on the admin guide. Scanning a SQL server. This is what I have but it keeps failing:

     

    SQLServer://server:1433/database,table;domain=corporatedomain

     

     

    Syntax works without the ,table. 

     



  • 2.  RE: Specify DB Table to Scan
    Best Answer

    Trusted Advisor
    Posted Oct 31, 2018 12:48 PM

    Hi Eddie,

    I don't believe you can specify the table in the above connection. 

    The 15.1 Admin Guide suggests this should be doing using Filters and provides examples, this is on Page 1818. 

    https://support.symantec.com/en_US/article.DOC9261.html

    Extract:

    format schema_name.table_name

    sqlserver:*|HRschema.employee
    sqlserver:*|*.employee

    The first * allows you to filter against the SQL server, and after the "|" allows you to filter on the Schema then Table. 

    Let us know how you get on, cheers!