ConfigMgr 1710 Hotfix Rollup (KB4057517)

ConfigMgr Current Branch version 1710 now has a hotfix (KB4057517) available which addresses some issues, which you can read up here. The following are the fixes resolved with this hotfix (there are 13 of them):

  • Clients who use Azure Active Directory (Azure AD) for authentication do not successfully communicate with a management point
  • The Configuration Manager console may terminate unexpectedly after you browse to a content location in the Office 365 Client Installation wizard
  • Download of express updates may fail on Windows 10 clients because of an issue that affects files in temporary and cache folders
  • Configuration Manager current branch, version 1710 clients are not upgraded on systems that are running Windows Server 2008 SP2. The client Setup program, Ccmsetup.exe, terminates unexpectedly
  • The Office 365 Application Installation Wizard may try to download content from an incorrect channel. This causes download failures
  • The fallback time that is configured for content is not honored if distribution points or their content are inaccessible
  • The Client Notification Restart request is processed incorrectly by remote management points. This causes a .bld notification file to be left in the \MP\Outboxes\bgb.box folder on the remote management point
  • Retrying a large single-file download, such as an Office 365 update file, may fail on a site server
  • The Persist content in the client cache setting on Package Properties is not honored by clients
  • Decommission-related State messages from co-managed client computers are processed incorrectly
  • State messages sent by Azure AD users may not be processed
  • If a Configuration Manager client restarts during the process of retrying a task sequence policy download, that task sequence does not run automatically after the restart
  • Conditional access policies may block access to Office 365 applications for domain-joined devices after migrating to Intune standalone

Here are the steps on how to install this hotfix. You will find it available in the ConfigMgr console under Administration > Updates and Servicing. If you don’t see it, click on Check for Updates in the menu ribbon.

Right-click on Configuration Manager 1710 Hotfix Rollup (KB4057517) and click on Install Update Pack. I recommend that you run the prerequisite check first to make sure there are not issues reported with your site server.

Click Next and select the checkbox if you want to ignore the prerequisite check warning.

Pick your option to validate or not to validate the upgrade against a collection. I generally tend to select Validate in pre-production collection and choose one of my test collections for the first phase of the upgrade.

Select the license terms and click Next.

Click Next to confirm the settings.

Click Close.

You can now monitor the status of the upgrade under Monitoring > Updates and Servicing Status. Then select the update package name and click on Show Status in the menu ribbon.

The window below will show the stages of the upgrade process where you can monitor it’s progress. If there are any issues, you will see it listed here with a warning and the details provided in the description box in the bottom of the window.

Upon successful completion of the hotfix installation, you will be presented with the pop-up window as seen below to indicate a console upgrade from version 5.0.0.8577.1100 to 5.0.0.8577.1108 is available.

You can verify the console upgrade in the About System Center Configuration Manager drop down menu from the console.
Version 1710
Console version: 5.0.0.8577.1108
Site version: 5.0.8577.1000

Once you are comfortable with the client upgrade on your test collection which you selected during the validate in pre-production collection phase, you can deploy the client upgrade to all clients in the hierarchy by selecting the Promote Pre-production Client option as seen below.

Your ConfigMgr site is now upgraded with the KB4057517 hotfix.

 

#2 Week 3 – Top 1000 Tech Bloggers

On January 23, 2018, I received an email from Rise Social Media with the weekly listing of social media influencers and their respective rankings among 1000 Tech bloggers. Typically, I quickly scan the email and delete it, but this time in the week 3 newsletter, something caught my eye and it was this message:

Well done to this week’s top three Antonio GrassoHarjit Dhaliwal, and Dave Winer ?

I did a double take and clicked on the week 3 link and confirmed that I had moved up to the number 2 spot from way down the list. I was super excited and couldn’t wait to share the news with my friends and followers on social media, which is the source of my influence. I remember being just as excited when I made it to the 14th spot on week 43 in 2017 (see image below).

