question

SteveDSouza-4922 avatar image
0 Votes"
SteveDSouza-4922 asked SteveDSouza-4922 commented

CMCB Staggered ADR question

Hello,

We have developed a PowerShell-based automated SQL 2017 cluster patching solution. The solution remotely triggers the 'Available' updates on the remote CMCB Agent through CCM WMI SDK. The updates are going to be deployed through ADR with the SQL CU KBs and applicable OS updates advertised as 'Available' as it helps us sequence the cluster nodes patching order to fit in with the SQL Availability Group failover requirement.

Here comes the challenge - We have 3 environments - DEV, TEST and Prod.

For DEV, we create an ADR which downloads the SQL CU and OS updates immediately after the Patch Tuesday and it deploys all the applicable updates as 'Required' so they get installed as part of DEV server maintenance window. No problem here.

For TEST environment however, we would like the monthly ADR to download only those SQL CUs that were released the previous month (i.e. 30 days ago) and not the current month's SQL CU (this is to await DEV SQL CU testing results). Just wanted know what is the easiest way to do it. The ADR deployment will be targeted to all the TEST servers with 'Available' deployment so our above PowerShell orchestration solution will trigger the installation from our remote Scheduler server as per the Change Schedule in the right sequence. (Please note in this case the OS updates are not a problem as we will have a separate OS ADR which should download monthly updates - no 30-days postponement in this case unlike SQL CU)

The Prod environment is exactly like the TEST above except that the SQL CUs should be more than 60 days old.

Are you able to help me with the setting up of ADR and its associated deployment? Is this something that needs to be set up on the ADR or should we deal with it as part of deployment (playing with the deadline etc.)? Like I mentioned above, we use 'Available' deployment for TEST and Prod, so we take control of the update installation-triggering through our custom PowerShell solution, so there will be no CMCB-deployment defined deadline as such.

Thanks, Steve

mem-cm-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AllenLiu-MSFT avatar image
0 Votes"
AllenLiu-MSFT answered SteveDSouza-4922 commented

Hi, @SteveDSouza-4922
Thank you for posting in Microsoft Q&A forum.
It seems ADR cannot add a Search Criteria to filter the updates 30 days ago.
However, when we filter the update in All Software Updates from SCCM console, we can add a criteria to filter the updates one month ago:
110551-14.jpg

Maybe we can only filter the SQL CUs from All Software Updates and create and deploy the SUG manually.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



14.jpg (186.3 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks @AllenLiu-MSFT but we ideally want an automated solution so ADR was what we had in mind, without which it will end up becoming a manual activity every month which is something that we would like to avoid :(

0 Votes 0 ·

Hi, @SteveDSouza-4922
Thanks for the feedback, I know do this manually every month is a bad choice.
Microsoft may think that users will choose to install the latest updates, so this option is not added to the search criteria of ADR, but now it seems this is a reasonable demand. You may try to put forward your needs in SCCM User Voice:
https://configurationmanager.uservoice.com/forums/300492-ideas

0 Votes 0 ·

117052-cmcb-adr.jpg



Hi @AllenLiu-MSFT @Jason-MSFT - Would you be able to confirm if the above setting in the ADR serve our purpose as described in the original post above? We have tested it and it does look like it's doing what it should. Just wanted to make sure we have not missed anything. Thanks.

0 Votes 0 ·
cmcb-adr.jpg (116.1 KiB)