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.

Filtering inventory based on computer model

I am trying to use a dynamic collection to isolate 4 models of computers out of 11 we have in production.  And then I want to see if the 4 models have the latest video driver (since they all use the same driver).  The only way I can get it to work is by having a bunch of filters of all the models I don't want.  If I try to do a "Contains 5580" new line "Contains 5590" I get no results.  

The other thing is, I can filter by the driver version for the video driver for computers that contain that driver but I can't get a list of computers that don't have the driver as well.  So I'm trying to make two collections ideally, one that has the 4 models and is lower than the current driver and then another collection that has the same 4 models and is equal to the current driver.  

The image below does get me the results (models 5580, 5590, 7380 and 7390 that have the 26.20.100.8142 video driver) but it just seems like a messy way to do it.  I can't figure out how to get the same models that don't have that version to come up.

Thanks

0

Comments

3 comments
Date Votes
  • I suspect you must have had an "All" with entries for the 5580 and the 5590. 

    That would mean it would have to contain both for it to match.  You'd want an "Any" so it could match either one.

    Try this

     

    For more advanced fun, you could use a PDQ custom variable, where you define the driver version.
    And use that in the collection settings.  So you could update multiple collections with one change, when your desired driver version changes, without having to go change every collection individually.

    0
  • I recommend setting up 3 collections. You can download this XML file and import it, or recreate them from the screenshots below.

    1. Models.
    2. Latest driver. Make sure this collection and the next one are below the first one, and that you enable "Drill down from parent collection". Also, I recommend creating a Custom Variable for the driver version so you only have to change it in 1 place when a new version comes out.
    3. Old driver.
    0
  • Awesome that worked.  Thanks guys for the help.

    0