User`s guide

Each of the BY and CLASS variables must have a Kept status of Yes.
Note: These lists apply to a table definition and are used to process and reduce data.
This BY variables list is not related to the BY variables that you can select for a report definition.
More about frequently used variables:
MACHINE is the host name of the node on which the metrics were created. In the process step, the value
of MACHINE is obtained from the value of IPADRES.
DATETIME is the timestamp on the observation.
IPADRES is the TCP/IP address of the machine (node) that created the metric values in an observation.
To group data, IT Service Vision uses MACHINE name (host name) rather than IPADRES because IP
addresses generally change more frequently than system names. (IP addresses can change for network
upgrades, office moves, and so on.) Generally, the mapping of IPADRES to a MACHINE name happens
automatically (via snmpColDump) at the process step by using the management host’s IP address table or
name server. If data for an IP address is encountered in the input data for a machine that has not been
defined yet to the SNMP management host, MACHINE will be assigned the same value as IPADRES’s
value.
INSTANS is the interface identifier. For example, a router may have two ports, each with a unique
instance identifier such as 0 or 1.
If you want reports based on IPADRES instead of MACHINE, you can make them in a task later in this
section. That task walks you through how to make custom report definitions by modifying supplied report
definitions and saving them.
Note: IPADRES, and INSTANS apply to HP OpenView and NetView for AIX only.
HOUR is the hour of the observation.
If the Kept status of HOUR is Yes, when an observation is processed into the PDB then IT Service
Vision calculates the value of HOUR. The value of hour is based on the hour in the value of DATETIME.
If HOUR is in the BY variables list, you must keep data for it. If HOUR is not in the BY variables list,
you can set the Kept status of HOUR to No; however, that change is not recommended.
SHIFT is the work shift code for the observation.
If the Kept status of SHIFT is
Yes
, when an observation is processed into the PDB then IT Service
Vision calculates the value of SHIFT (unless the observation has a non-blank value for SHIFT). First, IT
Service Vision checks to see if the date in DATETIME is on the list of holidays at your site. If so, the
value of SHIFT is set to the work shift code for holidays. If not, the value of SHIFT is based on the
day-of-week and hour of the value that is in DATETIME and on the grid that contains work shift code by
Day of Week and Hour of Day. For more details on the work shift grid, see Section 1, Task 1: Start IT
Service Vision Server Software.
If SHIFT is in the BY variables list, you must keep data for it. If SHIFT is not in the BY variables list,
you can set the Kept status of SHIFT to No; however, that change is not recommended.
b. Review the ID variables lists for each of the tables that you selected.
ID variables are non-changing or slowly changing variables whose values you want to have available for
reporting at one or more reduction levels.
c. Review the Index variables lists for each of the tables that you selected.