Endpoint Protection

Hello,

I'm looking for a solution that I need to connect my SEPM Database externally with a third party tool. So would like to know more information like what is the DB name like Mysql or Micrososft Database, Port to connect to with, the password to connect and so on.. Please help me out with this stuffs. Thanks in advance. 

Also additionally is that password which I need to use is DB creds or the windows AD password which I used to login the server. 

Start with this article:

https://www.symantec.com/docs/TECH102965

Default DB name is 'sem5' and you use the DB password when you initially installed SEPM. Default port is 2638.

Hello,

You may like to check this Symantec Article on About SQL Server configuration settings - 

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

The Article tells you about SQL Server configuration settings and SQL Server database settings related to Symantec Endpoint Protection Manager Database using SQL.

Hope that helps!!

Thanks Brian and Mithun, 

Successfully I integrated symantec DB with third party tool. Frankly am new to SQL and am trying to query specifcally to fetch risk logs for a client machine from DB directly. Could you please help me on that to acheive my task. 

Thanks again.

You'll need to create queries using the DB schema:

https://www.symantec.com/docs/DOC9438

I gone through the article which you shared. I have few questions if you can clear me off. 

For example if am refering to the Table "V_AGENT_SECURITY_LOG" and it contains around 58 columns. If I do want to refer only to a specifc hostname from the column "HOST_NAME" how I can do it? "HOST_NAME = xxxx" 

Please help me.