Extract Hunt group User Details

[rchaseling]

Hi,

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?

Cheers

[Aaron Harrison · Accepted solution]

Hi

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.

Regards

Aaron

Please rate helpful posts....

[rchaseling]

Perfect!!!!!! Big 5+!!!!!

Many many many many thanks

Russell

[Aaron Harrison]

run sql select lg.name as LGName, n.dnorpattern, n.alertingname, 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

That will give you alertingname; the other fields you requested would include links to a couple of other tables so I'd have to test it later it you really need it? It's common for alertingname to be the same as Display, and Line Label to be less useful... so I'm guessing alerting will be all you really need?

Aaron