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

Document information


More support for:

Tivoli Endpoint Manager

Software version:

BES 5.1+

Operating system(s):

Platform Independent

Reference #:

1505950

Modified date:

2012-02-03

Translate my page

Machine Translation

Content navigation