[mssms] RE: OT - Excel VLOOKUP help?

Never mind, turns out it's a limitation of VLOOKUP - the value it checks against must be in the first column. From: Murray, Mike Sent: Monday, October 10, 2016 4:42 PM To: mssms@lists.myitforum.com Subject: OT - Excel VLOOKUP help? I'm sure there's an Excel guru out there that can easily

[mssms] OT - Excel VLOOKUP help?

I'm sure there's an Excel guru out there that can easily explain why this isn't working. In the "testcomp" sheet I'm trying to looking up the distinguished name value on column C to a matching value on the "testuser" sheet and return the friendly user name (or any other columns I choose). It keeps

RE: [External] [mssms] RE: IP Helpers for PXE

So the SCCM PSP will only respond with a partial offering, and never a complete DHCP address. So it can never interfere with regular DHCP requests, only PXE DHCP requests. So nothing can wrong, or well… machines might not PXE boot if something is wrong, but it will never affect anything else.

[mssms] RE: Endpoint client definitions not updating regularly

I think this may be it. We had Forefront Endpoint Protection 2010 selected, but not Windows Defender in our ADR. Hoping the new settings below do the trick. Thanks! From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Nemec, Dale Sent: Monday, October

[mssms] RE: Exclude a single patch on 1 Server

Not directly no. You have to create a new collection for that client and a new software update group without that update deployed to that collection. This is something they've been working on and will hopefully have a solution in the near future though. J From: listsad...@lists.myitforum.com

Re: [mssms] RE: Endpoint client definitions not updating regularly

How often are you syncing your SUP? My understanding is if it doesn't see newer updates from the sync, it would get processed by the ADR. I think definitions are published every 4 hours or so? Otherwise, I think in the client settings/SCEP settings you can specify that the client go out to

[mssms] Exclude a single patch on 1 Server

Hello, Is it possible to exclude a single KB on a single server? I have a patch I need to make sure does not install on only 1 server. Thank you, Brian

[mssms] RE: Endpoint client definitions not updating regularly

Mike, Look at your ADR. Last month we had to add in the Windows Defender updates for Windows 10 since the Definition files appear to have been split based on OS type. Win7/8.1 get one set of files, Win10 gets another set. Our Definition package size also grew about 3 times its previous size

[mssms] Endpoint client definitions not updating regularly

We have our Endpoint Protection settings to check for updates every 8 hours, but many clients that are online are 2, 3, even 5 days out of date. I've verified the definition updates are being downloaded and set to deploy. I've verified our ADR is deployed to All Systems. This is a big concern -

Re: [mssms] Report stopped working after 1606 upgrade

sorry, 5.00.8412.1000 (exactly the right version, missing the 0 and it wouldn't work either) On Mon, Oct 10, 2016 at 12:03 PM, Sherry Kissinger < sherrylkissin...@gmail.com> wrote: > I opened up that report. for "Software title Filter"; you can use a %; > like Configuration Manager% > But for

Re: [mssms] Report stopped working after 1606 upgrade

I opened up that report. for "Software title Filter"; you can use a %; like Configuration Manager% But for Version, it has to be EXACTLY right. I.e., 5.0.8412.1000 ; no %, that particular field is not using a "like" in the sql query. It "works for me" if I follow the exact rules it wants me to

Re: [mssms] SCCM 2016 - Does SCCM 2016 Released ?

It is called cm1606. Sent from my iPhone On Oct 9, 2016, at 10:26 AM, S ConfigMgr > wrote: Does SCCM 2016 Released ? or it will called as CM 1606 ? -- Thanks, ED

[mssms] Report stopped working after 1606 upgrade

Hello all, We just upgraded from SCCM 1602 to 1606, and after doing so the report "Computers with specific software registered in Add Remove Programs" seems to have broken. All searches return zero results. It looks like the data it should be pulling is there based on the specific computer A/R

[mssms] RE: IP Helpers for PXE

I got some good advice to remove all DHCP options and just use an IP helper on the router’s VLAN config. I put that in place, and everything is working. Thanks, all. Kenneth Merenda From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of

RE: [mssms] Horrible food at Ignite

I thought the content was great. I handle our azure/server/system center stuff, so there was a lot of content. I also was at the last TechEd, so I knew what to expect and not get overwhelmed. I thought the food sucked. I don’t really care of the idea of the boxed lunch, but understand it. If