Visio5: How to Export Information from the AutoDiscovery Database to a Text File (254739)

MORE INFORMATION

The DBEXPORT utility is an MS-DOS-based program that creates a tab-delimited text file. This file contains the field data in the AutoDiscovery database. You can find the DBEXPORT utility in the Visio\Solutions\Network diagram\_bin folder. Microsoft recommends you leave the utility in this location.

NOTE: The following procedure assumes that:

• You have generated a network database by using the Basic Discovery or Advanced Discovery Wizard and have it open in Visio Enterprise.
• You are familiar with AutoDiscovery and Layout terminology. For more information, click AutoDiscovery and Layout Help on the AutoDiscovery menu, and then type getting started on the Index tab.
• You are familiar with navigating through MS-DOS.

To run the DBEXPORT utility:

1. At an MS-DOS command prompt, navigate to the \Solutions\Network diagram\_bin folder.
2. Type dbexport filename.txt, where filename.txt is a file name of your choice.
3. Press ENTER to generate the text file.
   
   The output is sent to the file that you specify.

For additional syntax information, open the Dbexport.txt file, located in the Solutions\Network Diagram\_bin\ folder.

DBEXPORT Text File Syntax

When you run the DBEXPORT utility, it creates a text file, delimited with tab characters. Any nonprinting characters embedded in the descriptive files of the database are converted to a space.

There are two types of database records, Device and Interface, and they are both formatted the same. There is one Device record per device. The AutoDiscovery database creates a record based on the device's name and object ID (sysObjectID). If there are multiple IP addresses or DLCIs assigned to an interface, multiple interface records may exist in the database. If this is the case, the database creates an Interface index. All records contain Device Class, Device Name, and Device SysObjectID fields. All fields in a record will be filled if data is available (except devDesc).

Field Description

This table contains the field data in the AutoDiscovery database.

Field	Name	Description
1	Device Class	Device Class name obtained from database
2	Device Name Device	Name from sysName
3	Device Title	Device title from database
4	Device SysObjID Device	Object ID from sysObjectID
5	Device System Description	Device description from sysDesc
6	Device Community String	Community string used to access device
7	Interface #	Interface index from sysIndex
8	Interface Title	Interface title from database
9	IP Address	Interface IP address from ifIPAddress
10	IP Title	IP title from database
11	Subnet Mask	Interface IP mask
12	MAC Address	Interface MAC ifPhysAddress
13	Media Type	Interface type from ifType
14	Speed of Port	Interface speed from ifSpeed
15	Interface Name	Interface name from ifName
16	Interface Description	Interface description from ifDesc
17	DLCI	Interface Frame Relay Data Link Connection Identifier
18	DLCI Title	DLCI title from database
19	CIR DLCI	Committed Information Rate

NOTE: All Field names ending in "Title" are fields that you can modify in the Visio AutoDiscovery and Layout template.