SOLVED

Distribute Windows patches in a CM 1910 environment

%3CLINGO-SUB%20id%3D%22lingo-sub-1328988%22%20slang%3D%22en-US%22%3EDistribute%20Windows%20patches%20in%20a%20CM%201910%20environment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1328988%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EWe%20changed%20our%20approach%20to%20distribute%20Windows%20updates%20in%20the%20days%20of%20home%20office.%20We%20use%20CM%201910%20and%20here%20an%20IBCM%20server%20in%20the%20dmz.%20In%20addition%20we%20configured%20our%20client%20in%20our%20VPN%20boundary%20group%20to%20obtain%20security%20patches%20from%20microsoft%20as%20the%20prefered%20way.%26nbsp%3BIs%20there%20already%20an%20existing%20report%26nbsp%3Bwhich%20I%20can%20use%26nbsp%3Bin%20order%26nbsp%3Bto%20find%20out%20where%20clients%26nbsp%3Breceive%20their%20patches%20from%20(for%20management)%3F%20%26nbsp%3BProving%20that%20they%20use%20the%20patches%20from%20Microsoft%20on%20the%20internet%20and%20not%20the%20on%20prem%20distribution%20point.%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EIn%20addition%20it%20seems%20quick%20long%20till%20clients%20report%20back.%20Is%20there%20a%20way%20to%20speed%20this%20up%3F%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EThanks%20in%20advance%2C%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EAndy%20%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1329095%22%20slang%3D%22en-US%22%3ERe%3A%20Distribute%20Windows%20patches%20in%20a%20CM%201910%20environment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1329095%22%20slang%3D%22en-US%22%3EDune%20thanks%20for%20that.%20So%20your%20expectation%20would%20be%20that%20%22Microsoft%20Update%22%20would%20be%20the%20leading%20content%20source%20in%20the%20scenario%20I%20described%2C%20correct%3F%20If%20this%20is%20still%20%22Distribution%20Point%22%20something%20is%20not%20configured%20correctly%2C%20right%3F%20%3B)%3C%2Fimg%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1329113%22%20slang%3D%22en-US%22%3ERe%3A%20Distribute%20Windows%20patches%20in%20a%20CM%201910%20environment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1329113%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F63132%22%20target%3D%22_blank%22%3E%40Dune%20Desormeaux%3C%2FA%3E%26nbsp%3B%20Can%20you%20let%20us%20know%20what%20SQL%20view%20that%20is%20hitting%20to%20create%20a%20custom%20report%20off%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1329144%22%20slang%3D%22en-US%22%3ERe%3A%20Distribute%20Windows%20patches%20in%20a%20CM%201910%20environment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1329144%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F309823%22%20target%3D%22_blank%22%3E%40Andy0401%3C%2FA%3E%26nbsp%3B%20Correct%20as%20long%20as%20enough%20time%20has%20passed%20for%20data%20to%20flow%20to%20the%20server.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1329269%22%20slang%3D%22en-US%22%3ERe%3A%20Distribute%20Windows%20patches%20in%20a%20CM%201910%20environment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1329269%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F139234%22%20target%3D%22_blank%22%3E%40Dawn%20M%20Wertz%3C%2FA%3E%26nbsp%3BI%20am%20not%20sure%20about%20the%20details%20but%20I%20would%20start%20with%20vSMS_ClientDataSources*%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1329286%22%20slang%3D%22en-US%22%3ERE%3A%20Distribute%20Windows%20patches%20in%20a%20CM%201910%20environment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1329286%22%20slang%3D%22en-US%22%3EThanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1329027%22%20slang%3D%22en-US%22%3ERe%3A%20Distribute%20Windows%20patches%20in%20a%20CM%201910%20environment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1329027%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F309823%22%20target%3D%22_blank%22%3E%40Andy0401%3C%2FA%3E%26nbsp%3BDune%20here%20from%20the%20MEM%20team.%20I%20think%20the%20Client%20Data%20Sources%20dashboard%20in%20the%20ConfigMgr%20console%20should%20help%20you%20answer%20the%20question%20you%20have%20about%20how%20much%20content%20is%20flowing%20from%20Microsoft%20Update!%20I%20have%20attached%20a%20screenshot%20below%20of%20where%20to%20find%20this%20in%20the%20console.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ClientDataSources.png%22%20style%3D%22width%3A%20948px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F185891i5374F68D5A7F7517%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22ClientDataSources.png%22%20alt%3D%22ClientDataSources.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

We changed our approach to distribute Windows updates in the days of home office. We use CM 1910 and here an IBCM server in the dmz. In addition we configured our client in our VPN boundary group to obtain security patches from microsoft as the prefered way. Is there already an existing report which I can use in order to find out where clients receive their patches from (for management)?  Proving that they use the patches from Microsoft on the internet and not the on prem distribution point.

In addition it seems quick long till clients report back. Is there a way to speed this up?

Thanks in advance,

Andy

6 Replies
best response confirmed by Harjit Dhaliwal (Frequent Contributor)
Solution

@Andy0401 Dune here from the MEM team. I think the Client Data Sources dashboard in the ConfigMgr console should help you answer the question you have about how much content is flowing from Microsoft Update! I have attached a screenshot below of where to find this in the console.

 

ClientDataSources.png

Dune thanks for that. So your expectation would be that "Microsoft Update" would be the leading content source in the scenario I described, correct? If this is still "Distribution Point" something is not configured correctly, right? ;)

@Dune Desormeaux  Can you let us know what SQL view that is hitting to create a custom report off it?

@Andy0401  Correct as long as enough time has passed for data to flow to the server.

@Dawn M Wertz I am not sure about the details but I would start with vSMS_ClientDataSources* :)

www.000webhost.com