Status message based collection

Long ago as part of a different post I provided a query to make collections based on status messages.  I have since had several customers asking for this ability, making me aware that the blog post was not very discoverable.  Not surprising since the focus of that post was different. My older blog post was done…

0

WQL to SQL

If you want to do any deep troubleshooting with System Center 2012 Configuration Manager (SCCM/ConfigMgr), or even simple custom report creating, one of the main headaches you will hit is figuring out what SQL tables and views are involved with what you are interested in.  Scouring the internet is one way, as is doing a…

2

Collection creation based on state messages

Back in my System Center Configuration Manager (SCCM) 2007 days I wrote up a blog post about something I did with a customer to create collections based on status messages.  I have referred back to that many times, as have a few of my customers.  Recently I had a similar request, but in this case…

0

Get more from your queries

Every SCCM admin has figured out how to create a collection with a query rule to dynamically update its membership (you don't just do direct rules I hope).  Most admins have also learned that the columns able to be returned by a collection are limited but if you create a query in the Query node…

2

Prompted Query to find machines based on MAC address

One of my customers asked me to build this example query and I figured I would share with everyone, not just one company.  it can be handy when you are doing OS Deployment testing and you need to look up a machine based on its MAC address to delete it so it becomes an “unknown…

13