Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
How to get an account's presence from OCS2007 database RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    In LCS2005
    I can get everyone's presences stat from database with these sql scripts:

    Code Snippet
    use Rtc
    select status,count(*) as count from
    (select case
    when Availability = '300' and Activity  = '700' then 'online'
    when Availability = '300' and Activity  = '350' then 'busy'
    when Availability = '300' and Activity  = '250' then 'hidden'
    when Availability = '300' and Activity  = '100' then 'away'
    else 'offline' end as status from Endpoint) a group by a.status

     

     

    But now in OCS2007, database,table schema and mechanism have been changed.
    (etc: dabase changed from rtc to rtcdyn)

     

    How to get an account's presence from OCS2007 database?

    Thanks for any help.

    Wednesday, August 29, 2007 11:38 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    The RTC APIs provide an interface for this and are the best way to obtain presence information.

     

    Sunday, September 2, 2007 8:53 PM
    Moderator

All replies