Browse by Tags

OCS SQL Query - Show last OCS logon

I wrote this one a while back to help someone on the forums. select res.UserAtHost as "SIP Address", hud.LastNewRegisterTime as "Last Logon" from rtcdyn.dbo.HomedUserDynamic hud join (Select ResourceId, UserAtHost from rtc.dbo.Resource...

Published Wed, Nov 11 2008 12:00 PM by Mike Stacy

Filed under: OCS, SQL, users, query

OCS SQL Query - Return Archive User Settings

From time to time I'll be posting SQL queries that I use for various reasons. I don't claim to be a SQL query expert and so I won't guarantee that these are written with the best syntax or performance characteristics. This query will list...

Published Wed, Nov 11 2008 11:52 AM by Mike Stacy

Filed under: OCS, SQL, query, archive

SQL Query to return number of users per Front End

In the last couple weeks myself and some other folks I've spoken with have had the need to know how many users were connected to a particular front end. Unfortunately there's no interface to provide this sort of information, so I decided to poke...

Published Fri, Aug 08 2008 10:37 AM by Mike Stacy

Filed under: OCS, pool, database, SQL, users

Filtering Contacts from the Address Book

Last night I was working with my friend and fellow UC architect, Peter Pawlak, on a customer design item. This particular customer is a subsidiary of a larger organization. The subsidiary is deploying OCS but the parent company is not. Not a problem since...

Published Thu, Jun 06 2008 9:04 AM by Mike Stacy

Filed under: OCS, SQL, ABS, address book

Syndication

Recent Posts

Tags

Archives

OCS SQL Query - Show last OCS logon

OCS SQL Query - Return Archive User Settings

SQL Query to return number of users per Front End

Filtering Contacts from the Address Book