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
Solved! Go to Solution.
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
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 !
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
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
04-12-2017 11:58 AM
I have also wondered if there is a way to set the logout time.
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.
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
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
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 !
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
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
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
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
07-02-2013 09:16 AM
Alright thank you
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide