Diferencias

Muestra las diferencias entre dos versiones de la página.

--- redes:telefonia:cisco:call_manager [2017/02/14 19:47] – [Scripts para importar LOGS de Cisco Call Manager en Mysql o PostgreSQL] cayu
+++ redes:telefonia:cisco:call_manager [2017/02/14 19:47] – [SQL] cayu
@@ Línea 9: / Línea 9: @@
 Listas Nombre de telefono, Descripcion, DN
 <code sql>
-run sql select d.name, d.description, n.dnorpattern as DN from device as d,numplan as n, devicenumplanmap as dnpm where dnpm.fkdevice = d.pkid and dnpm.fknumplan = n.pkid and d.tkclass = 1
+run sql select d.name, d.description, n.dnorpattern as DN
+from device as d,numplan as n, devicenumplanmap as dnpm
+where dnpm.fkdevice = d.pkid and dnpm.fknumplan = n.pkid and d.tkclass = 1
 </code>