Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Koki on May 01, 2007, 09:30:21 AM

Title: How to export DNs from CME into a file?Hi
Post by: Koki on May 01, 2007, 09:30:21 AM

Hi,

I have a quick question on how to export data from Swtich->DN folder of Configuration Manager into a file. We have thousands of DNs separated into sub-folders, and I need to print out content of one of those sub-folders. How can I do it?

Thank you veyr much,
[move][glow=green,20,1000]Koki :)>[/glow][/move]

Title: Re: How to export DNs from CME into a file?Hi
Post by: Adam G. on May 01, 2007, 09:42:07 AM

How about writing a quick Hyperion report from the config DB?

Pavel

Title: Re: How to export DNs from CME into a file?Hi
Post by: victor on May 02, 2007, 10:32:35 AM

Here is a basic SQL script that will do that fo you:


[table][tr][td][/td][td]
[size=8pt]SELECT    cfg_dn.number_, cfg_dn.name, cfg_switch.name AS Switch, cfg_locale.lc_value, ISNULL(cfg_folder.name, 'Root Dns') AS Folder_Name
FROM        cfg_dn INNER JOIN
                      cfg_locale ON cfg_dn.type = cfg_locale.lc_subtype LEFT OUTER JOIN
                      cfg_switch ON cfg_dn.tenant_dbid = cfg_switch.tenant_dbid LEFT OUTER JOIN
                      cfg_obj_folder ON cfg_dn.dbid = cfg_obj_folder.object_dbid LEFT OUTER JOIN
                      cfg_folder ON cfg_obj_folder.folder_dbid = cfg_folder.dbid
WHERE    (cfg_locale.lc_type = 5)
GROUP BY cfg_obj_folder.folder_dbid, cfg_locale.lc_value, cfg_dn.name, cfg_dn.number_, cfg_switch.name, cfg_folder.name[/size]
[/td][/tr][/table]

I hope it helps:)