{"id":117,"date":"2013-12-11T07:41:03","date_gmt":"2013-12-11T14:41:03","guid":{"rendered":"https:\/\/www.rackbuzz.com\/?p=117"},"modified":"2014-04-23T18:11:43","modified_gmt":"2014-04-24T01:11:43","slug":"cisco-sql-query-who-can-make-long-distance-calls","status":"publish","type":"post","link":"https:\/\/www.rackbuzz.com\/?p=117","title":{"rendered":"Cisco SQL Query &#8211; Who can make long distance calls?"},"content":{"rendered":"<p>We restrict who gets access to make long distance calls to save money. As a result, when we designed our CUCM environment, we created separate Calling Search Spaces (CSS hereafter) for local, long distance, and international calling.<\/p>\n<p>Occasionally I&#8217;ll be asked to produce a list of the people who currently have access to make long distance calls. Since we have conventionalized the LD CSS names by building (using XX_LD_CSS where XX is the building code) I was able to do this in one line:<\/p>\n<pre>run sql select name, dnorpattern, alertingname from numplan n, callingsearchspace c where n.fkcallingsearchspace_sharedlineappear = c.pkid and c.name like '___LD_CSS'<\/pre>\n<p>While underscores exist in the CSS names, the first two are used as wildcards in the query. This could also be done for a specific CSS with the following:<\/p>\n<pre>run sql select name,dnorpattern, alertingname from numplan n, callingsearchspace c where n.fkcallingsearchspace_sharedlineappear = c.pkid and c.name = 'XX_LD_CSS'<\/pre>\n<pre><\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We restrict who gets access to make long distance calls to save money. As a result, when we designed our CUCM environment, we created separate Calling Search Spaces (CSS hereafter) for local, long distance, and international calling. Occasionally I&#8217;ll be asked to produce a list of the people who currently have access to make long [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-117","post","type-post","status-publish","format-standard","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/www.rackbuzz.com\/index.php?rest_route=\/wp\/v2\/posts\/117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackbuzz.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rackbuzz.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackbuzz.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackbuzz.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=117"}],"version-history":[{"count":2,"href":"https:\/\/www.rackbuzz.com\/index.php?rest_route=\/wp\/v2\/posts\/117\/revisions"}],"predecessor-version":[{"id":119,"href":"https:\/\/www.rackbuzz.com\/index.php?rest_route=\/wp\/v2\/posts\/117\/revisions\/119"}],"wp:attachment":[{"href":"https:\/\/www.rackbuzz.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackbuzz.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackbuzz.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}