NetView Events by Resource Ranking

The NetView Events by Resource Ranking report provides both general and specific cause codes for each event listed. It is useful in identifying resources having high event activity.
mics142
The NetView Events by Resource Ranking report ranks all events in ascending or descending order, as required, based on event frequency by resource name.
Format
A 6-column report approximately 132 characters wide. It is best suited for hardcopy review but can be reviewed online. The information is summarized and presented by NETWRKID, SYSID, NEFFRNAM, NEFEVGEN, NEFEVSPC, Data Range, and Zone or Zone by Hour.
Inquiry ID
  • SNTLDO - Events/Resources w/in zone
  • SNTLDP - Events/Resources w/in hour
Data Source (File/Timespan)
SNTNEF - Days
Data elements used
  • DURATION
  • NEFFRNAM
  • NEFEVGEN
  • NEFEVSPC
  • NEFNREVT
  • IQ
  • NEFNRALT
  • NETWRKID
  • SYSID
  • DATA
  • ZONE
  • RANKELEM
  • RANKLBL
  • CURRENT
Calculations
/* Data Element Derivation (DATE) */; FORMAT DATE DATE7.; LABEL DATE="Date Selection Field"; DATE = DATEPART(ENDTS); ; /* Data Element Derivation (TIME) */; FORMAT TIME TIME11.2; LABEL TIME="Time Selection Field"; TIME = TIMEPART(ENDTS); ; /* Data Element Derivation (DATA) */; LENGTH DATA $15; FORMAT DATA $CHAR15.; LABEL DATA="DATA RANGE"; DATA = ' '; /* SAS System Statements(Derive vars & data select) */; RETAIN DATEA DATEB; LENGTH DATEA DATEB 4.; DATEA = MIN(DATEA,STARTTS); DATEB=MAX(DATEB,ENDTS); IF _EOF_ THEN DO; DATEA=DATEPART(DATEA); DATEB=DATEPART(DATEB); SUBSTR(DATA,1,7)=PUT(DATEA,DATE7.); SUBSTR(DATA,8,1)='-'; SUBSTR(DATA,9,7)=PUT(DATEB,DATE7.); CALL SYMPUT('S',DATA); %GLOBAL S; DROP DATEA DATEB; END; /* Data Summarization */ %MACRO NEGATE; DATA=SYMGET('S'); %MEND NEGATE; ; /* Data Element Derivation (CURRENT, &C) */; FORMAT CURRENT WEEKDATE15.; LABEL CURRENT="CURRENT DATE"; CURRENT = TODAY(); C=PUT(CURRENT,WEEKDATE15.); C=COMPRESS(C) ; CALL SYMPUT('C',PUT(C,$CHAR12.)); %GLOBAL C; ; /* Data Element Derivation (IQ, &I) */; LENGTH IQ $8; FORMAT IQ $CHAR8.; LABEL IQ="Inquire Name"; IQ = ' '; SUBSTR(IQ,1,1)='('; SUBSTR(IQ,2,6)=SYMGET('INQINAME'); SUBSTR(IQ,8,1)=')'; CALL SYMPUT('I',PUT(IQ,$CHAR8.)); %GLOBAL I; ; /* Data Element Derivation (DURATION, elapsed time) */; FORMAT DURATION TIME5.2; LABEL DURATION="ENDTS - STARTTS"; DURATION = (ENDTS - STARTTS); ; /* Data Element Derivation (RANKELEM) */; FORMAT RANKELEM 8.; LABEL RANKELEM="&RL"; RANKELEM = &RANKELEM; ; /* Data Element Derivation (RANKLBL) */; LENGTH RANKLBL $40; FORMAT RANKLBL $CHAR40.; LABEL RANKLBL="LABEL OF RANKING ELEMENT"; RANKLBL = SYMGET('RL'); ; /* Data Element Derivation (NEFEVGEN) */; LENGTH NEFEVGEN $40; FORMAT NEFEVGEN $CHAR40.; LABEL NEFEVGEN="GENERAL EVENT CAUSE"; NEFEVGEN = PUT(NEFGEVCC,$GENEVCD.); ; /* Data Element Derivation (NEFEVSPC) */; LENGTH NEFEVSPC $40; FORMAT NEFEVSPC $CHAR40.; LABEL NEFEVSPC="SPECIFIC EVENT CAUSE"; NEFEVSPC = PUT(NEFSEVCC,$SPCEVCD.); ;
Usage considerations
All cycles are summarized together as a data range rather than reporting by individual cycle or by year, month, day, and hour as other
MICS
reports do.

NetView Events by Resource Ranking Sample 1