I was first introduced to Rise Global by my friend Richard Hay, who is well respected in the technology industry where he covers valuable news, reviews, and many other tech related matters as a tech journalist. Rich has taught me how to use several useful tools, helped me with some automation techniques, as well as shared some insightful strategies which in turn has made me successful with my social media work. We also had the opportunity to work together as the official social media journalists for the IT/Dev Connections Conference held in San Francisco in October 2017. We are looking forward to do the same at IT/Dev Connection 2018 in Dallas.

And then we have my friends Christian Buckley and Vlad Catrinescu, who are great contributors in the tech community and powerhouse Microsoft MVPs. These guys make Rise Global status ranking fun and exciting to take part in. We have a running joke and a friendly competition between us, which often involves some fun teasing to keep things challenging. We are rooting for each other to get to the top spot, and then we can call it a collective success. It will happen sooner than later!

As an IT Professional, I enjoy social media quite a bit and have a knack for it. I have developed some strong skills in this respect which has allowed me to contribute to the community in various ways from helping IT Professionals with valuable information and resources to keeping commuters safe during their daily travels. My social media activities have provided many wonderful opportunities which include travel, representation at large conferences, member of various committees, access to privileged groups, speaking engagements, contributions to technical newsletters, reviewer for products, books, and software, and some consulting work to name a few. I am humbled and grateful for these opportunities and to everyone who has helped me and continue to support me. Thank you, Thank you!

Well, I’m not naive to know that my reign on Rise Global will not last for long but I did get my five minutes of fame for what it’s worth. If you have somehow come across this blog post, please feel free to follow my social media channels, subscribe to my blog, YouTube channels, and podcasts. You’ll enjoy the information I share. Thanks.

About Me: Harjit Dhaliwal
Blog: www.harjit.us
Twitter: @Hoorge
Twitter: @TechKonnect
Facebook: TechKonnect
LinkedIn: Me
YouTube: Harjit
YouTube: Harjit & Prayer Show
Podcast: PowerShell News
Instagram: Me
Microsoft: MVP
Microsoft Ignite: Speaker
Microsoft: TechCommunity

How To Change GUID Partition Table to MBR

To change a GUID partition table disk into a master boot record disk using command line, follow the steps below.

1. Back up or move all volumes on the basic GUID partition table (GPT) disk you want to convert into a master boot record (MBR) disk.

2. Open an elevated command prompt (right-click Command Prompt, and then click Run as Administrator) and type diskpart.
If the disk does not contain any partitions or volumes, skip to step 6.

3. At the DISKPART prompt, type list disk. Make note of the disk number you want to delete

4. At the DISKPART prompt, type select disk <disknumber>

5. At the DISKPART prompt, type clean

6. At the DISKPART prompt, type convert mbr

And there you have it.

SQL Query To Find The Collection Membership of a Specific Computer in ConfigMgr

Every now and then, you will encounter a situation when you need to find which ConfigMgr Collection(s) a specific computer is a member of for troubleshooting purposes. I came across this TechNet post which describes a SQL query to find the collection information.

Run the following query in SQL against the SMS Database:

select v_FullCollectionMembership.CollectionID As ‘Collection ID’, v_Collection.Name As ‘Collection Name’, v_R_System.Name0 As ‘Machine Name’ from v_FullCollectionMembership
JOIN v_R_System on v_FullCollectionMembership.ResourceID = v_R_System.ResourceID
JOIN v_Collection on v_FullCollectionMembership.CollectionID = v_Collection.CollectionID
Where v_R_System.Name0=’ClientMachineName’

Note: Replace ClientMachineName with the name of the Client Machine in question. Additionally, you can also make a Custom Report to get this information if you intend to use this frequently:

The SQL Statement For this Report would be as follows:

select v_FullCollectionMembership.CollectionID As ‘Collection ID’, v_Collection.Name As ‘Collection Name’, v_R_System.Name0 As ‘Machine Name’ from v_FullCollectionMembership
JOIN v_R_System on v_FullCollectionMembership.ResourceID = v_R_System.ResourceID
JOIN v_Collection on v_FullCollectionMembership.CollectionID = v_Collection.CollectionID
Where
v_R_System.Name0=@Comp

