CUCM – Associating devices to a user

While working with a client recently, I was asked to create a new JTAPI application user and associate a little over 600 users to it. I couldn’t find a clean way to do this with BAT, so I decided to use SQL.

Follow these easy steps

  1. Learn the associations between the applicable fields. We needed to get a device linked to an application user in my case. CUCM Data Dictionary
  2. run some select statements to verify everything looks how you expect. I also make changes in the GUI, then check my selects again to ensure I know how CUCM expects data to look.
  3. Make your change
  4. Verify

Continue reading “CUCM – Associating devices to a user”

When you need a server to tackle tasks

Sometimes when you’re in a client environment, you just need something you don’t have access to. That could be NTP, DNS, gateways, an internal CA, or even just an SFTP server. I encounter this all the time and my solution is almost always to simply get an IP from the client and spin up a linux server.

I decided to make this a vLog entry rather than a blog, so please check out the videos. I would like to point out that the part2 video does have an error in the alt_names section for the IP address. DNS entries are prepended by DNS: but ip addresses are prepended by IP: In my video, I prepended the IP with DNS: this will not work.

Continue reading “When you need a server to tackle tasks”

Bulk changing incorrect css for unassigned DNs

Today I was cleaning up some CSSs for a client. I came across a particular css that had been erroneously assigned as the line css for a bunch of unassigned DNs (they were precreated to show they were already in use). Of course, I went to BAT first to see if I could just update the line css of the lines, but I discovered that I couldn’t affect the unassigned DNs (even though there is an option for searching unassigned dns…)

Anyway, as you can guess, I jumped into SQL to see what I could do.

Continue reading “Bulk changing incorrect css for unassigned DNs”

Using SQL to clean up Call Manager pt3

See Parts 1 and 2

If you’ve been following me in this 3 part series, you know we started off with around 700 dependencies on a CSS that no longer fits our standard. It was in use by various things and we leveraged SQL to quickly, efficiently, and safely remove it from use. When we finished part 2, the only things still referencing our css were directory numbers. Well, we actually have 2 CSSs we’re going to clean up today.

As usual, we’ll begin with a count.
dependency records

dependency records Continue reading “Using SQL to clean up Call Manager pt3”