Summary
This article explains how to query the adTempus database.
More Information
Note: Direct updates to the adTempus database are not supported except as directed by support personnel, 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 such as SQL Server Management Studio, the adTempus Database Utility, or any other database tool compatible with SQL Server.
SQL Server Management Studio
If you have SQL Server Management Studio installed on the adTempus database server or any other computer you can use it to connect to the adTempus database. If you do not have it installed, you can obtain it for free from Microsoft.
Connecting to SQL Server Express
If you are using the default SQL Server Express installation to host the database, when connecting with SQL Server Management Studio specify the server to connect to as "computername\adtempus", where computername is the name of the computer where adTempus is installed.
If you are running SQL Server Management Studio or another query tool on a different computer than SQL Server Express is running on you will 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.
adTempus Database Utility
If you do not wish to install SQL Server Management Studio, you can use the adTempus Database Utility, which can be found in the adTempus folder on the Start menu. This tool is installed with the adTempus server and is not present for Console-only installations.
When you start the tool 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 adTempus is configured to use Integrated Windows security, the database utility will not be able to connect to the database if your Windows identity does not have the necessary permission. In this case you may need to log in to the computer as an administrator or as the user who installed adTempus initially in order to have access to the database.
