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.

Reporting based on Dynamic Collections I've created

Avatar
Smalone

Disclaimer - I'm no reporting guy :)

So I want to run a report on all computers in my environment and in the report have it break those computers down by what dynamic collection they reside in.  I have over 100 "site collections" I have created based on IP Ranges so I can determine what sites have what computers.  I'm looking for something along the lines of:

Site1

 -Computer 1

- Computer 2

Site 2

 - Computer 1

 - Computer 2

And so on..   Is this possible within PDQ Inventory?

 

Thank you in advance!

0

Comments

3 comments
Date Votes
  • Avatar
    Shane Corellian

    You can do this with Inventory 2.1

    Create a new Report. Add two columns.

    1st column:

    Table: Member of Collection

    Column: Name

    2nd column:

    Table:Computer

    Column: Name

    MemberOfCollection-Columns.png

    In the Filters tab create a a new Value Filter

    Member of Collection

    Name Starts With Site (do this if your Collection names do, in fact, start with the word Site)

    MemberOfCollection-Filters.png

    When you run your report click on the Member of Collection column header and select Group By This Column. That will give you the layout you want.

    MemberOfCollection-GroupBy.png

     

    Always verify that your Collection source is set properly (I chose All Computers when I ran this one)

    MemberOfCollection-GroupByResults.png

    0
  • Avatar
    Smalone

    Awesome!  Thank you very much!!  I am ALMOST there!! Basically I have airport codes for my site names, I can run the report fine by not even placing a filter when I list the tables as you mention above, the only problem is that it lists all of the "default" collections that come with PDQI. (i.e. Online Systems, Requires .Net, etc) How do I remove those from being listed when the report is ran?

    0
  • Avatar
    Adam Ruth

    If the collections are all inside of another collection you can use the Path column to filter just the children of the collection.  For example, if you have the following collections:

    Parent
      Child 1
      Child 2

    Then the two child collections will have these paths:

    Parent > Child 1
    Parent > Child 2 

    Add a filter for Member of Collection Path Starts With "Parent >" and you'll have just the ones you want.

    0