I am looking for a generic Vision diagram of a DNS structure.
Something that I can modify as an overview of the DNS structure at my
office. This is to show to management.
One way is to use the Visio organization chart wizard. It can take its
input from an Excel file.
In Excel, put the DNS names in column A; for example,
-------------
Name
aa.ccc.com
bb.ccc.com
ttt.ccc.com
tuygh.ccc.com
yui.ccc.com
ccc.com
www.ttt.com
www.rrr.com
ccc.sss.com
ttt.com
rrr.com
sss.com
com
-------------
Notice that all the names in the whole tree are there. Notice too that A2
is blank.
In B1, put "Reports_to" (without the quotes).
In B3, put
=IF(ISERROR(FIND(".",A3)),"",RIGHT(A3,LEN(A3)-FIND(".",A3)))
and copy down for as many rows as you need.
Save and close the Excel file.
In Visio, use
Tools >> Macros >> Org'n chart >> Org'n chart wizard
and follow the instructions.
(I have Visio 2002.)
