Microsoft KB Archive/254739
Article ID: 254739
Article Last Modified on 11/10/2000
- Visio 5.0 Enterprise
This article was previously published under Q254739
When you use the AutoDiscovery feature to discover a network, Visio Enterprise creates an internal database to store information. In order to export the database information for use in other applications or to generate a report, you can use the DBEXPORT utility that is included with Visio Enterprise. This article shows you how to do so.
NOTE: The AutoDiscovery feature is available only when the AutoDiscovery and Layout template is open in Visio Enterprise.
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:
- At an MS-DOS command prompt, navigate to the \Solutions\Network diagram\_bin folder.
- Type dbexport filename.txt, where filename.txt is a file name of your choice.
- 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).
This table contains the field data in the AutoDiscovery database.
|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.
Keywords: kbhowto KB254739