Search Fields

Name
Field Type: Text
Search for name. Note there are 5 types of name (see Name Type). If no domain name is specified, the name is searched for across all domain names.

Example: find all names starting with "a" or "b" and not ending with a number
Search for Name = "[ab]*[^0-9]"

Name Types
Field Type: Checkbox
Select the types of names you wish to search for.

• Node Name- most common type of name.
  In DNS jargon, a Node Name is an A type resource record. If a DNS server is queried for the address of this name, any of the active IP addresses may be returned
• Alias
  An alias, in DNS jargon, is a canonical name (CNAME type resource record). A canonical name cannot also be used as a mx record.
• Interface Name- only found on Advanced Nodes
  Name associated only with the active IP addresses of that interface.
• IP Address Name- only found on Advanced Nodes
  Name associated with one specific IP address. DNS A type resource record.
• IPC Address Name- only found on IPC Nodes
  Name associated with an IPC address. IPC Nodes do not use the IPC addresses themselves but are responsible for passing the addresses out (e.g. Shiva Fastpaths). DNS A type resource record

Receives Mail For (MX)
Field Type: Text
In DNS jargon, Receives Mail For is an MX type resource record.

Example: find the machine that receives mail for mymail (i.e. me@mymail).
Search for Receives Mail For = "mymail"

Only Node Types and Exclude Node Types
Field Type: Checkbox
Select the Node Types you wish to search for or exclude. Note that Router, IPC and Advanced Nodes are separate access types. In other words, to add/modify/delete Node that is a Router, the User must have rights to Node and Router. Use "Exclude Node Types" allows to eliminate certain types.

• Routers- because it is a separate access type, Router is generally used by Networking Systems for real routers.
• IPCs- a Node that also passes out IP addresses to other machines
• Advanced- a Node with extra features like Interface name, IP address name
• Template- a Node that has an address space instead of IP address.

Example: find all Routers that are not Advanced
Search for Name = "[a-z]* or [0-9]*" and Only Node Type = Router and Exclude Node Type = Advanced
The Name parameter is added because otherwise the search will complain that no parameters were entered.

Example: find all Nodes starting with "ab" that do not have additional types
Search for Name = "ab*" and Exclude Node Type = Router, IPC, Advanced, and Template

IP Address
Field Type: Address
Search for interface or IPC IP address.

Example: find Nodes with IP addresses between 171.64.1.20 and 171.64.1.34
Search for IP Address = "171.64.1.20-171.64.1.34".

Example: find Nodes in the top half of 171.64.20.0/24
Search for IP address = "171.64.20.128/25"

IP Address Status
Field Type: Radio Button
Search for IP addresses that are active, inactive or either.

Hardware Address
Field Type: Address
Also know as MAC address or Ethernet address.

Example: search for Nodes with first 6 digits "00e0b8" (registered to Gateway 2000)
Search for Hardware Address = "00e0b8%" or "00-e0-b8*" or "00e0.b8%"

DHCP
Field Type: Radio Button
Search for Nodes with DHCP on, off or either

DHCP Options
Field Type: Label
For list of supported DHCP options, click on "Options List" link.

Example: search for Nodes which get a configuration file from a server named "configserver.stanford.edu"- usually an xterminal
Search for DHCP Options = "next-server=configserver.stanford.edu"

Roaming
Field Type: Radio Button
Search for Nodes with Roaming DHCP on, off or neither

Group
Field Type: Text
To add/modify/delete a Node, User must belong to the same Group as the Node. To see list of all Groups, click on "Group list" link

Example: find all Nodes in the Sociology Group
Search for Group = "Sociology"

Department
Field Type: Substring
Search for the Department associated with a Node. In a substring search, NetDB will search for departments containing all of the listed words unless separated by "or". See entire department list by clicking on "Department List" link.

Example: find all Nodes in "Bechtel International Center"
Search for Department = "Bechtel"
Don't need whole phrase since "Bechtel" is a unique word.

Example: find all Nodes in Drama or Comparative Literature
Search for Department = 'Drama or "Comparative Literature"'

