Random helpful stuff that I have found along the wayhttps://blogs.technet.microsoft.com/breben
This site will primarily serve as my place to store links and info that I refer to alot as I work with MS customers. Mon, 15 Oct 2018 04:30:36 +0000en-UShourly1THIS BLOG IS NOW DEAD. GO TO TEXASMCSE.COMhttps://blogs.technet.microsoft.com/breben/2018/10/15/this-blog-is-now-dead-go-to-texasmcse-com/
https://blogs.technet.microsoft.com/breben/2018/10/15/this-blog-is-now-dead-go-to-texasmcse-com/#respondMon, 15 Oct 2018 04:30:36 +0000https://blogs.technet.microsoft.com/breben/?p=1795THIS BLOG IS NOW DEAD. GO TO TEXASMCSE.COM
]]>https://blogs.technet.microsoft.com/breben/2018/10/15/this-blog-is-now-dead-go-to-texasmcse-com/feed/0Query to find content with “enable for on-demand distribution” option sethttps://blogs.technet.microsoft.com/breben/2017/08/04/query-to-find-content-with-enable-for-on-demand-distribution-option-set/
https://blogs.technet.microsoft.com/breben/2017/08/04/query-to-find-content-with-enable-for-on-demand-distribution-option-set/#respondFri, 04 Aug 2017 12:46:57 +0000https://blogs.technet.microsoft.com/breben/?p=1775If you need to determine which of your ConfigMgr packages, applications or update deployment packages has the "enable for on-demand distribution" option enabled, this query will help. Run it in SQL studio against the ConfigMgr database. You can adjust the where statement to also look for other configuration settings, like where the persist in cache option is set. Enjoy.

SELECT pkg.*,

(PkgFlags&0x01000000)/0x01000000 AS PKG_DO_NOT_DOWNLOAD, (PkgFlags&0x02000000)/0x02000000 AS PKG_PERSIST_IN_CACHE, (PkgFlags&0x04000000)/0x04000000 AS PKG_USE_BINARY_DELTA_REP, (PkgFlags&0x10000000)/0x10000000 AS PKG_NO_PACKAGE, (PkgFlags&0x20000000)/0x20000000 AS PKG_USE_SPECIAL_MIF, (PkgFlags&0x40000000)/0x40000000 AS PKG_DISTRIBUTE_ON_DEMAND FROM dbo.v_Package pkg where ((PkgFlags&0x40000000)/0x40000000) = 1

]]>https://blogs.technet.microsoft.com/breben/2017/08/04/query-to-find-content-with-enable-for-on-demand-distribution-option-set/feed/0Mass delete management packshttps://blogs.technet.microsoft.com/breben/2017/05/04/mass-delete-management-packs/
https://blogs.technet.microsoft.com/breben/2017/05/04/mass-delete-management-packs/#respondThu, 04 May 2017 14:08:32 +0000https://blogs.technet.microsoft.com/breben/?p=1765You can individually delete MPs from the SCOM console or you can delete multiples via Powershell with this command. Replace msdtc in my example with the name/partial name of the MPs you want to mass delete.

]]>https://blogs.technet.microsoft.com/breben/2017/05/04/mass-delete-management-packs/feed/0new book!https://blogs.technet.microsoft.com/breben/2017/01/11/new-book/
https://blogs.technet.microsoft.com/breben/2017/01/11/new-book/#respondWed, 11 Jan 2017 18:22:52 +0000https://blogs.technet.microsoft.com/breben/?p=1755I'm proud to announce that the latest edition of the Mastering Configuration Manager series of books is now released. You can purchase the kindle version now or the paperback version later this month. It takes a considerable amount of effort to co-author a book and I'm really glad to have worked on this book with my good friend Santos Martinez and Peter Daalmans. I hope you find this book useful as you learn about Configuration Manager Current Branch.

]]>https://blogs.technet.microsoft.com/breben/2017/01/11/new-book/feed/0Query for user affinityhttps://blogs.technet.microsoft.com/breben/2016/04/14/query-for-user-affinity/
https://blogs.technet.microsoft.com/breben/2016/04/14/query-for-user-affinity/#respondThu, 14 Apr 2016 13:03:50 +0000https://blogs.technet.microsoft.com/breben/?p=1715I had a customer ask for a query that would show which users were primary on clients based on user device affinity data. There are a few views that are related to UDA data (https://technet.microsoft.com/en-us/library/dn581963.aspx) and you can join these on a few different columns, depending on the view.

