1. PDQ Deploy & Inventory Help Center
  2. Community
  3. PDQ Inventory
 

Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

SQL Writes/Reads and admin licenses

Avatar
Daniel Swinford

Now that Inventory supports SQL I have a few questions about writing and reading the SQL database.

Can another process query the database? If so would that require another license?

Can another process update the Custom Fields portion of a computer in the SQL database and again if so would that require a license?

 

 

0

Comments

2 comments
Date Votes
  • Avatar
    Permanently deleted user

    I'm a little confused by your statement. Both PDQ products have always used SQLite.

    You can interact with the database using sqlite3.exe in "C:\Program Files (x86)\Admin Arsenal\PDQ Inventory". The database file is "C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db". Please be careful and make backups before messing with it.

    No, using sqlite3.exe does not require additional licenses.

    Yes, you can use sqlite3.exe to update Custom Fields. However, I recommend using "PDQInventory.exe ImportCustomFields" instead.

    0
  • Avatar
    Daniel Swinford

    Colby,

    My mistake. I thought (incorrectly) that I could point inventory to a SQL database (not SQLite). I just dug into the central server information so I'm all set.

     

    Thanks

     

    0