SQL Tip: COUNTing NULL values

I've been asked about counting NULL values several times so I'm going to blog about it in hopes others will be helped by this explanation of NULL values in SQL and how to COUNT them when necessary. Note, my examples make use of a table found in the System Center Configuration Manager database. First, it’s…


How To Add Or Remove Cmdlet Parameter From RBAC Management Role

In the previous posts on RBAC we have looked at customising various roles to ensure that the role contained the minimum amount of cmdlets.  RBAC provides even more granularity, and we can add or remove specific parameters from a cmdlet.  Since some folks asked for examples on this topic here are a couple of quick…


Different ways in which Personal tag can be published.

Below are different ways in which Personal tags can be made available to users. 1) Adding Personal tag in the policy. Personal tag can be made available by adding the tag in the policy and then applying the policy to the mailbox. This personal tag will be available to all user who have the same…


Polycom Group 500 integration with Lync Server 2013

So we got hands on a Polycom Group 500! This is a relative new RealPresence product from Polycom – although smaller than HDX 7000, it continues to maintain most of its features. In Group Series, Polycom dropped the support for ISDN and People On Content. As of the writing of this article, the Polycom Group Series is…


Lync Phone Edition Test Device won’t update to unapproved version

Last week we were trying to update a Lync Phone Edition to 4.0.7577.4414, and the update was successfully imported as shown in the next print screen: After a factory reset, the phone was requesting the last approved version (4.0.7577.4411). In the logs we found this: 10/30/2013 10:44:24,david.paulino@*****,10.0.1.1,UCPhone,30/10/2013 05:42:45,”0004F2959F06″,”0004f2959f06″,”POLYCOM”,”CX500″,”Rev-4″,”ENU”,cpe.nbt;4.0.7577.4397;26/06/2013 15:16:38, http://<internal FQDN>/RequestHandler/Files/UCPhone/POLYCOM/CX500/Rev-4/ENU/4.0.7577.4411/CPE/CPE.nbt; https://<external FQDN>/RequestHandlerExt/Files/UCPhone/POLYCOM/CX500/Rev-4/ENU/4.0.7577.4411/CPE/CPE.nbt;4.0.7577.4411;27/09/2013 22:03:02 After…


Work Folders on Clusters

In the previous blog post, I provided a step by step guide to set up Work Folders in a lab environment using the Preview release of Windows Server 2012 R2. With the GA release, Work Folders leverages Windows Failover clustering to increase availability. For general details about failover clusters, see Failover Clustering. In this blog…


Adding new SIP Domain to OCS 2007 R2

Here is a step by step tutorial how to add a new SIP Domain to OCS and then migrate all users to the new domain. One thing that we don’t need to worry about is the Users Contact Lists,  since OCS stores contacts as Unique ID, rather as SIP Address. This allow us to change…


A new user attribute for Work Folders server Url

Overview To continue the blog post series on Work Folders, I’d like to talk about how to manage a new attribute storing the Sync Server Url as part of the user object in Active Directory Domain Services (AD DS). If you have seen the demo of the client setup in this video [00:08:20], it shows…


Effective Rights – What can users do?

I guess I’m not the only one that have been sitting and wondering .. Hmm.. What permissions does these users got in Active Directory actually? I can see a lot of groups in the access control list but how do I relate that to a certain user. Ok, we got the Effective Rights tab under…


Lync 2013 Client IMWarning / Disclaimer issues with Special Characters

IMWarning is a message that is showed every time a chat windows is opened. This is a new feature on Lync Client 2013 Basic and Full, since the RTM version has a limitation to show Special Characters. In Portuguese, for instance,  “Atenção” contain the ç and ã characters which will not be correctly displayed in Lync 2013 Client. To…