Advanced Photon Source

An Office of Science National User Facility

Computer Support Network Tracking System User's Guide

The Network Equipment Tracking System (ETS) provides a mechanism for tracking computer equipment and its wiring within the APS computer network throughout the APS facility.

Getting Started

To access the IT Network Tracking System, at the ETS Main Menu, select the option Computer Support.

At the Computer Support Tracking Systems menu, select the option Network Tracking System.

View/Enter Network Data

This section of the Network Tracking System allows you to enter or query Network Address Data, Machine Codes, or Subnet Codes, and allows you to change node names or add new manufacturers to the database.

Network Address Data

The following is a graphic of the Network Address Data Entry/Query screen.

Network Address Data Entry/Query screen

Moving About

Use the Next Field key (Tab) to move forward through fields. Use the Previous Field (locate its position on your Oracle keyboard template) to move backwards through fields. Use the Commit key to save your data entry or to close a Window. Use the Next Block and Previous Block keys to move between the node information block and the routing information block. If the List Field Values function is available for a field, a notation to that effect will be contained in the instructions for completing the field given below.

Note: inexperienced ORACLE users should obtain a copy of the APS SQL*FORMS User Guide from the MIS Group. Learning the functions and keys of SQL*FORMS will speed your travels through this system.

Node Information Block

This block of data entry fields is used to track a specific node name on the APS computer network and the characteristics of the computer equipment assigned that node name.

Field Descriptions

Node Name

Enter the node name for the equipment up to a maximum of 15 characters. This is a primary key, and must be entered.

Custodian

Enter the 5 character badge number of the employee who has been assigned responsibility for this equipment. The List Field Values option is available on this field. When you enter a badge into the first portion of this field, then press Next Field, the corresponding name of the individual assigned that badge will appear in the second portion of the field.

Location

When a custodian is assigned in the field above, the building and room number will be filled in via Workday database. It can be overwritten by typing over what appears.

Equipment Type

Enter the machine code that indicates the equipment type. The List Field Values option is available on this field. When a machine code is chosen in the first portion of this field, a description for that code will appear in the second portion of the field. This LOV is maintained through the option "Machine Codes Data Entry/Query" available from the View/Enter Network Data menu.

Manufacturer

Enter the appropriate code indicating the manufacturer or brand name, i.e., Apple, IBM, for this equipment. The List Field Values option is available on this field. When a manufacturer number is chosen in the first portion of this field, a description for that code will appear in the second portion of the field. The table that maintains this LOV is also used by the Property Tracking and Equipment Tracking Systems; this means that any manufacturers added through those systems will also be added in the Network Tracking system. New manufacturers can also be entered through the option "Add New Manufacturer" available from the View/Enter Network Data menu.

Local Disk

The disk capacity for this piece of equipment in megabytes to a maximum of 5 digits in length.

Memory

The main memory capacity for this piece of equipment in megabytes to a maximum of 5 digits in length.

Serial No.

The manufacturer's serial no. up to a maximum of 20 characters in length.

ANL Prop. No.

The property number assigned to this piece of equipment by ANL (up to 10 characters in length). The List Field Values option is available on this field.

APS Equip. No.

The Equipment No. from the ETS database (up to 15 characters in length). The List Field Values option is available on this field.

Routing Information Block

This block of data entry fields is used to indicate the wiring and address information for how this equipment is connected into the network.

Field Descriptions

Port

Indicates the connection type and port numbers for the device up to 25 characters in length.

Ethernet Address

Indicates the ethernet address assigned to this equipment to a maximum of 17 characters in length.

Cable/Jnct

Indicates the cable number(s) or junction box that physically connects this equipment to the network up to 9 characters in length.

Adapter Type

Indicates any adapters that are used to connect this equipment to the network and its type up to 20 characters in length.

Subnet

Enter the appropriate Subnet Code (up to 5 characters in length). The List Field Values option is available on this field. The data contained in this list is maintained in the Subnet Codes option of the View/Enter Network Data menu.

IP Address

Indicates the IP address for the equipment up to 15 characters in length.

Domain

Indicates the acronym for the domain this equipment is assigned to within the APS up to 10 characters in length.

You are now at the end of the data entry screen. Press the Commit key to save your data entry.

To enter additional Network information into the system, press the Create Record key.

To exit data entering , press the Exit/Cancel key and you will return to the View/Enter Network Data Menu.

Viewing Network Data

In order to locate information that was previously entered into the system, you must do a Query (search) to locate that information. Doing a query by node name will retrieve information for only one node since node names are unique. There are basically four steps involved with a Query:
  1. Enter Query - press the Enter Query key and you will see a message in the Message Line that reads Enter a query.
  2. Enter your search criteria - if you know the Node name, you should enter it in the Node field since this is a unique name and will retrieve only on record. If you do not know the node name, you should enter data in the fields that are pertinent to what you are looking for.
  3. Pressing the Count Query Hits key gives you a listing of how many sets of information matched the criteria you used in your Query. This feature is only valid if executed before Execute Query.
  4. Execute Query - press the Execute Query key and the system will look for all information in the system that matches your search criteria.

The system recognizes certain wild card characters. When entering query data into a field, you can specify the following special characters.

     Symbol Represents
     %Any sequency of zero or more characters
     _Any single character.

The List Field Values option is available on fields during an execute query.

Machine Codes Data Entry/Query

The Machine Codes option allows you to maintain the table data that is used for the LIST FIELD VALUES for the Machine Code field of the Network Address data entry screen.

