Buy or Renew
Buy or Renew
Cisco + Splunk: It’s a new day for your data. Learn more.
 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
19058
Views
20
Helpful
12
Replies

Extension Mobility: Automatic logout

Go to solution
Muhammad Irfan
Level 1
Level 1

‎01-27-2011 02:02 AM - edited ‎03-19-2019 02:18 AM

Dear Team,

Hi Team,

Our customer requirement is that user should log out at 4:00PM even they are login at any time. Can we achieve this. I know we set the maximum login time but we can not schedule.

Is there any way, by XML application etc. Kindly advise.

BR

Muhammad Irfan

Labels:
0 Helpful
2 Accepted Solutions

Accepted Solutions

Go to solution
Jaime Valencia
Cisco Employee
Cisco Employee

‎01-27-2011 07:07 AM

You would need to create your very own service for that.

You'd need to somehow pool which phones are currently logged in and then send the logout request on their behalf using the device name.

HTH

java

If this helps, please rate

www.cisco.com/go/pdihelpdesk

HTH

java

if this helps, please rate

View solution in original post

Go to solution
srsivara
Cisco Employee
Cisco Employee
In response to Muhammad Irfan

‎01-31-2011 05:21 PM

The 'extensionmobilitydynamic' table is used to store the information of users logged into extension mobility.


You can do a 'run sql select * from extensionmobilitydynamic' from SSH of a CUCM server to find out the column names and values when a user logs into EM.


Here's a customized query that I came up with (modified from existing CUCM admin sql query), to show a few parameters that I wanted to look at, for EM users :


run sql SELECT device.name AS Devicename, typemodel.name as Model,
enduser.userid AS EndUser, numplan.dNOrPattern as DirectoryNumber,
routepartition.name AS Partition, D2.name AS DeviceProfile FROM
extensionmobilitydynamic LEFT OUTER JOIN device ON
extensionmobilitydynamic.fkdevice = device.pkid  LEFT OUTER JOIN typemodel
ON typemodel.enum = device.tkmodel LEFT OUTER JOIN enduser ON
extensionmobilitydynamic.fkenduser = enduser.pkid LEFT OUTER JOIN Device AS
D2 ON D2.pkid = extensionmobilitydynamic.fkdevice_currentloginprofile  LEFT
OUTER JOIN DeviceNumPlanMap ON DeviceNumPlanMap.fkdevice =
extensionmobilitydynamic.fkdevice_currentloginprofile LEFT OUTER JOIN
NumPlan ON DeviceNumPlanMap.fkNumPlan = numplan.pkid LEFT OUTER JOIN
RoutePartition ON numplan.fkRoutePartition = routepartition.pkid WHERE
((D2.name IS NOT NULL AND D2.name!='') AND (enduser.userid IS NOT NULL AND
enduser.userid!='')) order by D2.name

Example :

admin:run sql SELECT device.name AS Devicename, typemodel.name as Model,
enduser.userid AS EndUser, numplan.dNOrPattern as DirectoryNumber,
routepartition.name AS Partition, D2.name AS DeviceProfile FROM
extensionmobilitydynamic LEFT OUTER JOIN device ON
extensionmobilitydynamic.fkdevice = device.pkid  LEFT OUTER JOIN typemodel
ON typemodel.enum = device.tkmodel LEFT OUTER JOIN enduser ON
extensionmobilitydynamic.fkenduser = enduser.pkid LEFT OUTER JOIN Device AS
D2 ON D2.pkid = extensionmobilitydynamic.fkdevice_currentloginprofile  LEFT
OUTER JOIN DeviceNumPlanMap ON DeviceNumPlanMap.fkdevice =
extensionmobilitydynamic.fkdevice_currentloginprofile LEFT OUTER JOIN
NumPlan ON DeviceNumPlanMap.fkNumPlan = numplan.pkid LEFT OUTER JOIN
RoutePartition ON numplan.fkRoutePartition = routepartition.pkid WHERE
((D2.name IS NOT NULL AND D2.name!='') AND (enduser.userid IS NOT NULL AND
enduser.userid!='')) order by D2.name

