You can query the database if you are a site administrator or have been given access to System Tools by another site administrator.

You can raise a database query using the Admin > System Tools > Ad Hoc Database Query page.

In the Ad Hoc Database Query page, select a data store, Operational Datastore or Datamart, type the “select” query and click Run Query. The query is executed against the CollabNet TeamForge database and the results are dispayed.

For security reasons, the sfuser and password_history tables of the operational datastore are restricted for ad hoc querying from the Admin > System Tools > Ad Hoc Database Query page. Alternatively, use the following views, sfuser_view and password_history_view, for retrieving all other data but passwords.

You can submit read-only queries of the format:

SELECT [FROM][WHERE][GROUP BY] [HAVING] [ORDER BY]

You can use the following special keywords while drafting the query:

  • “\d” or “show tables” - To list all the tables.
  • “\d <table name> - To view the description of a specific table.
  • “select * from <table name> - To view all the contents of a specific table.
Tags for this page: site_admin_tasks