Previous Topic: 3.3.1.2.8 NetView Events by Resource Type RankingNext Topic: 3.3.1.2.10 NPDA Daily Resource Alert Summary


3.3.1.2.9 NetView Events by Resource Ranking

INTENDED USE:
 
   To rank all events in ascending or descending order based
   on event frequency by resource name.  The user chooses the
   order of ranking.  The report provides both general and
   specific cause codes for each event listed.  It is useful
   in identifying resources 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, 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 CA MICS reports do.

                                                                                                                                  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



                                                                                                                                  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



                                                                                                                                  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


 Figure 3-