Options

Description

Database

Shows the path to the PDQ Inventory SQLite Database (Database.db). The default location is %PROGRAMDATA%\Admin Arsenal\PDQ Inventory\.

SQLite Console

Opens an SQLite console in which you can perform database management operations on the PDQ Inventory database using SQLite commands.

IMPORTANT: Use this option with care. The PDQ Inventory database is essential to PDQ Inventory operations. It stores all collections, reports, scan profiles, and credentials. In general, it is recommended that you use this option only under the direction of Admin Arsenal support staff or an official Admin Arsenal Knowledge Base article.

For more information on the SQL language, visit SQLite documentation at http://www.sqlite.org/lang.html.

Optimize Database

Rebuilds the database by reorganizing the data and indexes (using vacuum in SQLite).

Over time, databases become fragmented. It is recommended that you periodically run an optimization to keep the PDQ Inventory database running at top performance. It is best practice to run this operation once per month. PDQ database optimization is automatically performed when the application is upgraded.

NOTE: It is recommended that you run the optimization when no other programs are accessing the database. Otherwise, the other programs may time out waiting for the optimization process to complete.

IMPORTANT: Optimizing the databases stops the PDQDInventory service and closes the PDQ Inventory console. Do not optimize while scans are running.

Send Database to Admin Arsenal

Allows for the ability to send your database to Admin Arsenal for troubleshooting over a secure SSL connection. Instructions on the use of this feature will be provided by Admin Arsenal support staff when needed.

IMPORTANT: This should only be used as directed by Admin Arsenal Support after they have supplied you with a Support Code.