devicename      model      enduser directorynumber partition deviceprofile

=============== ========== ======= =============== =========
========================
SEP000D284CD86B Cisco 7960 em1     1020            phones    Extension
Mobility - EM1
SEP000D284CD86B Cisco 7960 em1     1000            phones    Extension
Mobility - EM1
admin:

----

I am not aware of a 3rd party software which can do bulk EM logouts at a particular time of the day. However, here's my 2 cents :
- sql query run on the CUCM database to find out the devices logged into EM (probably a script that can run it at a specified time of the day - not sure 
how or if it can be implemented)
- from the sql output, send customized http requests to the EM server, to log these phones off EM

- Sriram

Please rate helpful posts !

View solution in original post

12 Replies 12

Go to solution
sshresth
Level 1
Level 1

‎01-27-2011 04:42 AM

Hi Muhammad,

You can Set Enforce Maximum Login time to true under Service Parameter and configure the time so that EM automatically logs out after that time. For more info refer to this admin guide:

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/admin/7_0_1/ccmfeat/fsem.html#wp1178338

Hope this helps.

Thank you

Sarojani Shrestha

Cisco

Sent from Cisco Technical Support iPhone App

0 Helpful

Go to solution
Muhammad Irfan
Level 1
Level 1
In response to sshresth

‎01-30-2011 04:24 AM

Hi Sarojani,

I know we can set maximum force time that is in hours but I want to set the log out time. No matters at what time user log in but user should log out at 4:00PM.

BR

0 Helpful

Go to solution
jtong2003
Level 1
Level 1
In response to Muhammad Irfan

‎04-12-2017 11:58 AM

I have also wondered if there is a way to set the logout time.

Go to solution
Jaime Valencia
Cisco Employee
Cisco Employee
In response to jtong2003

‎04-12-2017 12:14 PM

CUCM provides no way to logout EM profiles at a specific time, as discussed in the thread, this requires some custom development to achieve.

HTH

java

if this helps, please rate

Go to solution
Jaime Valencia
Cisco Employee
Cisco Employee

‎01-27-2011 07:07 AM

You would need to create your very own service for that.

You'd need to somehow pool which phones are currently logged in and then send the logout request on their behalf using the device name.

HTH

java

If this helps, please rate

www.cisco.com/go/pdihelpdesk

HTH

java

if this helps, please rate

Go to solution
Muhammad Irfan
Level 1
Level 1
In response to Jaime Valencia

‎01-30-2011 04:28 AM

Hi,

But how that is the question. Might be this is possible with some XML application but is there any reference or document available? I appreciate if you can pass me any link or document regarding this. If there is any third part tool which can do this, please let me know.

Irfan

0 Helpful

Go to solution
srsivara
Cisco Employee
Cisco Employee
In response to Muhammad Irfan

‎01-31-2011 05:21 PM

The 'extensionmobilitydynamic' table is used to store the information of users logged into extension mobility.


You can do a 'run sql select * from extensionmobilitydynamic' from SSH of a CUCM server to find out the column names and values when a user logs into EM.


Here's a customized query that I came up with (modified from existing CUCM admin sql query), to show a few parameters that I wanted to look at, for EM users :


run sql SELECT device.name AS Devicename, typemodel.name as Model,
enduser.userid AS EndUser, numplan.dNOrPattern as DirectoryNumber,
routepartition.name AS Partition, D2.name AS DeviceProfile FROM
extensionmobilitydynamic LEFT OUTER JOIN device ON
extensionmobilitydynamic.fkdevice = device.pkid  LEFT OUTER JOIN typemodel
ON typemodel.enum = device.tkmodel LEFT OUTER JOIN enduser ON
extensionmobilitydynamic.fkenduser = enduser.pkid LEFT OUTER JOIN Device AS
D2 ON D2.pkid = extensionmobilitydynamic.fkdevice_currentloginprofile  LEFT
OUTER JOIN DeviceNumPlanMap ON DeviceNumPlanMap.fkdevice =
extensionmobilitydynamic.fkdevice_currentloginprofile LEFT OUTER JOIN
NumPlan ON DeviceNumPlanMap.fkNumPlan = numplan.pkid LEFT OUTER JOIN
RoutePartition ON numplan.fkRoutePartition = routepartition.pkid WHERE
((D2.name IS NOT NULL AND D2.name!='') AND (enduser.userid IS NOT NULL AND
enduser.userid!='')) order by D2.name

