4 Replies Latest reply: Jun 28, 2015 2:25 PM by Ruben Marin RSS

    MTD

      Hi All

        

      Submited ByFalse Alert=[Sam Ref Id]
      1158631: Degalesan, Raghunathan - 02/03/2015 10:48:28 PM#L2/L3 ApprovedSAM123102286552
      1158631: Degalesan, Raghunathan - 02/03/2015 10:56:38 PM#L2/L3 ApprovedSAM123102286573
      1158631: Degalesan, Raghunathan - 02/03/2015 11:21:16 PM#Auto ApprovedSAM123102286683
      1163317: palanikumar raman - 05/03/2015 08:47:23 PM#L2/L3 ApprovedSAM529106947601
      1166466: Srinivasan Gayathri - 03/03/2015 07:43:49 PM#L2/L3 ApprovedSAM123102289503
      1166466: Srinivasan Gayathri - 04/03/2015 08:46:45 PM#L2/L3 ApprovedSAM123102293281
      1166466: Srinivasan Gayathri - 08/03/2015 05:26:02 PM#L2/L3 ApprovedSAM123102303422
      1166466: Srinivasan Gayathri - 25/03/2015 05:57:14 PM#L2/L3 ApprovedSAM123102303474
      1166466: Srinivasan Gayathri - 26/03/2015 10:53:17 PM#L2/L3 ApprovedSAM123102304200
      1166466: Srinivasan Gayathri - 16/04/2015 10:36:15 PM#L2/L3 ApprovedSAM123102327431
      1166466: Srinivasan Gayathri - 17/04/2015 05:03:32 PM#L2/L3 ApprovedSAM124102328599
      1166466: Srinivasan Gayathri - 18/04/2015 09:02:07 PM#SAM123102331772
      1166466: Srinivasan Gayathri - 23/04/2015 05:18:10 PM#L2/L3 ApprovedSAM124102343668
      1166466: Srinivasan Gayathri - 24/04/2015 04:29:35 PM#L2/L3 ApprovedSAM123102348301

       

      Need to find the distinct Sam Ref Id for the MTD of Max Month and MTD of  Previous Month where false Alert not equal to Auto Approved.

      In the above example April all data and March excluding 25th and 26th