Check out the database Schema Reference.You can create and run queries on the database by using the information in this document.

http://www.symantec.com/business/support/index?pag...

I hope this is helpful.

Best, Thomas

Moving this thread to the Endpoint Protection forum.

Hi Thomas,

Thanks for the information.But please tell me how to execute queries on that,As i have sem5.db file.So how to read the file and execute the fetch the data.

Thanks again!!

Regards,

Mahendra

open the dbisqlc.exe which is located under C:\Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32\. you can use the sql queries using the DB schema.

Hi Thomas,

  Alternatively you can configure the SEPM to use a Microsoft SQL server DB, this makes it easier to manage and very simple to run queries against.

Before thinking of using customer queries to fetch data, you may want to check all the logs and reports that can be seen and exported in the SEPM, these should cover most organizations needs.

Specific customer queries can be somewhat difficult to write and generate complex queries that may impact performance on larger databases.

Thanks to all..

I am able to log-in to Interactive SQL window and executed manually all the sql queries.

But still i am facing a issue:

In the current scenario :
I am able to wirte the queries in the given Command box and it is showing me the fetched rows in data window.

But as per the requirement:I have to write a external schedule job which fetch the data from SEPM server automatically and import the data in my external source;to achieve this I am following the model like creating same database structure in my external repository where I give the connection string with login credentials wich import the data from SEPM and feed in my external source.

Or
If possible we can fetch the data in some flat file(SQL,csv,xls)??

Just for information I am working on integration of SEPM with RSA archer where I want to feed the Archer from SEPM.

Thanks again to all for quick response.

Regards,
mahendra

Ok James.Thanks for suggestion.

Now I had re-installed my SEPM instance and SQL server 2005.

While doing the Management server configuration I had selected sql server and provided all the mandatory details as :server name,username,password,port etc.

But after pressing "Next" SEPM invokes a message saying:

"Failed to connect to the database"

Please make sure the database server port is not used by another application and that your password is correct.

I don't know whats going wrong as I checked the 1433 default port is properly listening by SQl server itself,then why it is saying the database server port is used by other application"

Thanks in advance.

Regards,
Mahendra varandani

Hi All

I had successfully installed SEPM.

Now I was trying to integrate the clients to see the usage of SEPM in live.

Till I follwed below steps :

Searched the unknown and unmanaged computers in manager console of SEPM there I selected one network workstation and push the client installations in it which was successfull.

For now my SEPM default dashboard is showing only blank graphs and one active clinet with localhost under Group-->Clients tab.

I am unable to understand that what is the next step:Do i have to create the policies in it or anyother settings which i missed thats'y graphs are blank?

Please assit me..What is the basic work around of SEPM after installation and how do i see/monitor my network workstation?

Thanks in advance.

Regards

Mahendra Varadani