Archive for June, 2015

Jun 23 2015

The Sonos Music Ecosystem

When I purchased my first Sonos device back in 2012, I had been looking for something like this system for at months. I didn’t seem to think that my requirements were that out of the ordinary, but I had a hard time finding something that met all my needs at a price that I considered reasonable. What I’m looking for is an easy way to share all kinds of music across multiple speakers in multiple rooms and control it all easily. I wanted the ability for them to stay completely in sync or to all be playing something independently.


Jun 15 2015

Finding the Create & Modify Dates of Google Calendar Event

While using shared Google calendars is great way to keep yourself, your family, or your groups organized, they lack any type or real auditing at the event level.  Specifically, I often need to find out when an event was created or modified.  While this isn’t available today through the GUI, it is available under the hood.  Below I’ll show you step by step how to find this data.


Jun 8 2015

SCCM SQL Query to Determine Installed Browsers

I recently wrote the following SQL Query to help identify which browsers are installed across our environment.  A straight Add/Remove Programs (v_AddRemovePrograms) query didn’t really return the data in such a way that made it easy to determine major version of Firefox or Chrome, and doesn’t include Internet Explorer since that’s not listed in Add/Remove Programs.  This view alone also does not capture user based installations of Chrome.  You may need to modify slightly for your environment.


Jun 3 2015

Creating an SCCM Collection from an List of Computers in Excel

I frequently use this trick to manage collections of computers in SCCM where the original list comes from Excel, or from a query of another system that I can dump into Excel.  Doing it this way, you don’t have to rely on adding computers one at a time to a collection query or dumping systems into tools like the the ConfigMgr 2012 Right Click Tools (which by the way are awesome).  One thing to note is that you’re adding systems by name when you do it in a query, and not as direct adds.  This may or may not be your desired state, just something to keep in mind.