Newbie Device Status Problem

Version 1
    This document was generated from CDN thread

    Created by: Steven Alsop on 03-12-2010 01:28:00 PM
    I need to get a Cisco Call Manager system to logout all extension mobility.
    So I've done a listDeviceByNameAndClass to get all the devices on the system.
    Then issued a doDeviceLogout to each device.
    This logs all the devices out fine.
    However we have changed the phone system so when users login it retains their last login name.
    When my script runs it works exactly as we want if the device is not logged out but if they are logged in then my script seems to remove the memory of the last active user. So I was going to change this to query all the devices that are currently logged into extension mobility but I don't know how to do this.
    Does anyone have a query that will do this? Also how do you write these queries as I can't find any details on the SQL database layout?
    Any help would be greatly appreciated.
    Thanks, Steve

    Subject: Re: New Message from Steven Alsop in Administration XML (AXL) - Administrat
    Replied by: Johannes Krohn on 03-12-2010 02:19:49 PM
    The Communications Manager database definition can be found in the data

    You should start looking at tables ³device² and ³extensionmobilitydynamic².