Video Screencast Help

require some sql coding

Created: 20 Nov 2011 • Updated: 27 Nov 2011 | 3 comments
This issue has been solved. See solution.

Hi Friends,

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

Comments 3 CommentsJump to latest comment

Vikram Kumar-SAV to SEP's picture

https://www-secure.symantec.com/connect/downloads/sep-content-distribution-monitor

Vikram Kumar

Symantec Consultant

The most helpful part of entire Symantec connect is the Search button..do use it.

greg12's picture

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.

SOLUTION
Sumit G's picture

thanks for sharing any other coding. Pls share

Regards

Sumit G.