Endpoint Protection

To query the data in SEPM embedded DB, is there any other better free tools than dbisqlc?
Now I am using dbisqlc to access the DB.Would you please guide me the query to get below result in embedded DB.

OS: Windows server 2008

SEPM: 12.1.2012.2012

A. Return Computer name, current user name, definition version,Last time status,Group Name
   If definition version is outdated more than 14 days

B. Return Computer name, current user name, definition version,Last time status,Group Name
   If client is offline more than 3 days

C. Return percentage of sep clients which definiton is older than 15 days and older than 7 days.

Hello,

the embedded DB is a Sybase one, hence you need the tool from Sybase to query it, no need to reinvent the wheel.

Please, note the SEPM console is meant to give you with those reports you would like to manually get, again, no need to reinvent the wheel.

Below is documentation regarding SEP 12.1 DB schema that you can use to create your own queries.

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