AANTS: The WiscnicSearch Tool

This document gives a general overview of the new WiscnicSearch.cgi tool for querying the MySQL version of the WiscNIC database.

WiscnicSearch.cgi WiscNIC was originally based on the whois protocol but is now in a SQL database, the format of WiscNIC text records is heavily inspired by whois.

Search Options

Autodetect

The default mode is to autodetect the type of data input, a VLAN record, an IPv4 or IPv6 Subnet, WiscNIC Handle or NetID based on the query input. All avaialble data will be returned in the result options

IP Address

IP Address records will be searched and only WiscNIC Subnet records will be displayed in the results

Regular Expressions

A regular expression search through the records, names, descriptions will be performed. By default all record types will be searched and all available data will be returned in the results.

Subnet

A search through WiscNIC Subnet records with immediate results as you type to select an individual record to query. By default associated Contacts, Routes, VLANs and of course Subnet records will be displayed in the results.

User Name

A search through WiscNIC Contact records based on a persons name with immediate results as you type to select an individual record to query. By default associated EdgeConf Devices, Subnets, VLANs and of course Contact records will be displayed in the results

NetID

A search through WiscNIC Contact records based on a persons NetID with immediate results as you type to select an individual record to query. By default associated EdgeConf Devices, Subnets, VLANs and of course Contact records will be displayed in the results

NIC Handle

A search through WiscNIC Contact records based on a persons WiscNIC Handle with immediate results as you type to select an individual record to query. By default associated EdgeConf Devices, Subnets, VLANs and of course Contact records will be displayed in the results

VLAN

A search through WiscNIC VLAN records with immediate results as you type to select an individual record to query. By default associated Bridge, Contacts, EdgeConf Devices, Routes, Subnets, VRFs and of course VLAN records will be displayed in the results.

VRF

A search through WiscNIC VRF records with immediate results as you type to select an individual record to query. By default associated Bridge, Contacts, EdgeConf Devices, Routes, Subnets, VLANs, and of course VRF records will be displayed in the results.

Modifers

Case Insensitive

Case insensitivity is selected by default and is relevant for some search types, toggle off if you want to enforce a case sensitive search

Strict

When querying WiscNIC Subnet records the default is to only query the exact record being searched for, but if strict is unchecked then the hierarchy of parent and child subnets are also queried and returned.

Search de-authed users

An optional parameter which will display contact information for disabled WiscNIC handles rather than active ones, to identify historical access or users which should be re-enabled.

Search deleted VLANs

An optional parameter which allows VLAN records to be searched in the audit history that are no longer active in the database, to reconstruct historical usage and aid in configuration or documentation reconciliation

Result Options

Display associated WiscNIC Bridge, Contact, EdgeConf Device, Route, Subnet, VLAN and VRF records. Output can be formatted in a table or as whois-style WiscNIC text records, with and without embedded formatting and links

Built-in Common Searches

There is a list provided of commonly-used search options, selecting one of these options will toggle the expected results, where the default is to return all available data. The provided search presets are:

  • Contact Info -> From User Name
  • Contact Info -> From NetID
  • Contact Info -> From Nic Handle
  • Devices -> From User Name
  • Devices -> From NetID
  • Devices -> From Nic Handle
  • FWSM Info -> From FWSM Context
  • FWSM Info -> From Subnet
  • FWSM Info -> From IP Address
  • FWSM Info -> From VLAN Number
  • Route Info -> From Subnet
  • Route Info -> From IP Address
  • Route Info -> From VLAN Number
  • Subnet Info -> From User Name
  • Subnet Info -> From NetID
  • Subnet Info -> From NIC Handle
  • Subnet Info -> From Subnet or IP Address
  • Subnet Info -> From VLAN Number
  • VLAN Info -> From User Name
  • VLAN Info -> From NetID
  • VLAN Info -> From NIC Handle
  • VLAN Info -> From Subnet
  • VLAN Info -> From IP Address
  • VLAN Info -> From VLAN Number
  • VLAN and Subnet Info -> From User Name
  • VLAN and Subnet Info -> From NetID
  • VLAN and Subnet Info -> From NIC Handle

If you have other searches that you find useful, please feel free to pass them along to the AANTS administrators for possible inclusion in this list.


Keywords:
aants, wiscnic, wiscnicsearch, search, tool, tools, script, scripts, database 
Doc ID:
8167
Owned by:
Mark T. in Network Services
Created:
2008-09-02
Updated:
2026-04-29
Sites:
Network Services, Systems & Network Control Center