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.

Report rollup

Jeff Ziegler

August 17, 2017 13:48

Monthly we push software update and use the re-try queue to catch off line PC's. Is there a way to get a MASTER report will all the deployments and only show one row per PC & package?

If I have to write a report in SQL we can if PDQ supports us connecting directly to the DB file. Is there any PDF's on the SCHEMA or supported ways of doing this?

Comments

1 comment

Permanently deleted user
September 08, 2017 17:02
The database is a Sqlite file. You can access it with sqlite3.exe. The DB file is located at "C:\ProgramData\Admin Arsenal\PDQ Deploy\Database.db"

However, you should be able to use a Deployment Report to achieve what you want. Unfortunately there's a bug in the current versions of Deploy that causes the Error column to always show, but that will be fixed in the next release.
1. Go to All Deployments
2. Click on a deployment and hit CTRL+A
3. Go to Reports --> Deployment --> Summary
4. Click Add
5. Set the Name
6. Set Columns to (none)
7. Click OK
0