I have a request to get a list of user names, extensions & corresponding pickup groups from 20 different hunt groups. As each of these hunt groups has a minimum of 10 users per group it is going to take a very long time going into each group and individually clicking on the extension number & copying and pasting names/pickups etc.........does anyone know a quicker way to extract these details from CUCM 7.13?
From the CLI (use SSH, e.g. Putty) log in and run this command:
run sql select lg.name as LGName, n.dnorpattern, n.description, pg.name as PickupName from linegroup lg join linegroupnumplanmap lgnp on lgnp.fklinegroup = lg.pkid join numplan n on lgnp.fknumplan = n.pkid left join pickupgrouplinemap pglm on n.pkid = pglm.fknumplan_line left join pickupgroup pg on pglm.fkpickupgroup = pg.pkid
Get your SSH client to log to text, and you can then open the resultant text file using Excel as a text/tabbed data file to read the output of the query.
It lists all line groups, their members, and their members Pickup groups.
You'll need to link those back to Hunt Pilots, as each pilot could reference multiple hunt groups... this query should give you 90% of what you need though.
Please rate helpful posts....