Click on Prompts while providing the SQL Statement, and Create a new prompt named ‘Comp’ without the quotes. Provide a SQL Statement for the prompt as follows:

select Name0 from v_R_System

Source: http://blogs.technet.com/b/configurationmgr/archive/2009/08/24/how-to-find-the-collection-membership-information-of-a-specific-client-machine.aspx

Microsoft Deployment Toolkit (MDT 8450) Released

The Microsoft Deployment Toolkit (MDT) has been released and the most current build (8450) can be downloaded from the Microsoft Download Center. This update requires the Windows Assessment and Deployment Kit (ADK) for Windows 10 version 1709 (10.1.16299.15) which is available for download on the Microsoft Hardware Dev Center.

Some of the significant changes in this update include:

  • Supported configuration updates
    • Windows ADK for Windows 10, version 1709
    • Windows 10, version 1709
    • Configuration Manager, version 1710
  • Quality updates
    • Win10 Sideloaded App dependencies and license not installed
    • CaptureOnly task sequence doesn’t allow capturing an image
    • Error received when starting an MDT task sequence: Invalid DeploymentType value “” specified. The deployment will not proceed
    • ZTIMoveStateStore looks for the state store folder in the wrong location causing it to fail to move it
    • xml contains a simple typo that caused undesirable behavior
    • Install Roles & Features doesn’t work for Windows Server 2016 IIS Management Console feature
    • Browsing for OS images in the upgrade task sequence does not work when using folders
    • MDT tool improperly provisions the TPM into a Reduced Functionality State (see KB 4018657 for more information)
    • Updates to ZTIGather chassis type detection logic
    • Upgrade OS step leaves behind SetupComplete.cmd, breaking future deployments
    • Windows 10 ADK 1607 and later UEFI boot issue on some hardware
    • Includes updated Configuration Manager task sequence binaries

The following post provides some information on How to get help with MDT, in case you need it.

UserVoice: Microsoft Product Feedback And Feature Request Resources

I recently came across a post by Jim Naroski on The Office 365 Guy TechNet blog site. He listed the links to the UserVoice portal for the various products or topics which Microsoft utilizes to gather feedback and feature requests. One important link is missing from the TechNet blog, which is for the System Center Configuration Manager (ConfigMgr) feedback site, and I have added that to the list below. Start using this valuable resource to help improve products and make your voice heard.

Products Links
Access https://access.uservoice.com
Bookings https://outlook.uservoice.com/forums/314907-microsoft-bookings
Business Center https://office365.uservoice.com/forums/600793-office-365-business-center
ConfigMgr https://configurationmanager.uservoice.com
Excel https://excel.uservoice.com
Flow https://powerusers.microsoft.com/t5/Flow-Feedback/ct-p/Feedback
Forms https://microsoftforms.uservoice.com
Connections https://office365.uservoice.com/forums/600610-microsoft-connections
Invoicing https://office365.uservoice.com/forums/600781-microsoft-invoicing
Listings https://office365.uservoice.com/forums/600778-microsoft-listings
Mix https://officemix.uservoice.com/
MyAnalytics https://myanalytics.uservoice.com/
Office 365 https://office365.uservoice.com
Office 365 Groups https://office365.uservoice.com/forums/286611-office-365-groups
OneDrive https://onedrive.uservoice.com
OneNote https://onenote.uservoice.com
Outlook https://outlook.uservoice.com
Planner https://planner.uservoice.com
Power BI https://ideas.powerbi.com/forums/265200-power-bi-ideas
PowerApps https://powerusers.microsoft.com/t5/Product-Feedback/ct-p/PA-feedback
PowerPoint https://powerpoint.uservoice.com
Project https://microsoftproject.uservoice.com
SharePoint https://sharepoint.uservoice.com
StaffHub https://staffhub.uservoice.com
Skype for Business https://www.skypefeedback.com
Stream https://techcommunity.microsoft.com/t5/Microsoft-Stream-Ideas/idb-p/StreamIdeas
Sway https://sway.uservoice.com
Teams https://microsoftteams.uservoice.com/forums/555103-public
To-Do https://todo.uservoice.com/
Visio https://visio.uservoice.com
Word https://word.uservoice.com
Yammer https://yammer.uservoice.com

