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.

Wildcard with PDQ Inventory Report

Avatar
Michael Martel

I'm trying to do a report which shows all accounts in the local admin group that are not certain domain accounts. 

Any ideas?

 

1

Comments

2 comments
Date Votes
  • Avatar
    lnichols

    Michael,

    I usually find it's less hassle to just use a regular expression for use cases like this rather than have a ton of individual value filters, like so:

    Obviously you'll have to change my expression for your needs, but here's how it works:

    ^(username1|username2|username3)$

    The caret (^) signals the start of the line and the dollar sign ($) signals the end of the line. You might not need them for this application but I use regex for other applications as well and it's easier for me to just always use them. Anything inside the parentheses will get matched as the first token. You don't need to know what tokens are for this use case. The pipe (|) means OR. Basically you're saying to match username1 OR username2 OR username3, etc. Then you set the comparison for the value filter to "Does Not Match Expression" to invert the results so the report will only show usernames that do not match your regular expression.

    2
  • Avatar
    Michael Martel

    Luke,

    That works perfectly. Thank you so much! I'll put that query in my toolbox for other reports too.

    Thanks again,

    Michael

    1