Generating large Dynamic Collection XML externally for import - need a big collection of logged-on specific users

I want a dynamic collection of all the machines that have the logged-on users from a list of particular users. I could create the collection manually, adding each logged-on user line by line, but there are going to be 1500+ eventually.

Is there a way to have a large DC XML generated somehow from a list of these users that I can then import? A tool to generate each of the <ValueFilter> sections in bulk, with consistent table, column, comparison values but variable value values?




Date Votes
  • David,

    If it were me, I would try using a regular expression for this.

    Admittedly, I have not ever created a PDQ Inventory dynamic collection value filter with 1500+ different values, so I have no clue how well this will perform.

    If you have a list of users in a text file with every username on a new line, you could open that list in notepad++ and use the find & replace function in "Extended" search mode, "Find what" set to \r\n and "Replace with" set to |

    Then click Replace All and you will get all of them on one line with a pipe between each one. You can then copy that and paste it into a PDQ Inventory collection like this:

    Again, you will have to test and see if this works for you. With 1500+ users it could be extremely slow or even crash PDQ.

  • yes! this works for me.


    holding steady 600-odd users so far. thanks

  • (Get-Content .\Users.txt) -join '|' | Set-Clipboard

Please sign in to leave a comment.

Didn't find what you were looking for?

New post