Endpoint Protection

 View Only

  • 1.  require some sql coding

    Posted Nov 20, 2011 03:05 AM

    Hi Friends,

        Kindly share some sql coding which I can use in "SEP_Content_DistMonitor".



  • 2.  RE: require some sql coding



  • 3.  RE: require some sql coding
    Best Answer

    Posted Nov 20, 2011 12:48 PM

    Are you referring to the query link in the SEP Content Distribution Monitor?

    Schema reference guides for SEP 11 and 12.1:

    http://www.symantec.com/docs/TECH102544

    http://www.symantec.com/docs/DOC4324

    As a simple example, here is SQL code to retrieve the size of the stored content in the database (without client packages) in GB:

     SELECT SUM(DATALENGTH(CONTENT))/1024.0/1024/1024
  AS "content size in GB" FROM BINARY_FILE
  WHERE TYPE='DownloadedContentFile'

    Should work with embedded and SQL Server database.



  • 4.  RE: require some sql coding

    Posted Nov 25, 2011 12:06 AM

    thanks for sharing any other coding. Pls share