SQL Command (Count)

[jeremy.worden]

Hi,

Looking for some help with running an SQL command to count the number of trunks. This will return the count of most of the trunks:

run sql select count(tm.name) as Total from device as d inner join typemodel as tm on d.tkmodel = tm.enum where tm.name like '%Trunk%'

However I have a situation where I have multiple trunks with the same name but different Route Groups. This does not count the duplicates.

Basically looking for the cli equivalent of Device>Trunks

Thanks!

[Aaron Harrison · Accepted solution]

Hey

Count:

run sql select count(*)  from routegroupdevicemap join device d on fkdevice = d.pkid join routegroup rg on fkroutegroup = rg.pkid

Check:

run sql select rg.name,d.name from routegroupdevicemap join device d on fkdevice = d.pkid join routegroup rg on fkroutegroup = rg.pkid

Regards

Aaron

[jeremy.worden]

Aaron, 

thanks for looking at this for me! so this is getting closer. now i seem to be missing trunks that dont have a route group assign (NULL). I have the same scenerio when trying to count CTI route points.

Thanks!

Jeremy