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.

Summarize data into one cell

Avatar
Kathleen Firth

We have several basic reports set up as AutoReports that filter for AD Parent Path containing the site name, and the Columns displaying the relevant info, such as Computer name, model, serial number, and display model and serial numbers. For PCs that have dual monitors, this report displays as two lines in the generated report, since each unique serial number for the display is causing a new line to be created in the dumped report, as seen here: Forking Report What I want to do is have the Display Serial Number column list all found data in one cell instead of forking into another row. Is that possible with a basic report or do I need to start figuring out how to write my own SQL reports?

0

Comments

1 comment
Date Votes
  • Avatar
    Colby Bouma

    https://gist.github.com/Colby-PDQ/c2731e3214ee3a662622249a203448b5

    I think these SQL Reports will do what you asked for. "Grouped Displays" groups the Display Model and Display Serial Number fields separately. "Grouped Displays - Fancy" smashes the Model and Serial Number fields together into 1 field.

    Let me know if there are any changes you would like!

    0