Database Preferences Page

<< Click to Display Table of Contents >>

Database Preferences Page

The Database settings allow you to manage the PDQ Inventory database.

To access the Database settings, click Options > Preferences (or press Ctrl+Comma) and select Database in the Preferences window.

Options

Description

Database

Shows the path to the PDQ Inventory SQLite Database (Database.db). The default location is %PROGRAMDATA%\Admin Arsenal\PDQ Inventory\. Click the Open Directory Location button to view the location of the database.

NOTE: If there is an issue with the database, the Check Database button will appear. This will run Pragma integrity_check in SQLite to ensure the database is not corrupt. Additionally, from an elevated command prompt (cmd.exe run as Administrator), you can run this check with the PDQInventory CheckDatabase command. To fully restore a database, you can also run the PDQInventory RestoreDatabase command.

 

SQLite Console

Opens an SQLite console in which you can perform database management operations on the PDQ Inventory database using SQLite commands. Additionally, from an elevated command prompt (cmd.exe run as Administrator), you can open the console with the PDQInventory Database command

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 PDQ support staff or an official PDQ 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: Optimizing the databases stops the PDQDInventory service and closes the PDQ Inventory console. Do not optimize while scans are running. 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: From an elevated command prompt (cmd.exe run as Administrator), you can rebuild the database with the PDQInventory OptimizeDatabase command. To fully restore a database, you can also run the PDQInventory RestoreDatabase command.

Automatic Backup Schedule

 

 

Enable automatic backups

Enables the PDQ Inventory automatic backups feature. (Enterprise mode required.) This is enabled by default.

NOTE: For assistance with restoring from a backup, see Restore Database Backup Files.

Schedule

Displays the current schedule for the automatic backup. Clicking the Edit Schedule button will open the Select Trigger window to edit the schedule. Additionally, you can click the Delete Schedule button to clear the schedule selection. The default schedule is every week on Saturday at 10:00 PM.

 

Once

Schedule once in the future.

Trigger On: Select one-time backup date.

At: Time the backup will occur.

Description: (Optional) Description of the trigger.

Interval

Backs up (and repeats) at a set time interval.

Every: Select backup interval by day, hour, and minute.

Only run during the following time frame (Optional) Enables a set time frame.

Between: The start of the time frame.

And: The end of the time frame.

Starting: Date the trigger starts.

At: Time of the first backup. If the optional time frame is selected, the first backup will occur at the start of the next time frame.

Ending: (Optional) Date the backup ends. Select to enable the end date.

At: (Optional) Time the backup ends.

Description: (Optional) Description of the trigger.

NOTE: Setting the 'Between' time later than the 'And' time will result in the trigger running overnight.

Daily

Backs up every day at the same time.

Every Day At:

Time of the backup.

Starting: Date the backup starts.

Ending: (Optional) Date the backup ends. Select to enable the end date.

Description: (Optional) Description of the trigger.

Weekly

Backs up every week at the same time on selected days of the week.

Every Week On:

Day or Days that the backups occur.

At: Time of the backup.

Starting: Date the backup starts.

Ending: (Optional) Date the backup ends. Select to enable the end date.

Description: (Optional) Description of the trigger.

Monthly

Backs up every month at the same time on selected days.

Every Month

Day of the Month: The day (or multiple days) of the month (for example, 1st, 12th, 23rd, etc.)

Or

Day of the Week: The nth (for example, 1st, 2nd, Last, etc.) day of the month (for example, All, Weekend Days, Sunday, Monday, etc.)

TIP: Days of Month: If you select the 29th, 30th, or 31st of the month, the backup won't occur in months without those days. Use Last to always deploy on the last day of the month. Can be mixed with Weeks of the Month.

TIP: Weeks of Month: Different combinations of weeks and days require separate schedules (for example, the 1st Monday and the 2nd Friday.) Selecting the 5th week won't deploy in a month without a fifth week. Use Last to always deploy on the last week of the month. Can be mixed with Days of the Month.

At: Time of the backup.

Starting: Date the backup starts.

Ending: (Optional) Date the backup ends. Select to enable the end date.

Description: (Optional) Description of the trigger.

Backup Location

Displays the path where backup files are stored. The default location is C:\ProgramData\Admin Arsenal\PDQ Inventory\Backups. Click the Open Directory Location button to view the location of the backup.

NOTE: The backup file is named after the version of the database with the date and time the backup was performed. For example a backup of version 9 performed on March 23, 2016 at 2:32 PM will be titled PDQInventory-9.1.0.0-16-03-23 1432.db

Backups to Keep

Specifies the number of most recent backup files to keep. Setting this to 0 will save all backups. The default setting is 10.

NOTE: For assistance with restoring from a backup, see Restore Database Backup Files.

 

Compress backups

Automatically compresses each backup to save space. This is enabled by default.

Backup Now

Backs up immediately instead of waiting for the next scheduled backup (Enterprise mode required).

Send Database to PDQ

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

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

NOTE: From an elevated command prompt (cmd.exe run as Administrator), you can send your database with the PDQInventory SendDatabase command.

See also

Defining System Preferences

Maintaining the PDQ Inventory Database

Restore the PDQ Inventory Database

Move PDQ Inventory to Another Computer

 

 

 

 

© 2022 PDQ.com Corporation. All rights reserved.

PDQ.com is a trademark of PDQ.com Corporation. All other product and company names are the property of their respective owners.

Help Version: 19.3.254.0