Monthly Archives: June 2015

The Sonos Music Ecosystem

Published by:

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.

Continue reading

Finding the Create & Modify Dates of Google Calendar Event

Published by:

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.

Continue reading

SCCM SQL Query to Determine Installed Browsers

Published by:

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.

Continue reading

Creating an SCCM Collection from an List of Computers in Excel

Published by:

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.

Continue reading