Counting Usage of SP2010 UPS User Properties

I needed to report on the usage count of particular UPS user properties such as Skills and Responsibilities. If you look at the property in Central Administration, you can see a usage count on the screen. This field is populated using an internal class so I needed to look for another way to do it. When looking, I found the following property:


However, when you go to use it, it does not return a value and you will find it is producing a SQL error. You can find all the ins and outs of the issue in this blog post:

However, the resolution in this blog post is NOT supported by Microsoft as it requires modifying the SharePoint database. After a quick call with Microsoft, I learned you can use this method to get the count:


Hopefully this will help someone else out who runs into this issue. Here is an example PowerShell script with the method used in it:

Add-Type -Path “c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ISAPI\Microsoft.Office.Server.dll”
Add-Type -Path “c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ISAPI\Microsoft.Office.Server.UserProfiles.dll”
$propertyName = “SPS-Skills”
$siteUrl = “http://dev”
$site = Get-SPSite $siteUrl
$context = Get-SPServiceContext $site
$upcm = New-Object Microsoft.Office.Server.UserProfiles.UserProfileConfigManager($context)
Write-Host $upcm.CountProfilesWithProperty($propertyName)

About J.D. Wade

Senior SharePoint Consultant, husband, active in community theatre, love watching movies, have been described as “quirky”, aka “KB Man”
This entry was posted in Microsoft SharePoint, SharePoint Server 2010 (SP 2010) and tagged . Bookmark the permalink.

20 Responses to Counting Usage of SP2010 UPS User Properties

  1. Pingback: Office server | Connectmyheart

  2. Hello everyone, it’s my first pay a quick visit at this web page, and post is truly
    fruitful designed for me, keep up posting these articles.

  3. At this time it looks like Movable Type is the top blogging platform available right now.
    (from what I’ve read) Is that what you are using on your blog?

  4. whoah this weblog is wonderful i really like reading
    your articles. Keep up the great work! You recognize,
    many individuals are hunting around for this info, you could aid them greatly.

  5. Thanks for your marvelous posting! I really enjoyed reading it, you can be a
    great author. I will ensure that I bookmark your blog and
    definitely will come back from now on. I want to encourage you to continue your great work, have a nice morning!

  6. I am now not certain the place you are getting your info, however
    great topic. I must spend some time learning much more or understanding
    more. Thanks for magnificent info I was looking for this info
    for my mission.

  7. kids program says:

    WOW just what I was searching for. Came here by searching for home schooling

  8. Asking questions are in fact nice thing if you are not understanding something completely, however
    this article presents good understanding yet.

  9. ss says:

    It is in reality a great and helpful piece of info. I’m satisfied that you just shared this helpful info
    with us. Please keep us up to date like this. Thanks for sharing.

  10. You are so cool! I do not suppose I have read through a single thing like this before.
    So good to discover another person with unique thoughts on this issue.
    Seriously.. thanks for starting this up. This site is something that is required on the
    internet, someone with some originality!

  11. wedding says:

    Handkerchief dances by men and women are a must and finally the breaking
    of a pomegranate at the receptions ensures fertility for the couple.
    Going to a JP or Notary before stopping at a burger shop is
    not what this assignment is asking the students to
    consider. 2009 by Pamela Smale Williams LPC LMFT AAMFT AASECT.
    If feel eager to buy it, you can consult with the designer if can make
    some reduction to the beadings or embroidery, but keep most of
    the original design, abandon workmanship on the train and skirt.
    If you intend to use real flowers, you should consider arranging your wedding for a time when the
    flowers you want are in season.

  12. Em poucos meses a tratamento contínuo é verosímil examinar
    em direção a redução da velocidade do desenvolvimento da calvície, senão essa
    correção da mesma.

  13. Ecellent goods from you, man. I have understand your stuff prior to and you’re just too
    magnificent. I really like what you have receeived right here,
    really like what you’re stating and the way in which during which you assert it.
    You aree making it enjhoyable and yyou still
    take care oof to stay it wise. I can’t wait to read far more from you.
    This is actually a wonderful site.

  14. That is a great tip especially to those new to the blogosphere.
    Brief but very precise info… Appreciate your sharing this one.
    A must read post!

  15. At this time I am ready to do my breakfast, when having
    my breakfast coming yet again to read further news.

  16. I don’t even know how I stopped up here, but I assumed this submit used to
    be great. I don’t realize who you’re however
    definitely you are going to a famous blogger in case you aren’t already.


  17. new launch says:

    When I initially left a comment I appear to have clicked the -Notify me
    when new comments are added- checkbox and now whenever a
    comment is added I get four emails with the same comment.
    Is there an easy method you are able to remove me from that service?

  18. What’s up, of course this paragraph is genuinely nice and I have learned
    lot of things from it on the topic of blogging. thanks.

  19. sinemoo says:

    I was curious if you ever thought of changing the layout of
    your site? Its very well written; I love what youve got to say.
    But maybe you could a little more in the way of content so people could connect with it better.
    Youve got an awful lot of text for only having one or 2 images.
    Maybe you could space it out better?

  20. health says:

    Amazing! Its genuinely remarkable piece of writing, I have got much clear idea regarding from this post.

Join the discussion by leaving a comment

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s