|
<< Click to Display Table of Contents >> Maintaining the PDQ Inventory Database |
PDQ Inventory stores all of its data—collections/reports, computer inventory information, Active Directory information, preference settings, etc.—in an SQLite database file. The PDQ Inventory database is essential to the program function; therefore, it is recommended that you perform the following regular maintenance procedures to ensure optimal database performance:
•Location of the PDQ Inventory Database
•Backing Up the PDQ Inventory Database
PDQ Inventory stores its database locally (on the PDQ Inventory console computer) in %ProgramData%\Admin Arsenal\PDQ Inventory.
NOTE: %ProgramData%, was introduced in Windows Vista and used in subsequent Operating Systems (Windows 7, 8.x, 10, etc), and is a folder designed to hold application-specific (that is, not user-specific) data. By default, Windows marks this folder as hidden. Its default location is %SYSTEMDRIVE%\ProgramData. If you are running PDQ Inventory on Windows XP or 2003 (no longer supported), the default location is %SYSTEMDRIVE%\Documents and Settings\All Users\Application Data.
If your console performance is lagging during scans, you may consider moving the PDQ Inventory database to a faster disk. For information on this procedure, visit the Admin Arsenal Support page at http://support.adminarsenal.com/home and click Submit a Request or email your request directly to support@adminarsenal.com, or click Help > Submit Feedback. You can also browse the Admin Arsenal forums for FAQs.
Because the PDQ Inventory database stores all collections, reports, and computer inventory information, it is highly recommended that you regularly backup the PDQ Inventory database. Since the SQLite database is a single file, this is easy to accomplish.
By default, the PDQ Inventory database is located at %ProgramData%\Admin Arsenal\PDQ Inventory\Database.db. To protect your system data, configure your backup software to regularly back up this file.
NOTE: To determine the location of the PDQ Inventory database, click File > Preferences or press Ctrl+Comma, then select Database. The Database field displays the path and filename for the PDQ Inventory database.
When PDQ Inventory deletes information from the PDQ Inventory database, it leaves empty space in the database file which takes up a few bytes. Over time, this space adds up and may impact database performance. Therefore, it is recommended that, on average, you optimize the PDQ Inventory database once a month. Optimizing the database frees up the empty space and gets rid of fragmentation.
NOTE: Optimizing the database stops the background service. Any outstanding scans will be aborted so take care to only optimize the database at appropriate times.
NOTE: PDQ Inventory automatically optimizes the database when the application is upgraded.
To optimize the PDQ Inventory database:
1.Click File > Preferences or press Ctrl+Comma.
2.In the Preferences menu, click Database.
3.Click Optimize Database.
PDQ Inventory warns that the console and background service will be stopped, which will abort any running scans.
4.Click OK to continue.
PDQ Inventory opens a command line window to run the optimization command.
5.When the optimization completes, press Enter to close the command line window.
PDQ Inventory automatically restarts and opens the Preferences window.
6.Click Close.
© 2016 Admin Arsenal, Inc. All rights reserved.
Admin Arsenal is a trademark of Admin Arsenal, Inc. All other product and company names are the property of their respective owners.
Help Version: 8.1.0.0