Site Archives

How to retrieve presence status for all office communicator users using a SQL query


To retrieve the presence status for all the office communicator users in your environment open the SQL instance hosting the OCS database and create a query using the data below. Keep in mind that in your enviroment the presence values might be different and also the ContainerNum. I’ve added at the end the availability ranges [...]