topic Re: Finding Ports on a VG gateway using SQL in Management

Finding Ports on a VG gateway using SQL

stephan.steiner — Wed, 17 Dec 2014 15:15:38 GMT

I'm pulling my hair out here.. I have a VG310 in my CUCM. However, I cannot seem to find the corresponding device in the CUCM database. I figure the device table would be the most promising, with tkclass = 2 (as it's an MGCP Gateway), but it contains my configured ports on the analog card, but not the gateway itself. I guess I could parse the name string and the part after the @ is the gateway name, but I'd really like to know how to list the gateways (I then expect to use that information to list ports per gateway).

I can find the analog ports just fine (analogaccess table), they link to a device again, but no link back as to which module and gateway they are from.

Does anybody know where those VG gateways are stored in the database?

Thanks

Re: Finding Ports on a VG gateway using SQL

npetrele — Wed, 17 Dec 2014 17:51:58 GMT

The VGs are stored in the device table. However, they're not stored by the obvious name, so it's easy to think they're not stored in that table.

There's probably an easier way to do this, but here's how I determine the name. Do a Device->Gateway and then Find. Select your gateway and then click "Apply Config". Here's a sample of what you'll see (below). There's the device name, right there - in this case, AN0506070809FFF. So you can find it in the device table with select * from device where name="AN0506070809FFF"; Then, if needed, you can use the pkid (or other IDs) to find related information in other tables.

Re: Finding Ports on a VG gateway using SQL

stephan.steiner — Wed, 17 Dec 2014 18:02:34 GMT

Umm... if I do that, it looks like this. And I suspect if you do a select * from device where name = 'AN...' you'll see something. The gateway should be listed with the product type and model in the db.. if I search by those properties, I should see an entry.. but tthere's nothing and that really has me confused.

Re: Finding Ports on a VG gateway using SQL

npetrele — Wed, 17 Dec 2014 18:27:35 GMT

Ah, okay, so it doesn't work for a VG310. It worked for a VG224. Ok, I'm looking into it, and I'll get back to you asap.

Re: Finding Ports on a VG gateway using SQL

npetrele — Wed, 17 Dec 2014 18:54:20 GMT

Do a select * from mgcp. You'll see your gateway and its pkid there. You can find out more information from mgcpslotconfig, where mgcpslotconfig.fkmgcp=mgcp.pkid.

Re: Finding Ports on a VG gateway using SQL

stephan.steiner — Thu, 18 Dec 2014 09:06:01 GMT

Yup, that works. And for those wondering how to get further.. the table mgcpdevicemember links the gateway (found in mgcp table) to the device (the actual ports of the vg). So I finally have the full picture.