This article explains how to query the adTempus database.

More Information

Note: Direct updates to the adTempus database are not supported and may result in unrecoverable data corruption. Do not execute any updates against the adTempus database unless you are instructed to do so by a support engineer.

adTempus data is stored in a SQL Server database, which can be queried using standard SQL Server client tools.

Standalone SQL Server Instance

If you are using your own SQL Server instance to host the adTempus database, you can use SQL Server Management Studio or any other SQL Server query tool to query the database.

SQL Server Express

If you are using the default SQL Server Express installation to host the database, no tools are provided as part of the SQL Server installation. Instead you can use the adtdbutil.exe tool found in the adTempus program directory.

When you start adtdbutil it will automatically connect to the adTempus database and display a query panel. Enter your SQL query into the box and press F5 to execute it. Note that you can paste text into the query box using CTRL-V.

If you prefer to use a more robust query tool you can download and install the free SQL Server Management Studio Express from Microsoft. Click the Download button, then select "SQLManagementStudio_x64_ENU.exe" (for 64-bit platforms) or "SQLManagementStudio_x86_ENU.exe" (for 32-bit platforms).

Alternatively, if you already have Management Studio or another query tool installed on another computer, you can run that tool and connect to the adTempus database. You will first need to enable remote access to the adTempus database, as described in article K00000387. Note that if you have an older version of Management Studio than the version of SQL Server installed with adTempus, you may not be able to connect, or to perform some operations once connected. In that case you can install a newer version of Management Studio.

When connecting to the adTempus database from a remote computer, specify the server to connect to as "computername\adtempus", where computername is the name of the computer where adTempus is installed.