Previous Topic: 3.3.1.2.7 NetView Events RankingNext Topic: 3.3.1.2.9 NetView Events by Resource Ranking


3.3.1.2.8 NetView Events by Resource Type Ranking
INTENDED USE:
 
   To rank all events in ascending or descending order based
   on event frequency and resource type.  The user chooses
   the order of ranking and resource types.  The report
   provides both general and specific cause codes for each
   event listed.  It is useful in identifying systems having
   high event activity.
 
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, NEFFRTYP, NEFEVGEN, NEFEVSPC, Data Range,
   and Zone or Zone by Hour.


INQUIRY ID:

   SNTLDI - Events/Resource types w/in zone
   SNTLDJ - Events/Resource types w/in hour

DATA SOURCE (File/Timespan):

   SNTNEF - Days

DATA ELEMENTS USED:

   DURATION, NEFFRTYP, 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 an individual cycle or by year, month,
   day, and hour, as other CA MICS reports do.

                                                                                                                                  1                                        (SNTLDI) DAILY FAILING RESOURCE TYPE RANKING BY ZONE                           FIRST 10 RESOURCE TYPES 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 TYPE   ||                                                                                 ||                 |  =================                                                                                      ======   ======   8:51    DEV       SNALEVEL PROTOCOL                        APPLICATION SUBSYSTEM                         217        0   4:41    CTRL      PROTCOCOL-INVALID RESPONSE / COMMAND SEQ CONTROLLER OR DEVICE                          143        0   8:57    CTRL      COMMUNICATIONS (LINE/MODEM/CABLE/DRIVER) UNDETERMINED                                   86        4   8:14    LDEV      SNALEVEL PROTOCOL                        APPLICATION SUBSYSTEM                          32        0   7:32    LINE      HARDWARE OR MICROCODE                    LOCAL MODEM                                    28       28   5:37    LINE      HARDWARE OR MICROCODE                    LOCAL MODEM INTERFACE                          21       21   7:21    CTRL      SOFTWARE                                 UNDETERMINED                                   10        1   8:50    CTRL      PROTCOCOL-INVALID RESPONSE / COMMAND SEQ SDLC DATA LINE CONTROL                         10        4   7:03    LINE      COMMUNICATIONS (LINE/MODEM/CABLE/DRIVER) UNDETERMINED                                   10        2   8:46    CTRL      HARDWARE OR SOFTWARE                     UNDETERMINED                                    9        9                         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

                                                                                                                                  2                                        (SNTLDI) DAILY FAILING RESOURCE TYPE RANKING BY ZONE                           FIRST 10 RESOURCE TYPES 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 TYPE   ||                                                                                 ||                 |  =================                                                                                      ======   ======  18:02    CTRL      PROTCOCOL-INVALID RESPONSE / COMMAND SEQ SDLC DATA LINE CONTROL                        279      270  16:13    CTRL      COMMUNICATIONS (LINE/MODEM/CABLE/DRIVER) UNDETERMINED                                   94        3   2:01    CTRL      PROTCOCOL-INVALID RESPONSE / COMMAND SEQ CONTROLLER OR DEVICE                           64        0  17:05    LDEV      SNALEVEL PROTOCOL                        APPLICATION SUBSYSTEM                          44        0   0:00    LINE      HARDWARE OR MICROCODE                    LOCAL MODEM INTERFACE                          35       25  17:06    DEV       SNALEVEL PROTOCOL                        APPLICATION SUBSYSTEM                          25        0   9:55    DEV       HARDWARE OR MICROCODE                    DISPLAY OR PRINTER                              5        1  13:31    LINE      HARDWARE OR MICROCODE                    LOCAL MODEM                                     5        5  15:13    CTRL      SOFTWARE                                 UNDETERMINED                                    2        1   0:05    LINE      COMMUNICATIONS (LINE/MODEM/CABLE/DRIVER) UNDETERMINED                                    2        1                         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



                                                                                                                                  3                                        (SNTLDI) DAILY FAILING RESOURCE TYPE RANKING BY ZONE                           FIRST 10 RESOURCE TYPES 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 TYPE   ||                                                                                 ||                 |  =================                                                                                      ======   ======   0:58    DEV       SOFTWARE                                 UNDETERMINED                                  129        0   0:57    CTRL      SOFTWARE                                 UNDETERMINED                                   88       62   0:40    DEV       HARDWARE OR MICROCODE                    DISPLAY SERVICE                                51        0   0:21    LKST      SOFTWARE                                 UNDETERMINED                                   33       33   0:54    LINE      HARDWARE OR MICROCODE                    LOCAL MODEM INTERFACE                          28       28   0:55    LINE      HARDWARE OR MICROCODE                    LOCAL MODEM                                    27       27   0:47    CTRL      HARDWARE OR SOFTWARE                     MAIN STORAGE                                   19       19   0:49    DEV       HARDWARE OR MICROCODE                    DISPLAY OR PRINTER                             17        0   0:56    LINE      SOFTWARE                                 UNDETERMINED                                   11        0   0:32    CTRL      UNDETERMINED                             UNDETERMINED                                    4        4                         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

 Figure 3-