How to export DNs from CME into a file?Hi

Administration
1

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,
Koki :)>

2

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

Wyn

1 Like
3

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

[tr][td][/td][td]
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
[/td][/tr]

I hope it helps:)