Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/254739

From BetaArchive Wiki

Article ID: 254739

Article Last Modified on 11/10/2000



APPLIES TO

  • Visio 5.0 Enterprise



This article was previously published under Q254739

SUMMARY

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.

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.

Keywords: kbhowto KB254739