Example :

admin:run sql SELECT device.name AS Devicename, typemodel.name as Model,
enduser.userid AS EndUser, numplan.dNOrPattern as DirectoryNumber,
routepartition.name AS Partition, D2.name AS DeviceProfile FROM
extensionmobilitydynamic LEFT OUTER JOIN device ON
extensionmobilitydynamic.fkdevice = device.pkid  LEFT OUTER JOIN typemodel
ON typemodel.enum = device.tkmodel LEFT OUTER JOIN enduser ON
extensionmobilitydynamic.fkenduser = enduser.pkid LEFT OUTER JOIN Device AS
D2 ON D2.pkid = extensionmobilitydynamic.fkdevice_currentloginprofile  LEFT
OUTER JOIN DeviceNumPlanMap ON DeviceNumPlanMap.fkdevice =
extensionmobilitydynamic.fkdevice_currentloginprofile LEFT OUTER JOIN
NumPlan ON DeviceNumPlanMap.fkNumPlan = numplan.pkid LEFT OUTER JOIN
RoutePartition ON numplan.fkRoutePartition = routepartition.pkid WHERE
((D2.name IS NOT NULL AND D2.name!='') AND (enduser.userid IS NOT NULL AND
enduser.userid!='')) order by D2.name

devicename      model      enduser directorynumber partition deviceprofile

=============== ========== ======= =============== =========
========================
SEP000D284CD86B Cisco 7960 em1     1020            phones    Extension
Mobility - EM1
SEP000D284CD86B Cisco 7960 em1     1000            phones    Extension
Mobility - EM1
admin:

----

I am not aware of a 3rd party software which can do bulk EM logouts at a particular time of the day. However, here's my 2 cents :
- sql query run on the CUCM database to find out the devices logged into EM (probably a script that can run it at a specified time of the day - not sure 
how or if it can be implemented)
- from the sql output, send customized http requests to the EM server, to log these phones off EM

- Sriram

Please rate helpful posts !

Go to solution
laithabbas0
Level 1
Level 1
In response to srsivara

‎07-02-2013 08:34 AM

Hi Srsivara

Can you please elaborate more on what you said to send the server "

 customized http requests to the EM server, to log these phones off EM

"

if you can provide me with one xample of those request that'll be awesome, I am tryin gto make a webpage and one of the features is to logout of EM which I can't find how to do since I can't delete from extension moiblity dynamic.


Thanks

0 Helpful

Go to solution
srsivara
Cisco Employee
Cisco Employee
In response to laithabbas0

‎07-02-2013 08:40 AM

Hi Laith,

For example, GAT (Generic AXL Tool), a Cisco Advanced Services (AS) tool, is something that could be used to customize log out of EM users. GAT can be bought with an AS contract. Please reach out to Murali Tupuri (mtupuri@cisco.com) for further information and details regarding purchasing/using this tool.

Thanks
Sriram

0 Helpful

Go to solution
laithabbas0
Level 1
Level 1
In response to srsivara

‎07-02-2013 08:54 AM

I am not sure why you are soliciting an unofficial product on Cisco support forum. I am just tryin gto send the server a command to log out of EM, not to buy a software that'll do it for me

0 Helpful

Go to solution
srsivara
Cisco Employee
Cisco Employee
In response to laithabbas0

‎07-02-2013 09:01 AM

Hi Laith,

Let me clarify. GAT is the example I have seen used. I haven't personally come across a customized HTTP query to log out EM users, but could probably be developed. My original post was to provide an overview of what could potentially work in this scenario - unfortunately, I don't have a customized query or example to showcase that.

Thanks

Sriram

0 Helpful

Go to solution
laithabbas0
Level 1
Level 1
In response to srsivara

‎07-02-2013 09:16 AM

Alright thank you

0 Helpful
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Customers Also Viewed These Support Documents