Selecting this option will bring up the following data entry screen:

Data entry screen

Field Descriptions

Code

A unique number to be assigned to this machine type.

Description

A description of the machine type, up to a maximum of 30 characters.

Executing a Query without specifying data search criteria will allow you to view all machine codes stored in the machine type database tables.

Machine codes appear in this table by machine type. To enter a new machine code, use the Next Record key to move to the block of records for that machine type, then press the Create Record key. Enter the appropriate values into the Code and Description fields, then press Commit to save your data entry.

To exit data entering, press the Exit/Cancel key and you will return to the View/Enter Network Data menu.

Subnet Codes Data

The Subnet Codes option allows you to maintain the data within the LIST FIELD VALUES for the Subnet Code field of the Network Address data entry screen.

Selecting this option will bring up the following data entry screen:

Data entry screen

Field Descriptions

Code

A unique number to be assigned to a subnet type.

Description

A description of the subnet, up to a maximum of 30 characters.

Executing a Query without specifying data search criteria will allow you to view all subnet codes stored in the subnet database tables.

To enter additional Subnet Codes into the system, press the Create Record key and you will move to the next line of data entry.

To exit data entering, press the Exit/Cancel key and you will return to the View/Enter Network Data menu.

Network Address - Query Only

The Network Address - Query Only option allows you to view data entered for a specific node.

Selecting this option will bring up the following data entry screen:

Data entry screen

The fields contained on this screen are the same as those described in the Network Address Data Entry/Query option. Their placement on the screen, however, is different. Information from the routing information block appear first, and information from the node information block appear second (in reverse order from the data entry screen).

Doing a query on node name will retrieve only one record as node names are unique. Executing a Query without specifying data search criteria will allow you to view all records stored in the network database tables.

To exit this option, press the Exit/Cancel key and you will return to the View/Enter Network Data menu.

Node Name Change Utility

The Node Name Change Utility option allows you change the name for a specific node on the network.

Selecting this option will bring up the following screen:

Node Name Change Utility screen

When you access this option, you will be in query mode. You should first enter the old node name, then press execute query. You may then make your changes. You can also query by the custodian field.

Field Descriptions

Old Node Name

The name of the node to be changed. The List Field Values option is available on this field.

Custodian

The badge and name of the custodian for the equipment assigned this node name.

New Node Name

The name of new node name to be assigned to the equipment.

Location

The building and room where this equipment resides.

To change a node name, enter the old node name in the Old Node Name field, then press Execute Query. The corresponding information for the Custodian: and Location: fields will be retrieved to your screen. You will then be placed at the data entry field New Node Name:. Enter the new node name, up to a maximum of 15 characters in length, then press Commit to complete the node name change.

To leave this utility, press the Exit/Cancel key and you will return to the View/Enter Network Data menu.

Add New Manufacturer

The Add New Manufacturer option allows you to add new manufacturer to the database. Manufacturers added through this utility will become available through the LOV for the Network Tracking System as well as the Property Tracking and Equipment Tracking Systems.

Selecting this option will bring up the following data entry screen:

Add New Manufacturer screen

Field Descriptions

Manufacturers

The name of the manufacturer up to a maximum of 30 characters in length.

To enter a new manufacturer, enter the enter the manufacturer name, then press Commit. A new manufacturer code will appear in the first field.

To leave this utility, press the Exit/Cancel key and you will return to the View/Enter Network Data menu.

Report Network Data

This section of the Network Tracking System allows you to print various reports based on the data stored within the Network Tracking System database.

Report #1

This option prints to a printer a listing of all equipment within the network tracking system by

To access this option, at the Network Tracking System menu, select the option "Report Network Data." At the Network Reports menu, select the option "Report #1." The following parameter prompt will appear:

Report Network Data screen

Enter the appropriate printer parameter, then press Return or Enter.

The following is an example of this report and the fields it contains:

 

DOMAIN IP#NAMETYPEETHERNETLOC NAME

APS47.965130.202.20.54MISMO1Mac IIsi00-00-00360-C233Smith, John

 

Generate On-Line Search Flat File

This option generates the same report information contained in Report #1. However, rather than printing a hard copy of this information, it places a flat file called "APS_NETWORK.LIS" in the directory "MIS$ROOT:[NETWORK.REPORTS].

To access this option, at the Network Tracking System menu, select the option "Report Network Data." At the Network Reports menu, select the option "Generate On-Line Search Flat File." The report will then be generated.

Equipment Tag

This option produces an Equipment Tag that should be generated and attached to each piece of equipment entered into the database. The following is an example of an Equipment Tag and the information it contains:

NODE NAME: MISM01

Custodian: Shoe, Jim Badge No.: NNNNNN
  Location: 401-C224

Equipment Type:  MAC IIFX
 Mfr: APPLE COMPUTER Serial No.:
 Local Disk: ANL Prop No.:
 Memory: APS Equip. No.:

Notes:

Port Ethernet Address Cab/Junct Adapter Type Subnet IP Address Domain

Hardware

This option functions in the same manner as the option Generate On-line Search Flat File described above. However, it only contains information with a machine type description like SUN. It places a flat file called "SUNPO.LIS" in the directory "MIS$ROOT:[NETWORK.REPORTS].

To access this option, at the Network Tracking System menu, select the option "Report Network Data." At the Network Reports menu, select the option "Sun Hardware." The report will then be generated.Network.con 11/17/2008 11:58