To create a SCCM collection that excludes members of another collection, use the below query. In my example the collection ID is P000004C. This is useful when combining with the ‘limit collection’ function. select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.ResourceId not in (select ResourceID from SMS_CM_RES_COLL_P000004C)  

Continue reading...

Here is a good VB script for copying the group membership from one Active Directory group to another:   strSGroupDN = InputBox (“Enter the DN of Source Group” & VBCRLF &_ vbcrlf& _ vbcrlf& _ “e.g. CN=Source Group,OU=Users,DC=NWTraders,DC=com”) strDGroupDN = InputBox (“Enter the DN of Destination Group” & VBCRLF &_ vbcrlf& _ vbcrlf& _ “e.g. [...]

Continue reading...

There is a simple and great extension of the Lync 2010 client that can allow you to have a real-time conversation with someone in a completely different language. For example, just by adding a few registry entries, you can have an entire Lync conversation with someone who doesn’t speak English and Lync will do the [...]

Continue reading...

If you are running Lync Server 2010 and have previously used OCS, you may realize how hard it is to find the versions of Lync that your clients are running. It was very easy to do with OCS. Stephen Olsen has written a fantastic tool that will show you the version each client is running [...]

Continue reading...

I recently had a requirement to report on server ages for the machines in our environment. Adding the ‘BIOS Manufacture date’ and ‘OS Install Date’ should be a good indication of this. The query will also return some other helpful fields like model, manufacturer, RAM and processor: SELECT distinct CS.name0 as ‘Server Name’, OS.Caption0 as [...]

Continue reading...

As part of the network discovery process, I noticed that it was picking up the iPhone and other Apple machines (Macs, iPads) that were on the corporate network either via being plugged in or on the wireless LAN. Shortly afterwards, there was a requirement to report on all the Apple devices found in the environment. [...]

Continue reading...