The v_UserMachineRelationship view shows users and their primary devices and the v_UserMachineIntelligence view shows more detailed information about the affinity, like number of logons, time spend for each session, etc. So, the following query is a result of that work. I didn't care about local account logons so I'm using the WHERE to filter those out.

]]>https://blogs.technet.microsoft.com/breben/2016/04/14/query-for-user-affinity/feed/0Configuration Manager version numbershttps://blogs.technet.microsoft.com/breben/2016/03/12/cm2012-version-numbers/
https://blogs.technet.microsoft.com/breben/2016/03/12/cm2012-version-numbers/#respondSat, 12 Mar 2016 12:19:00 +0000https://blogs.technet.microsoft.com/breben/2014/07/09/cm2012-version-numbers/Every time I do a CM Risk Assessment (RaaS) for a customer I have to remember the various versions of CM clients that are out there. Here is a compiled list so I'll know where to find it (and maybe you will too!)

CM 2012 RTM - 5.00.7711.0000

CM 2012 CU1 - 5.00.7711.0200

CM 2012 CU2 - 5.00.7711.0301

CM 2012 SP1 - 5.00.7804.1000

CM 2012 SP1 CU1 - 5.00.7804.1202

CM 2012 SP1 CU2 - 5.00.7804.1300

CM 2012 SP1 CU3 - 5.00.7804.1400

CM 2012 SP1 CU4 - 5.00.7804.1500

CM 2012 R2 - 5.00.7958.1000

CM 2012 R2 KB2905002 - 5.00.7958.1100

CM 2012 R2 CU1 - 5.00.7958.1203

CM 2012 R2 CU2 - 5.00.7958.1303

CM 2012 R2 CU3 - 5.00.7958.1401

CM 2012 R2 CU4 - 5.00.7958.1501

CM 2012 R2 SP1 - 5.00.8239.1000

CM 2012 R2 SP1 CU1 - 5.00.8239.1203

CM 2012 R2 SP1 CU2 - 5.00.8239.1301

CM 1511 - 5.00.8325.1000

CM 1602 - 5.00.8355.1000

CM 1602 hotfix - 5.00.8355.1306

CM1602 hotfix - 5.00.8355.1307

CM1606 - 5.00.8412.1000

CM1606 hotfix - 5.00.8412.1007

CM1606 hotfix - 5.00.8412.1307

CM1610 - 5.00.8458.1000

CM1610 hotfix - 5.00.8458.1007

CM1702 - 5.00.8498.1007

CM1706 - 5.00.8540.1003

CM1710 - 5.00.8577.1003

CM1710 hotfix - 5.00.8577.1108

]]>

https://blogs.technet.microsoft.com/breben/2016/03/12/cm2012-version-numbers/feed/0"This operation can not be completed at this time" during add MS Intune subcription to CMhttps://blogs.technet.microsoft.com/breben/2016/02/24/this-operation-can-not-be-completed-at-this-time-during-add-ms-intune-subcription-to-cm/
https://blogs.technet.microsoft.com/breben/2016/02/24/this-operation-can-not-be-completed-at-this-time-during-add-ms-intune-subcription-to-cm/#respondWed, 24 Feb 2016 18:43:00 +0000https://blogs.technet.microsoft.com/breben/2016/02/24/this-operation-can-not-be-completed-at-this-time-during-add-ms-intune-subcription-to-cm/You are attempting to add a Microsoft Intune subscription to your ConfigMgr site and the "This operation can not be completed at this time" message appears. Fun. Maybe if you try it later it will work? Probably not.

This typically means that the Intune tenant you are attempting to associate with CM (and thereby set CM as the mobile device management authority) already has the authority set to something else (typically Intune). This may happen if you were using Intune as a standalone implementation for a bit and then decided to integrate it with CM. In order to address this, run, don't walk, to your computer and open a Microsoft Premier support incident to reset the authority. Although Microsoft says the authority cannot be changed it may be possible but you'll need to engage a Premier support engineer to do it. The reason you should run is the turnaround time can be 24 hours or more (maybe even 5 days) for this change to take affect. Once you open the support incident you can save some time and be proactive on the steps that the engineer will ask you to perform before the authority reset is started.

Open the Intune portal (manage.microsoft.com) and:

Retire any enrolled devices. Selective wipe is OK.

Delete any sideloading keys

Delete any certificates (like iOS APN) that were added to Intune

Delete any apps that were added to Intune

Delete any policies that created

]]>https://blogs.technet.microsoft.com/breben/2016/02/24/this-operation-can-not-be-completed-at-this-time-during-add-ms-intune-subcription-to-cm/feed/0Can I migrate a CM 2012 site to a CM Current Branch site?https://blogs.technet.microsoft.com/breben/2016/02/20/can-i-migrate-a-cm-2012-site-to-a-cm-current-branch-site/
https://blogs.technet.microsoft.com/breben/2016/02/20/can-i-migrate-a-cm-2012-site-to-a-cm-current-branch-site/#respondSat, 20 Feb 2016 13:13:55 +0000https://blogs.technet.microsoft.com/breben/2016/02/20/can-i-migrate-a-cm-2012-site-to-a-cm-current-branch-site/Is it possible to use the Configuration Manager migration feature to migrate objects from a Configuration Manager 2012 site to a Configuration Manager Current Branch site?

