5 Replies Latest reply: Feb 18, 2014 2:00 PM by Jessica Engel RSS

    System Monitor - Reload Failure

    Darrell Butler

      Hi,

       

      The QV11 v4.1 app does not reload as it can't find the field Severity fromthe following piece of script. looking at the logs severity is clearly there - has anybody experienced this ?

       

      LOAD



       
      RecNo() as EventNbr,

       
      [Server Started] AS [Server Started Events],

          
      Timestamp, //YYYY-MM-DD

           Date(Timestamp) &'_'& Time(Timestamp,'hh')&'_'& Time(Timestamp, 'mm') as DateHourKey, //MM/DD/YYYY_HH_MM

        Time(Timestamp) as EventsTime,     

       
      Timestamp as EventsTimestamp,

          
      SeverityID,

          
      EventID,

          
      Severity,

          
      Message,

          
      TextBetween(mid(FileName(),1,index(FileName(),'.')-1)&'_', '_', '_') as QVSClusterNodeEvents

      FROM

      $(QVSPath)\Events_*.log  //Changed

      (txt, utf8, embedded labels, delimiter is '\t', msq)

      //Make sure no erroneous events load in

      Where Severity = 'Information' OR Severity ='Warning' OR Severity ='Error' OR Severity ='Notice';