CMPivot – Using file wildcards

Did you know that you can search for files in CMPivot?

Did you also know that you can perform wildcard file searches with CMPivot?

An interesting post on the /r/SCCM subreddit sent me down the path of testing it out. I tested this in my lab running SCCM 1906.

It works great, just use an asterisk * to perform the wildcard.

Fast moving software is great!

3 thoughts on “CMPivot – Using file wildcards

  1. Thanks Potent Engineer! I was look for the wild card and you found it. I immediatly applied this knowledge to get info I was looking for. And this is how.

    The wild card also works in mid path for a folder name.
    With oneDrive for Business enabled by Group Policy a folder called ‘OneDrive – Widget’ where ‘Widget’ is your company name, created under the users profile folder.

    This wild card shows all users on a machine who have this folder indicating OneDrive for Business group policy has applied.

    File(‘C:\Users\*\OneDrive – )

    • John Delise

      It seems the post truncated the example query, after the dash you put your computer name, if you have one drive for business running on any machine, just look for the folder and you will see the correct folder name, other wise the Azure Tenant info should have it if you a have access to portal.azure.com

      • Ha, that’s interesting John, I have ran the exact query in the last few weeks! A very powerful tool, thanks for sharing!

Leave a Reply to Daniel Ratliff Cancel reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url=""> 

This site uses Akismet to reduce spam. Learn how your comment data is processed.