Read only access to PDQ Inventory database
I would like to extract data from the PDQ Inventory database and import it into MS Excel. I can generate the report I want via the Save data to file. I would like to skip the export step and allow Excel to extract the data directly. I gather from what I've been able to interpret that PDQ Inventory has an SQLite database and might be accessed with a ODBC connection.
How do I go about doing that?
0
Comments
You might be able to accomplish what you want with an Auto Report. Have it save to a file, but not send an email. https://documentation.pdq.com/PDQInventory/16.5.0.0/auto-reports-topic-head.htm