15 Replies Latest reply: Apr 13, 2017 8:06 AM by Avinash Jain RSS

    STRAIGHT TABLE DATE CAN BE MAPPED WITH 0-23 hours and then do the logic based on HOUR filter.?

    Avinash Jain

        DEAR TEAM,

      IS THERE ANY WAY BY WHICH DATE CAN BE MAPPED WITH 0-23 hours and then do the logic based on HOUR filter.?

       

      CAN YOU PLEASE SUGGEST ?

       

      INPUT FILE:

      AlarmDateAlarm IDTechnologyVendorRNCNodeBCellNE LevelRaised TimeDropped TimeSeverity
      17-02-20171483992308686UMTSZTER1S1 NODEB17-02-2017 15:1617-02-2017 18:16Critical
      17-02-20171483992308685UMTSZTER2S1 NODEB17-02-2017 15:1617-02-2017 18:16Critical
      17-02-20171483992308684UMTSZTER3S1 NODEB17-02-2017 15:16 Critical
      17-02-20171483992308683UMTSZTER4S1EKOL0000JGPA3CELL17-02-2017 15:0817-02-2017 18:08Critical
      17-02-20171483992308682UMTSZTER5S1EKOL0000JGPA2CELL17-02-2017 15:0817-02-2017 18:08Critical
      17-02-20171483992308680UMTSZTER6S1EKOL0000JGPA1CELL17-02-2017 15:08 Critical
      17-02-20171483992308679UMTSZTER7S1EKOL0000BOND3CELL17-02-2017 14:54 Critical
      17-02-20171483992308678UMTSZTER8S1EKOL0000BOND2CELL17-02-2017 14:54 Critical
      17-02-20171483992308673UMTSZTER9S1 NODEB17-02-2017 14:45 Critical
      17-02-20171483992308672UMTSZTER10S1 NODEB17-02-2017 10:38 Critical
      17-02-20171483992303238UMTSZTER11S1 NODEB17-02-2017 15:1317-02-2017 18:13Major
      17-02-20171483992267154UMTSZTER12S1 NODEB17-02-2017 15:1417-02-2017 18:14Major
      17-02-20171483992267153UMTSZTER13S1 NODEB17-02-2017 15:14 Minor
      17-02-20171483992267147UMTSZTER14S1 NODEB17-02-2017 15:14 Major
      17-02-20171483992267144UMTSZTER15S1 NODEB17-02-2017 15:14 Minor
      17-02-20171483992267143UMTSZTER16S1 NODEB17-02-2017 15:13 Major
      17-02-20171483992267142UMTSZTER17S1 NODEB17-02-2017 15:13 Minor
      17-02-20171483992267134UMTSZTER18S1 NODEB17-02-2017 15:12 Minor
      17-02-20171483992267133UMTSZTER19S1 NODEB17-02-2017 15:12 Minor
      17-02-20171483992267132UMTSZTER20S1 NODEB17-02-2017 15:12 Minor
      17-02-20171483992308686UMTSZTER21S1 NODEB17-02-2017 15:1617-02-2017 18:16Critical
      17-02-20171483992308685UMTSZTER22S1 NODEB17-02-2017 15:1617-02-2017 18:16Critical
      17-02-20171483992308684UMTSZTER23S1 NODEB17-02-2017 15:16 Critical
      17-02-20171483992308683UMTSZTER24S1EKOL0000JGPA3CELL17-02-2017 15:0817-02-2017 18:08Critical
      17-02-20171483992308682UMTSZTER25S1EKOL0000JGPA2CELL17-02-2017 15:0817-02-2017 18:08Critical
      17-02-20171483992308680UMTSZTER26S1EKOL0000JGPA1CELL17-02-2017 15:0817-02-2017 21:08Critical
      17-02-20171483992308679UMTSZTER27S1EKOL0000BOND3CELL17-02-2017 14:5417-02-2017 20:54Critical
      17-02-20171483992308678UMTSZTER28S1EKOL0000BOND2CELL17-02-2017 14:54 Critical
      17-02-20171483992308673UMTSZTER29S1 NODEB17-02-2017 14:45 Critical
      17-02-20171483992308672UMTSZTER30S1 NODEB17-02-2017 10:38 Critical
      17-02-20171483992303238UMTSZTER31S1 NODEB17-02-2017 15:1317-02-2017 18:13Major
      17-02-20171483992267154UMTSZTER32S1 NODEB17-02-2017 15:1417-02-2017 18:14Major
      17-02-20171483992267153UMTSZTER33S1 NODEB17-02-2017 15:1417-02-2017 21:14Minor
      17-02-20171483992267147UMTSZTER34S1 NODEB17-02-2017 15:1417-02-2017 21:14Major
      17-02-20171483992267144UMTSZTER35S1 NODEB17-02-2017 15:14 Minor
      17-02-20171483992267143UMTSZTER36S1 NODEB17-02-2017 15:13 Major
      17-02-20171483992267142UMTSZTER37S1 NODEB17-02-2017 15:13 Minor
      17-02-20171483992267134UMTSZTER38S1 NODEB17-02-2017 15:12 Minor
      17-02-20171483992267133UMTSZTER39S1 NODEB17-02-2017 15:12 Minor
      17-02-20171483992267132UMTSZTER40S1 NODEB17-02-2017 15:12 Minor

       

       

      Based on above table structure there is requirement to get COUNT(ALARMID) on "Hour basis"" and also DAILY basis.

       

      So output table requirement is :

         

      ResolutionDateHourCRITICALMAJORMINORWARNING
      HOURLY17-02-201700000
      HOURLY17-02-201710000
      HOURLY17-02-201720000
      HOURLY17-02-201730000
      HOURLY17-02-201740000
      HOURLY17-02-201750000
      HOURLY17-02-201760000
      HOURLY17-02-201770000
      HOURLY17-02-201780000
      HOURLY17-02-201790000
      HOURLY17-02-2017101000
      HOURLY17-02-2017111000
      HOURLY17-02-2017121000
      HOURLY17-02-2017131000
      HOURLY17-02-2017144000
      HOURLY17-02-20171510460
      HOURLY17-02-20171610460
      HOURLY17-02-20171710460
      HOURLY17-02-20171810460
      HOURLY17-02-2017196260
      HOURLY17-02-2017206260
      HOURLY17-02-2017216260
      HOURLY17-02-2017224150
      HOURLY17-02-2017234150

       

      and :

         

      ResolutionDateSeverityCount
      DAILY17-02-2017CRITICAL10
      DAILY17-02-2017MAJOR4
      DAILY17-02-2017MINOR6
      DAILY

      17-02-2017

       

       

       

       

       

       

      WARNING0