Uservoice provides an opportunity for customers or end users of products to provide feedback, request features and interact with others as well as with the product teams. If you discover a request or feedback that you agree with and would like to support, you can add a vote to that post. Each UserVoice member receives a limited number of votes to use and these votes are returned once the the particular feedback has been acknowledged and completed. See above screen capture.

Another useful feature of UserVoice is the ability to see the status of the posts such as Noted, Planned, Under Review, Started, and Completed. See examples below:

Source: https://blogs.technet.microsoft.com/o365guy/2018/01/02/submit-product-feedback-or-feature-requests-to-microsofts-virtual-suggestion-boxes/

Fix For Error: Failed To Process Configuration Manager Update 0x87d20b15

With the release of version 1710 for System Center Configuration Manager Current Branch on November 20, 2017, I pursued to update my ConfigMgr 1706 site to take advantage of some of the exciting new features, which you can read more here! Use this PowerShell script to enable the early update ring for ConfigMgr 1710.

I tested the update in my test lab and the upgrade to v1710 worked just fine. As usual with my production environment, I always run the prerequisite checker to make sure nothing is flagged as an issue, which in my case all was fine with green checkmarks. However, the actual installation of the update failed on the Installation step for “Upgrade ConfigMgr database” as seen in the screen capture above. The description for the error indicates: [Failed]: Upgrading ConfigMgr database. Check cmupdate.log for details.

The following is an error was seen in the cmupdate.log: Failed to apply update changes 0x87d20b15

I located a blog post by my friend Anoop dated from October 2016 referencing a similar error code where he points to providing the NT Authority/System account in SQL with the sysadmin security role, however that was not the cause of my upgrade failure and the security roles were already defined correctly. The following TechNet thread was a dead end as well.


My post on Twitter as seen above caught the attention of another friend of mine, David James, Director of Engineering for ConfigMgr at Microsoft, who with his team were able to pinpoint the problem in no time at all and quickly provided a solution which resolved my ConfigMgr 1710 upgrade installation hang up. Thanks David and to the ConfigMgr team! The gist of the problem is that my environment had an old compatibility level 100 set for the SQL Server database for the CM_XXX database, and you can find this referenced in the cmupdate.log file. Changing it to 110 fixed the compatibility level needed for ConfigMgr 1710.

Run the following query in SQL Management Studio (please change XXX to your ConfigMgr Site Code) and retry the installation via the Update and Servicing node in the ConfigMgr Admin Console. This also addresses the issue where TRY_CONVERT is not recognized as a built-in SQL function:

ALTER DATABASE CM_XXX SET COMPATIBILITY_LEVEL = 110

SUCCESS!!

** Additional Mention **

Check out this blog post, “In Telemetry We Trust?” written by a friend and fellow ConfigMgr admin, Peter Egerton, who shares a similar experience and the positive nature of telemetry data especially in the ConfigMgr space.

Review – Anker Roav DashCam C2

I recently got the chance to use and review one of Anker‘s newest products, called the Roav DashCam C2. This is a video camera to be used in a vehicle to record one’s travel from point A to point B for various reasons. In this day and age, we are surrounded by video cameras from speed traps, traffic lights, building security, merchandise stores, gas stations, office buildings, elevators, and the list goes on. Lately, video cameras aka dashcams have become more and more popular especially for documentation purposes as well as for proving wrong doings by other parties on traffic violations, and much more.

Check out some of these footage on YouTube from dashcams. There are also some plane crashes caught on dashcams such as the Taiwan plane crash, Mukilteo plane crash, and the Afghanistan plane crash to name a few. As you can see, these are unbelievable captures which would otherwise be disputed.

