You can raise a database query using the Admin > System Tools > Ad Hoc Database Query page.
Select Admin > System Tools > Ad Hoc Database Query from the menu.
- Select one of the following data store options on the Ad Hoc Database Query page:
- Operational Datastore
Type the “select” query and click Run Query.
The query is executed against the selected data store and the results are dispayed.
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.
For security reasons, the
password_history tables of the operational data store are restricted from being queried from the Admin > System Tools > Ad Hoc Database Query page. Alternatively, use the following views,
password_history_view, for retrieving all other data but passwords.