You want to know how to configure your SQL server to be used with dbconvert.
To use DBConvert to push data to your database you need to install the ESM console and ESM Utilities, and then configure a ODBC connection in order to run DBConvert and push data to a database and run reports on the data. The installation of ESM Utilities and ESM Console are described in the ESM installation manual and will be no further discussed in this document.
To configure the ODBC connection to the ESMDB database
To configure the propfile for the dbconvert utility
To generate a report
NOTE: The reporting function in the ESM console is not available in versions 6.5.3 and above. Please see http://www.symantec.com/docs/TECH113592 for details.
Keep in mind that the dbconvert utility only pushes data to the database server. If an agent is removed from the ESM server's configuration, it will still show in the report. The dbconvert utility uses a one-way push, it is not capable of removing data from the database (its not a synchonization). The database should be cleaned by other means (SQL scripting).
Many companies use their own database query tools to extract data from the SQL server.
Extract from the schema :