Location
Field Type: Substring
Search by Node building. In a substring search, NetDB will search for Locations containing all of the listed words unless separated by "or". See entire location list by clicking on "Location List" link. The building code is also found in the name.

Example: find all Nodes in Quad 14.
Search for Location = "14-"
Hyphen is included because the standard building code format is Quad-Bldg.

Example: find all Nodes in Storey House or Columbae
Search for Location = "Storey or Columbae"

Expiration Date
Field Type: Date
Note that NetDB takes NO actions based on this date. The date is merely for user convenience (for instance, tagging machines visiting for a conference).

Example: search for Nodes with Expiration Date on January 1, 2000. On or After= 1/1/2000 Before= 1/2/2000

Make & Model
Field Type: Text
Make and Model have separate fields. See entire Make/Model list by clicking on "Make&Model list".

Example: find all Nodes which are Apple Performas
Search for Make = "Apple" and Model = "Performa *"

Example: find all Nodes made by Dell except Dell Optiplex
Search for Make = "Dell" and Model = "not optiplex"

OS
Field Type: Text
See the entire Operating System list by clicking on "OS list".

Example: search for Nodes running Redhat Linux or Caldera Linux Search for OS = "linux and (caldera or redhat)"
or OS = "linux- redhat" AND "linux- Caldera"

Administrator
Field Type: Text
Node Administrators can be an individual person or an Admin Team. To search for a person, use either sunetid or full name. For best results, use the unique sunetid. To search for Admin Team, use the Admin Team field. Only one of the three fields can be used.

Example: find Nodes administered by the Admin Teams DCG and DSG Search for Administrator Admin Team = "D?G"

Node User
Field Type: Text
Search by either sunetid (account name) or full name. For best results, use the unique sunetid. Note that only one field can be used at a time.

Custom Fields
Field Type: Label
Custom Fields are user customizable fields. The equal sign = separates the label from the value.

Example: User has customized one field to be SUID (asset #). Search for Node with asset number 1234567
Search for Custom Field = "SUID=1234567"

Example: User has customized one field to be TSO port. Search for Node connected to TSO 345
Search for Custom Field = "TSO port=*345*"

Comment
Field Type: Substring

Example: search for Node with comment mentioning "special" and "blue"
Search for Comment = "special blue". Not necessary to use "special and blue".

Modified By
Field Type: Text
Modified By is the last User to change this record. Search by either sunetid (account name) or full name. For best results, use the unique sunetid. Note that only one field can be used at a time.

Example: find records modified by either John Doe(jodoe) or Jane Doe(jadoe)
Search for Modified By SunetID = "jodoe or jadoe"
or Modified By Name = "Jane Doe or John Doe"

Modified Date
Field Type: Date
Modified Date is the last time the record was modified.

Example: search for records modified on January 1st, 2000
On or After= 1/1/2000 Before= 1/2/2000

Created By
Field Type: Text
Created By is the User who created a record. Search by either sunetid (account name) or full name. For best results, use the unique sunetid. Note that only one field can be used at a time.

Created Date
Field Type: Date
Created Date is the date that a record was creatd.

Example: search for records created on January 1st, 2000
On or After= 1/1/2000 Before= 1/2/2000

Examples

Search with following parameters:
• Created By- set display to "Yes"
• Created By Name = not "Joe LNA"
• IP Address = 175.1.7.*

2. Find all Nodes that John Doe has added or modified on August 1, 2000 in Encina Hall

Search with the following parameters:
• Location = Encina Hall
• Modified By Name = John Doe
• Modify Date On or After = August 1, 2000
• Modify Date Before = August 2, 2000

Display

Certain fields are associated with other fields. For example, IP address status is associated with a particular IP address. For a clear display, it is usually important to show the field and any fields it is associated with.

Node Associations

Field	Depends On
Alias, MX	Node Name
Hardware Address,DHCP, Roam, DHCP Options, Interface Name	Interface
Active Address, IP Address Name	IP Address