Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

Extract Hunt group User Details

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super Bronze

Re: Extract Hunt group User Details

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....

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
3 REPLIES
Super Bronze

Re: Extract Hunt group User Details

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....

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
Community Member

Re: Extract Hunt group User Details

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

 

Many many many many thanks

Russell

Super Bronze

Re: Extract Hunt group User Details

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

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
208
Views
0
Helpful
3
Replies
CreatePlease to create content