Now back to the Roav DashCam C2. Here’s what it offers:

  • Size: 3.4 x 2.5 x 1.4 inches
  • Weight: 3.5 ounces
  • Display: 1080P / 720P with a 3 inch LCD screen size
  • Storage: microSD card (not included)
  • Chipset: Ambarella A12
  • Sensor: Sony IMX323
  • Camera: f/2.0 wide-angle lens
  • Operating Temperature: -4*F – 158*F

Pros:

  • Easy to setup
  • Night mode for clarity
  • Parking detection mode
  • Emergency recording to lock footage
  • Easy to use menu and buttons
  • High quality video captures
  • Wide-angle coverage
  • Automatic recording
  • Small form factor

Cons:

  • No zooming for tighter or closer recording scenes
  • 32GB microSD card preferred but not necessary. More of an annoyance reminder on each startup
  • Finicky touch screen
  • No smartphone app
  • No WiFi or Bluetooth capability
  • microSD card must be removed from unit to transfer to computer

Check out my unboxing video:

The Roav DashCam C2 is quite simple to use and just works. More often than not, I forget that I have it installed since I have it positioned behind my rear view mirror with the suction cup attachment provided. This is a good thing, as each drive I do with my vehicle is automatically recorded and I have the footage when I need it. The camera activates as soon as I start my car and power is received by the dashcam.

I do have a couple of pet peeves, and the first one is the constant reminder that I should be using a 32GB microSD card when the dashcam automatically turns on, but it works just fine with a lesser capacity card, which is what I’m using. The device is smart enough to loop and delete older recordings when it needs space for newer recordings. The other is the lack of a smartphone app which is available for the C1 model but not for the C2. Using an app allows more streamlined use of the device such as to change settings and to transfer recordings for upload to various sources. Otherwise, I’m quite happy with this dashcam as it does what I need it to do which is to record my travels without any effort. Plus, it’s inexpensive too. You’ll find it on Amazon for $79.99.

    

The reminder message to use a 32GB microSD card:

The various options as seen in the menu screens:
  
  
  
  
  

Follow @Hoorge on Twitter and join Tech Konnect on Facebook and Twitter to stay current on technology related matters.

ADMX Template For Windows 10 Fall Creators Update (1709) Now Available

On October 17, 2017, Microsoft has started to rollout Windows 10 Fall Creators Update (1709) to customers worldwide. The following tools to support this latest release has been made available, which includes Windows 10 Administrative Templates (.ADMX) and Windows Assessment and Deployment Kit (ADK) as previously mentioned in my blog post. I have also posted about the Remote Server Administration Tools (RSAT) for Windows 10 Fall Creators Update.

Windows 10 Administrative Template (.ADMX)

Remote Server Administration Tools for Windows 10 (RSAT)

Windows 10 Assessment and Deployment Kit (ADK)

Microsoft Office 2016 Administrative Templates and Office Customization Tool is also available for download.

Follow @Hoorge on Twitter and join Tech Konnect on Facebook and Twitter to stay current on technology related matters.

Remote Server Administration Tools (RSAT) For Windows 10 v1709

The latest version of the Remote Server Administration Tools (RSAT) for Windows 10 Falls Creators Update v1709 have been released. The download is available here. You will find the following download files available for version RS1-1.2, RS3-1.0 corresponding to x86 or x64 Operating Systems:

  • WindowsTH-RSAT_WS_1709-x64.msu (94.5MB)
  • WindowsTH-RSAT_WS_1709-x86.msu (69.9MB)
  • WindowsTH-RSAT_WS2016-x64.msu (92.3MB)
  • WindowsTH-RSAT_WS2016-x86.msu (69.5MB)

See here if you would like to determine if a computer is running 32-bit or 64-bit Windows OS.

Follow me (@Hoorge) on Twitter and join Tech Konnect on Facebook and Twitter (@TechKonnect) to stay current on technology related matters.