{"id":83,"date":"2016-10-13T14:14:06","date_gmt":"2016-10-13T06:14:06","guid":{"rendered":"https:\/\/www.theinsecurewire.com\/?p=83"},"modified":"2016-10-13T14:14:06","modified_gmt":"2016-10-13T06:14:06","slug":"cucm-report-call-forwards-sql","status":"publish","type":"post","link":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/","title":{"rendered":"CUCM – Report on all Call Forwards with SQL"},"content":{"rendered":"

Recently I had the task of integrating two separate CUCM clusters together. One of the tasks I had was to work out how many users had call forwards set on their directory numbers so we could either keep or remove them. Call forwards can cause a monetary or management issue if not looked after correctly. Specifically we didn’t want call forwards to a main campus number to be translated to a contact center queue.\"download\"<\/a><\/p>\n

A simple way to achieve this was to run an SQL query on your CUCM Publisher via SSH.<\/p>\n

From the CLI;
\n
\nadmin:run sql select dnorpattern,cfadestination,cfavoicemailenabled from CallForwardDynamic c, numplan n where c.fknumplan = n.pkid and (cfadestination != '' or cfavoicemailenabled ='t')
\n<\/code><\/p>\n

This SQL statement returns all the directory numbers that have call forwards to an extension or PSTN number or voicemail. Extensions or PSTN are denoted with an ‘f’. Voicemail forward is denoted with a ‘t’. You can copy the output into Excel for easy manipulation.<\/p>\n

Pretty simple really but handy to know.<\/p>\n","protected":false},"excerpt":{"rendered":"

Recently I had the task of integrating two separate CUCM clusters together. One of the tasks I had was to work out how many users…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,18],"tags":[],"class_list":["post-83","post","type-post","status-publish","format-standard","hentry","category-scripting","category-voip"],"acf":[],"yoast_head":"\nCUCM - Report on all Call Forwards with SQL - Insecure Wire<\/title>\n<meta name=\"description\" content=\"CUCM - Using SQL from CLI to report on all Call Forwards applied to users directory numbers from a call manager cluster node.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CUCM - Report on all Call Forwards with SQL - Insecure Wire\" \/>\n<meta property=\"og:description\" content=\"CUCM - Using SQL from CLI to report on all Call Forwards applied to users directory numbers from a call manager cluster node.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Insecure Wire\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-13T06:14:06+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/178.128.55.110\/wp-content\/uploads\/2016\/10\/download.png\" \/>\n<meta name=\"author\" content=\"nikonau\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/insecurewire\" \/>\n<meta name=\"twitter:site\" content=\"@insecurewire\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"nikonau\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/\"},\"author\":{\"name\":\"nikonau\",\"@id\":\"https:\/\/www.insecurewi.re\/#\/schema\/person\/8ba08b41fc754b971a948ead6ccb777d\"},\"headline\":\"CUCM – Report on all Call Forwards with SQL\",\"datePublished\":\"2016-10-13T06:14:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/\"},\"wordCount\":157,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.insecurewi.re\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/178.128.55.110\/wp-content\/uploads\/2016\/10\/download.png\",\"articleSection\":[\"Scripting\",\"VOIP\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/\",\"url\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/\",\"name\":\"CUCM - Report on all Call Forwards with SQL - Insecure Wire\",\"isPartOf\":{\"@id\":\"https:\/\/www.insecurewi.re\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/178.128.55.110\/wp-content\/uploads\/2016\/10\/download.png\",\"datePublished\":\"2016-10-13T06:14:06+00:00\",\"description\":\"CUCM - Using SQL from CLI to report on all Call Forwards applied to users directory numbers from a call manager cluster node.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/#primaryimage\",\"url\":\"http:\/\/178.128.55.110\/wp-content\/uploads\/2016\/10\/download.png\",\"contentUrl\":\"http:\/\/178.128.55.110\/wp-content\/uploads\/2016\/10\/download.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.insecurewi.re\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CUCM – Report on all Call Forwards with SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.insecurewi.re\/#website\",\"url\":\"https:\/\/www.insecurewi.re\/\",\"name\":\"Insecure Wire\",\"description\":\"A Network Engineer\u2019s Perspective.\",\"publisher\":{\"@id\":\"https:\/\/www.insecurewi.re\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.insecurewi.re\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.insecurewi.re\/#organization\",\"name\":\"Insecure Wire\",\"url\":\"https:\/\/www.insecurewi.re\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.insecurewi.re\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.insecurewi.re\/wp-content\/uploads\/2023\/10\/cloud.png\",\"contentUrl\":\"https:\/\/www.insecurewi.re\/wp-content\/uploads\/2023\/10\/cloud.png\",\"width\":32,\"height\":32,\"caption\":\"Insecure Wire\"},\"image\":{\"@id\":\"https:\/\/www.insecurewi.re\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/insecurewire\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.insecurewi.re\/#\/schema\/person\/8ba08b41fc754b971a948ead6ccb777d\",\"name\":\"nikonau\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.insecurewi.re\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2d1b9d9dc90da4f6d3da31b870f418c6b3553ba9be48d53e8ee3a35b0adb1d35?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2d1b9d9dc90da4f6d3da31b870f418c6b3553ba9be48d53e8ee3a35b0adb1d35?s=96&d=mm&r=g\",\"caption\":\"nikonau\"},\"sameAs\":[\"https:\/\/x.com\/https:\/\/twitter.com\/insecurewire\"],\"url\":\"https:\/\/www.insecurewi.re\/index.php\/author\/nikon\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CUCM - Report on all Call Forwards with SQL - Insecure Wire","description":"CUCM - Using SQL from CLI to report on all Call Forwards applied to users directory numbers from a call manager cluster node.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/","og_locale":"en_US","og_type":"article","og_title":"CUCM - Report on all Call Forwards with SQL - Insecure Wire","og_description":"CUCM - Using SQL from CLI to report on all Call Forwards applied to users directory numbers from a call manager cluster node.","og_url":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/","og_site_name":"Insecure Wire","article_published_time":"2016-10-13T06:14:06+00:00","og_image":[{"url":"http:\/\/178.128.55.110\/wp-content\/uploads\/2016\/10\/download.png","type":"","width":"","height":""}],"author":"nikonau","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/insecurewire","twitter_site":"@insecurewire","twitter_misc":{"Written by":"nikonau","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/#article","isPartOf":{"@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/"},"author":{"name":"nikonau","@id":"https:\/\/www.insecurewi.re\/#\/schema\/person\/8ba08b41fc754b971a948ead6ccb777d"},"headline":"CUCM – Report on all Call Forwards with SQL","datePublished":"2016-10-13T06:14:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/"},"wordCount":157,"commentCount":0,"publisher":{"@id":"https:\/\/www.insecurewi.re\/#organization"},"image":{"@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/#primaryimage"},"thumbnailUrl":"http:\/\/178.128.55.110\/wp-content\/uploads\/2016\/10\/download.png","articleSection":["Scripting","VOIP"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/","url":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/","name":"CUCM - Report on all Call Forwards with SQL - Insecure Wire","isPartOf":{"@id":"https:\/\/www.insecurewi.re\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/#primaryimage"},"image":{"@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/#primaryimage"},"thumbnailUrl":"http:\/\/178.128.55.110\/wp-content\/uploads\/2016\/10\/download.png","datePublished":"2016-10-13T06:14:06+00:00","description":"CUCM - Using SQL from CLI to report on all Call Forwards applied to users directory numbers from a call manager cluster node.","breadcrumb":{"@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/#primaryimage","url":"http:\/\/178.128.55.110\/wp-content\/uploads\/2016\/10\/download.png","contentUrl":"http:\/\/178.128.55.110\/wp-content\/uploads\/2016\/10\/download.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/13\/cucm-report-call-forwards-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.insecurewi.re\/"},{"@type":"ListItem","position":2,"name":"CUCM – Report on all Call Forwards with SQL"}]},{"@type":"WebSite","@id":"https:\/\/www.insecurewi.re\/#website","url":"https:\/\/www.insecurewi.re\/","name":"Insecure Wire","description":"A Network Engineer\u2019s Perspective.","publisher":{"@id":"https:\/\/www.insecurewi.re\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.insecurewi.re\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.insecurewi.re\/#organization","name":"Insecure Wire","url":"https:\/\/www.insecurewi.re\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.insecurewi.re\/#\/schema\/logo\/image\/","url":"https:\/\/www.insecurewi.re\/wp-content\/uploads\/2023\/10\/cloud.png","contentUrl":"https:\/\/www.insecurewi.re\/wp-content\/uploads\/2023\/10\/cloud.png","width":32,"height":32,"caption":"Insecure Wire"},"image":{"@id":"https:\/\/www.insecurewi.re\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/insecurewire"]},{"@type":"Person","@id":"https:\/\/www.insecurewi.re\/#\/schema\/person\/8ba08b41fc754b971a948ead6ccb777d","name":"nikonau","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.insecurewi.re\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2d1b9d9dc90da4f6d3da31b870f418c6b3553ba9be48d53e8ee3a35b0adb1d35?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2d1b9d9dc90da4f6d3da31b870f418c6b3553ba9be48d53e8ee3a35b0adb1d35?s=96&d=mm&r=g","caption":"nikonau"},"sameAs":["https:\/\/x.com\/https:\/\/twitter.com\/insecurewire"],"url":"https:\/\/www.insecurewi.re\/index.php\/author\/nikon\/"}]}},"_links":{"self":[{"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/posts\/83","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/comments?post=83"}],"version-history":[{"count":0,"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/posts\/83\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/media?parent=83"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/categories?post=83"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/tags?post=83"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}