« Calling Name in OCS 2007 R2 | Main | Microsoft releases XMPP Gateway for OCS 2007 R2, enables free AOL connectivity »

08/31/2009

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

Marcel Gta

This info is very very useful, however i couldn't use the stored procs directly, so here are the views/tables:

View: PublishedCategoryInstanceView.
Publisherid = integer representing user. You can find the users in
the table Resources.

Categoryname = 4. This means 'state'

Containernum = 3 or 4 . its the containername. see this article for more info

example: user@blbl.com = id = 8

select DataLength,Data //get also LastPubTime
into :DL,:ddata
from PublishedCategoryInstanceView
where PublisherId = 8 and CategoryId = 4 and ContainerNum = 2;

The ddata variable is a binary blob containing all ascii hex codes
representing the xml. Just decode ascii to characters to form the xml. you can use the datalength to get the size of the xml.

I used this code to interface a management dashboard written in qlikview to monitor usage statistics.

Marcel


Pat

This is great information, Mike. You see current connections, presence data, and contacts.

I need to figure out how to query this all in PowerShell! Off to the lab!

Thanks!

The comments to this entry are closed.

Important Information:
The views and opinions outlined within this blog are solely my own, and do not represent those of any organization. All technical procedures contained herein are provided without warranty of any kind. These procedures may or may not fall within the support guidelines of any company mentioned. If you have questions about the supportability of any information in this blog please contact the appropriate vendor.

Twitter Updates

    follow me on Twitter
    Blog powered by Typepad