Jabber / Accessing Historical Data

Say your objective is to use Jabber historical data to know the activity of a user during the day.

You want to build an application that builds the Jabber activity throughout the day. It would query everyone’s status every X minutes, to see if each person’s status has changed, and if it has changed, it would write a new record to our log or database.

For example here is sample data for two users, but you want all users.

User="X" Status="Away" Datetime="10:20 AM 2016-09-06"

User="Y" Status="Available" Datetime="10:20 AM 2016-09-06"

User="X" Status="Away" Datetime="10:25 AM 2016-09-06"

User="Y" Status="Available" Datetime="10:25 AM 2016-09-06"

User="X" Status="Away" Datetime="10:30 AM 2016-09-06"

User="Y" Status="Available" Datetime="10:30 AM 2016-09-06"

User="X" Status="Available" Datetime="10:35 AM 2016-09-06"

User="Y" Status="Available" Datetime="10:35 AM 2016-09-06"

User="X" Status="Available" Datetime="10:40 AM 2016-09-06"

User="Y" Status="Available" Datetime="10:40 AM 2016-09-06"

User="X" Status="Do not disturb" Datetime="10:45 AM 2016-09-06"

User="Y" Status="Available" Datetime="10:45 AM 2016-09-06"

Jabber instant messaging 'historical' information is generally achieved via the compliance mechanisms, which write all IM activity to a configured external database: Instant Messaging Compliance for IM and Presence Service on Cisco Unified Communications Manager, Release 10.5(1) - Pla…

I'm not aware of any similar way to store/retrieve historical presence updates/status, however.  You may want to refer to the IM&P 'Presence Web Service' here, which allows an application to subscribe to a list of CUCM contacts and either receive an HTTP notification when any changes occur, or poll periodically for any changes: https://developer.cisco.com/site/im-and-presence/

You should be able to build a service that subscribes to presence for all desired individuals, and then either polls-for or receives event notifications of updates, and write that to a database for querying...