Showing posts with label CUCM SQL. Show all posts
Showing posts with label CUCM SQL. Show all posts

Sunday, 14 October 2012

CUCM SQL Query for Users set to reset passwords

The following query run from the SSH CLI will give you a list of users whose accounts are set to enforce a password change:

run sql ccm select u.userid, c.credmustchange from enduser as u inner join credential as c on c.fkenduser = u.pkid where tkcredential = 3 and c.credmustchange = 't'