CM Reporting

Answered Question
Jan 20th, 2010
User Badges:

Morning, Is there any way to report on which phones have Mobility ena

bled in CM 7? I have 3 users with mobility enabled who are not associtaed to phones, they are taking up 4 DLU's when they should only take 2 while associated with a phone. Since we have thousands of users, searching will be difficult.


Thanks


Liam

Correct Answer by Michael Owuor about 7 years 5 months ago

Hi Liam,


To find out all users who have mobility enabled, run the following from the SSH command line on the Pub:


run sql SELECT userId, enableMobility FROM EndUser WHERE enableMobility = 't'


Hope this helps.


Regards,
Michael.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 4 (2 ratings)
Loading.
Jaime Valencia Wed, 01/20/2010 - 06:47
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    2011

No native reporting for that, you would need to go thru the database dictionary to find which field determines this and then run qrys to the informix DB.


HTH


java


If this helps, please rate


www.cisco.com/go/pdihelpdesk

Correct Answer
Michael Owuor Wed, 01/20/2010 - 07:12
User Badges:
  • Cisco Employee,

Hi Liam,


To find out all users who have mobility enabled, run the following from the SSH command line on the Pub:


run sql SELECT userId, enableMobility FROM EndUser WHERE enableMobility = 't'


Hope this helps.


Regards,
Michael.

walshliam Wed, 01/20/2010 - 07:44
User Badges:

Thank you both for the info. Michael, the sql query command worked great! thanks so much.


Liam

Actions

This Discussion