Identify all the device hardware manufacturers listed in the database

This query provides a list of all device manufacturers held in the topology database.

The query uses the mappings table. This table provides lookups for alternative textual names. These lookups provide more human-readable text for fields. You can perform lookups in the mappings table for the types of information (or mapping groups) shown in the following table.

Table 1. Mapping groups supported by the mappings table
Type of information	String provided for lookup	Human-readable output of lookup
MAC vendors	MAC address suffix information	Name of equipment vendor
Internet Assigned Number Authority (IANA) enterprise number	IANA enterprise number	Name of company with an enterprise section in the SNMP object MIB
entPhysicalVendorType	MIB value for entPhysicalVendorType MIB variable	Vendor-specific hardware type of the physical entity
sysObjectId	MIB value for sysObjectId MIB variable	Vendor's authoritative identification of the network management subsystem contained in an entity

This query identifies the list of all device manufacturers held in the topology database by extracting a list of all mappings in the MACVendors mapping group in the mappings table.

The mappings table provides string-to-string mappings, whereas the enumerations table provides integer-to-string mappings.

Example

1]  SELECT    DISTINCT(mappingValue) Equipment_Vendor
2]  FROM      mappings m
3]  WHERE     mappingGroup = 'MACVendors'
4]  ORDER BY  mappingValue;

Description

The following table describes this query.

Table 2. Description of the query
Line numbers	Description
1	Display the name of the equipment vendor. This is represented by `DISTINCT(mappingValue)`. Ensure that each name is listed only once by using the `DISTINCT` keyword.
2	Use the `mappings` table as the driving table for this query. This enables the query to extract all the mapping data in the database.
3	Limit the mappings to those that form part of the `MACVendors` mapping group.
4	Order the results by the name of the equipment vendor.

Results

The following table shows an example of the results of this query.

Table 3. Results of the query
Equipment vendor
360 Systems
3COM
3e Technologies International Inc.
A-TREND TECHNOLOGY CO., LTD.
Abatron AG
ABB Automation Technology Products AB, Control
Abbey Systems Ltd
ABIT CORPORATION
AboveCable, Inc.
AbsoluteValue Systems, Inc.
AC Tech corporation DBA Advanced Digital
AC&T SYSTEM CO., LTD.
ACACIA NETWORKS, INC.