Skip to main content

Is there a database schema available to help me query the database?


Technote (troubleshooting)


Problem(Abstract)

Available database api documentation list.

Resolving the problem

The last available database api documentation can be downloaded here:
BESDatabaseAPIReference-7.0.pdf

The database API documentation provides information on querying the database through a set of sql views built around common database queries. The documentation also provides helpful example queries and important information on how to work with the database. The documentation does not cover the underlying database tables and structure and you should not attempt to query these directly.

Previous versions:
6.0: BESDatabaseAPIReference_2006_06_04.pdf
4.0-5.1: BESDatabaseSchema-2005_04_28.pdf

In addition, here is an example of a perl script that extracts computer properties and puts them in a CSV file. This script shows how to extract properties from the BigFix database and requires customization to work properly:
CustomDBExportExample-11-30-2004.zip.

Historical Number

161

Rate this page:

(0 users)Average rating

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

Tivoli Endpoint Manager


Software version:
BES 5.1+


Operating system(s):
Platform Independent


Reference #:
1505950


Modified date:
2012-02-03

Translate my page

Content navigation