[mssms] RE: Re-Using same NIC (docking stations) on multiple machines.

That is very handy, but there is no way to exclude a range based on the Manufacturer info ? Since a MAC is "MM:MM:MM:SS:SS:SS" it would be nice if we could just do "MM:MM:MM:??:??:??" or something so that we did not have to have hundreds (or more) of MACs in there Maybe I have to check this

RE: [mssms] RE: SQL Query question

:) From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Sherry Kissinger Sent: Tuesday, April 4, 2017 12:37 PM To: mssms@lists.myitforum.com Subject: Re: [mssms] RE: SQL Query question I was thinking Henry was just asking a "in general, which sql query s!cks

Re: [mssms] RE: SQL Query question

I was thinking Henry was just asking a "in general, which sql query s!cks less". the fact that the subselect was using .net in there was just coincidence. On Tue, Apr 4, 2017 at 7:57 AM, Garth Jones wrote: > Is there a reason why you are not using the MOF edit for this? >

[mssms] RE: Re-Using same NIC (docking stations) on multiple machines.

Fantastic. Thanks Jason. Daniel Ratliff From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Jason Sandys Sent: Tuesday, April 04, 2017 8:54 AM To: mssms@lists.myitforum.com Subject: [mssms] RE: Re-Using same NIC (docking stations) on multiple machines. You

[mssms] RE: Re-Using same NIC (docking stations) on multiple machines.

You can use the "real" API here, WMI: https://social.technet.microsoft.com/Forums/en-US/da590ff8-0e96-4cc9-ac94-0724f7240dab/import-duplicate-hardware-identifiers?forum=ConfigMgrDeployment#0682002a-3abc-489a-a6dc-ffd05da910f5 J From: listsad...@lists.myitforum.com

[mssms] RE: SQL Query question

Is there a reason why you are not using the MOF edit for this? I'm in the process of restoring my lab so I can't check this but I don't think that OS like Win 10 and Server 16 listed .Net 4.5 in the installed software. This maybe only anniversary edition too. From:

[mssms] RE: CB 1702 support

1. Yes they are supported as clients: https://docs.microsoft.com/en-us/sccm/core/plan-design/configs/supported-operating-systems-for-clients-and-devices 2. ADK for what? In general, using the latest supported version is generally recommended. Guidance at

Re: [mssms] RE: SQL Query question

ceviewer -- I look at that all the time to see what was the longest running collection (the last time). I also have a couple of reports which can tell me which collections took > xx seconds to run, and via SRS then I link to another report about "everything I know about that collection that I

[mssms] RE: SQL Query question

Yes Best regards / Cordialement Henry E. WILSON Technical Expert Engineer Information Technology & Solutions Infrastructure Management Automation Services 55 Corporate Drive Bridgewater, NJ 08807 TEL.: +1 908 981 3288 CELL.: +1 610 724 1169 FAX: +1 908 635 5858

[mssms] RE: SQL Query question

As a side note: We've been chasing excessive collection evaluations for some time (we have over 5,000 collections now) There are also 2 "Exclude Collections" in the previously created collections and this collection is scheduled to evaluate every day. Our environment: All Virtual SCCM 1606 1

[mssms] RE: Re-Using same NIC (docking stations) on multiple machines.

This is built into 1610 now. I would use that method. However, it cannot currently be automated, that I have seen. I have a UV req in to add a PowerShell cmdlet. https://www.systemcenterdudes.com/sccm-duplicate-hardware-identifiers/

Re: [mssms] RE: SQL Query question

Neither. I'd use this one. resourceid is resourceid is resourceid. there is no reason to join sms_r_system in the subselect itself. Extra work for SQL, and not needed. We've done this type of 'not in' subselect lots of times. select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType,

[mssms] RE: SQL Query question

Hi Henry, what exactly is the goal? Is it to find all computers without .net 4.5.2? From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of henry.wil...@sanofi.com Sent: April 4, 2017 6:16 AM To: mssms@lists.myitforum.com Subject: [mssms] SQL Query question

[mssms] SQL Query question

Hello SQL Guru's We're having a discussion with some Admin's in Europe and I would like an opinion on 2 Collection queries looking for the same result: Which one is more efficient? Collection Query #1: select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name,