In the past, the migration feature of CM has required that (unless you were migrating from CM 2007) that the source and target be the same version of CM 2012. Reference here https://technet.microsoft.com/en-us/library/gg682006.aspx"Beginning with System Center 2012 Configuration Manager SP1.....migrate from System Center 2012 Configuration Manager infrastructure to another deployment of Configuration Manager that runs the same version."

Suppose you are currently running CM 2012 and want to build a new parallel hierarchy to run CM CB and then migrate objects over. This may be a common scenario due to OS requirements for CM CB (Server 2012 or later) and SQL 2012 (or later). Now, CB 1602 will allow you to perform an inplace OS upgrade (say from Server 2008 to Server 2012) but most customer aren't comfortable with upgrading a server OS, they would rather start with a fresh install. So, if the prior migration guidance still applies, you would have to either:

A System Center Configuration Manager hierarchy of the same or lesser version of System Center Configuration Manager"

That's great news. I've tested this in my lab and seems to work on CB 1511 when I migrated from a CM 2012 R2 SP1 site. Monitor the migmctrl.log and you will see lots of Query against Legacy Site messages. I hope you find this helpful

]]>https://blogs.technet.microsoft.com/breben/2016/02/20/can-i-migrate-a-cm-2012-site-to-a-cm-current-branch-site/feed/0Query for memory slot typeshttps://blogs.technet.microsoft.com/breben/2016/02/02/query-for-memory-slot-types/
https://blogs.technet.microsoft.com/breben/2016/02/02/query-for-memory-slot-types/#respondTue, 02 Feb 2016 17:50:41 +0000https://blogs.technet.microsoft.com/breben/2016/02/02/query-for-memory-slot-types/I was working with a customer to figure out how many different variations of computer memory card slots they had in the environment. Turns out there are many (DIMM A, DIMM_A, Slot 1, Slot_1, Top Slot, Bottom Slot, etc). The query is a very specific use case but putting it here in case it helps you out. If nothing else it's a sample on how to do counts.

]]>https://blogs.technet.microsoft.com/breben/2016/02/02/query-for-memory-slot-types/feed/0my Christmas lights projecthttps://blogs.technet.microsoft.com/breben/2015/12/06/my-christmas-lights-project/
https://blogs.technet.microsoft.com/breben/2015/12/06/my-christmas-lights-project/#respondSun, 06 Dec 2015 09:38:00 +0000https://blogs.technet.microsoft.com/breben/2015/12/06/my-christmas-lights-project/99% of the content I post here is about Configuration Manager, Intune, Microsoft in general. This post will be different.

A month or so ago I purchased the Raspberry Pi 2 Ver B package that included Windows 10 IoT and some hardware to play with. I loaded the Win10 OS, played with a few of the python scripts and hardware items that are included in the kit, pretty cool stuff. However, my goal was to quickly put together a solution that would manage my outdoor Christmas lights display. This has traditionally been a very static display with no automation, no music, etc. My goal for this project was to control the lights via the RasPi and add music. Again, my goal was to quickly put this together and I began looking at code that others had built that I could leverage. There wasn't much available yet for Windows 10 so I focused on running Raspbian Jessie as my OS. Hopefully I will have more time next year and can move this to Win10. Raspbian, coupled with a great product called LightShowPi, helped me complete in a couple weeks what would probably have taken me months to develop myself.

I am using the Raspberry Pi 2 model B (https://www.raspberrypi.org/products/raspberry-pi-2-model-b/). The original Pi works also but I wanted the extra goodies the Pi 2 has, so that it was I bought. Also this is not part of this year's project but I also purchased the official Raspberry Pi LCD display (OFFICIAL RASPBERRY PI FOUNDATION 7" TOUCHSCREEN LCD DISPLAY)Note that this item is highly backordered currently so very expensive. Wait a few months and it should get back to $60 price.

I am broadcasting the MP3 audio via FM radio so that people can tune in their car radios and hear the music in sync with the lights. Lightshowpi includes PiFM that could possibly perform that task but it's pretty buggy on RasPi 2, seems to work better on the original RasPi. As a result, I just purchased a low range FM transmitter and transmit on 95.5FM SainSonic AX-7C FM Transmitter Mini Radio Stereo Station PLL LCD with Antenna - Fashion Black

Each of the 8 channels on the SSR can support 2 amps so you need to make sure that the lights you are plugging into that channel do not exceed 2 amps. You can guess how much power the lights use, you can read the manufacturer's info (which may not be accurate) or you can test it. I use this for every light string I plug in: P3 International P4460 Kill A Watt EZ Electricity Usage Monitor

There are many ways to connect the light strings to the channels in the SSR. I went with extension cables, more on how that gets connected later Etekcity 10 Pack Power Extension Cord Cable Strip, 16AWG/13A, UL Listed, 2015 Upgraded Version

You will also need a variety of extension cables, the lights themselves (I'm using mostly LCD), etc.