1 (SNTLDO) DAILY FAILING RESOURCE NAME RANKING BY ZONE FIRST 10 RESOURCE NAMES BY DESCENDING NUMBER OF EVENTS NETWORK ID: NETWORK1 SYSTEM ID: SYS1 DATA RANGE: 05JULyy-01APRyy ZONE: 1 |-IDENTIFICATION--||------------------------------- EVENT DESCRIPTION -------------------------------||--- FREQUENCY ---| |ELAPSED(HH:MM) / ||------------ GENERAL CAUSE -------------:---- SPECIFIC CAUSE --------------------|| EVENTS ALERTS | | RESOURCE NAME || || | ================= ====== ====== 4:41 P260047 PROTCOCOL-INVALID RESPONSE / COMMAND SEQ CONTROLLER OR DEVICE 142 0 0:02 T2601029 SNALEVEL PROTOCOL APPLICATION SUBSYSTEM 19 0 7:28 T3600935 SNALEVEL PROTOCOL APPLICATION SUBSYSTEM 19 0 6:22 H0411024 SNALEVEL PROTOCOL APPLICATION SUBSYSTEM 18 0 1:26 P230165 COMMUNICATIONS (LINE/MODEM/CABLE/DRIVER) UNDETERMINED 16 0 5:33 T3600932 SNALEVEL PROTOCOL APPLICATION SUBSYSTEM 16 0 4:46 T2306341 SNALEVEL PROTOCOL APPLICATION SUBSYSTEM 15 0 0:15 L23L016 HARDWARE OR MICROCODE LOCAL MODEM INTERFACE 13 13 7:40 P230137 COMMUNICATIONS (LINE/MODEM/CABLE/DRIVER) UNDETERMINED 13 0 0:02 T2306361 SNALEVEL PROTOCOL APPLICATION SUBSYSTEM 13 0 DATES=NONE, TIME=(00:00-24:00), NOTE:(K=THOUSANDS M=MILLIONS), RANKING=NEFNREVT=NUMBER OF EVENTS RUN-DATE=Wed,Sep3,yy , TIMESPAN=DAYS, DBID=8, FILE=NEF

NetView Events by Resource Ranking Sample 2

2 (SNTLDO) DAILY FAILING RESOURCE NAME RANKING BY ZONE FIRST 10 RESOURCE NAMES BY DESCENDING NUMBER OF EVENTS NETWORK ID: NETWORK1 SYSTEM ID: SYS2 DATA RANGE: 05JULyy-01APRyy ZONE: 2 |-IDENTIFICATION--||------------------------------- EVENT DESCRIPTION -------------------------------||--- FREQUENCY ---| |ELAPSED(HH:MM) / ||------------ GENERAL CAUSE -------------:---- SPECIFIC CAUSE --------------------|| EVENTS ALERTS | | RESOURCE NAME || || | ================= ====== ====== 6:57 P230008 PROTCOCOL-INVALID RESPONSE / COMMAND SEQ SDLC DATA LINE CONTROL 269 269 2:01 P260047 PROTCOCOL-INVALID RESPONSE / COMMAND SEQ CONTROLLER OR DEVICE 64 0 3:29 P230165 COMMUNICATIONS (LINE/MODEM/CABLE/DRIVER) UNDETERMINED 23 0 0:35 H0411024 SNALEVEL PROTOCOL APPLICATION SUBSYSTEM 16 0 0:02 H0411537 SNALEVEL PROTOCOL APPLICATION SUBSYSTEM 16 0 0:13 P230163 COMMUNICATIONS (LINE/MODEM/CABLE/DRIVER) UNDETERMINED 6 1 0:09 P230169 COMMUNICATIONS (LINE/MODEM/CABLE/DRIVER) UNDETERMINED 5 0 0:00 H0411538 SNALEVEL PROTOCOL APPLICATION SUBSYSTEM 4 0 10:39 P230097 COMMUNICATIONS (LINE/MODEM/CABLE/DRIVER) UNDETERMINED 4 1 0:29 H0411582 SNALEVEL PROTOCOL APPLICATION SUBSYSTEM 3 0 DATES=NONE, TIME=(00:00-24:00), NOTE:(K=THOUSANDS M=MILLIONS), RANKING=NEFNREVT=NUMBER OF EVENTS RUN-DATE=Wed,Sep3,yy , TIMESPAN=DAYS, DBID=8, FILE=NEF

NetView Events by Resource Ranking Sample 3

3 (SNTLDO) DAILY FAILING RESOURCE NAME RANKING BY ZONE FIRST 10 RESOURCE NAMES BY DESCENDING NUMBER OF EVENTS NETWORK ID: NETWORK1 SYSTEM ID: SYS3 DATA RANGE: 05JULyy-01APRyy ZONE: 2 |-IDENTIFICATION--||------------------------------- EVENT DESCRIPTION -------------------------------||--- FREQUENCY ---| |ELAPSED(HH:MM) / ||------------ GENERAL CAUSE -------------:---- SPECIFIC CAUSE --------------------|| EVENTS ALERTS | | RESOURCE NAME || || | ================= ====== ====== 0:21 C108098A SOFTWARE UNDETERMINED 24 24 0:36 CB67002 SOFTWARE UNDETERMINED 19 19 0:55 1538AU SOFTWARE UNDETERMINED 18 0 0:55 2840B6 SOFTWARE UNDETERMINED 15 0 0:49 A0327380 HARDWARE OR MICROCODE DISPLAY OR PRINTER 14 0 0:53 1724Y1 SOFTWARE UNDETERMINED 12 0 0:26 A0131842 HARDWARE OR MICROCODE DISPLAY SERVICE 11 0 0:14 A0131845 HARDWARE OR MICROCODE DISPLAY SERVICE 11 0 0:26 A0131849 HARDWARE OR MICROCODE DISPLAY SERVICE 11 0 0:26 A0131852 HARDWARE OR MICROCODE DISPLAY SERVICE 11 0 DATES=NONE, TIME=(00:00-24:00), NOTE:(K=THOUSANDS M=MILLIONS), RANKING=NEFNREVT=NUMBER OF EVENTS RUN-DATE=Wed,Sep3,yy , TIMESPAN=DAYS, DBID=8, FILE=NEF