4 Replies Latest reply: May 15, 2014 10:08 AM by nclarke60 _ RSS

    Recent ODBC transfer Logs

    nclarke60 _

      I would like retrieve the latest ODBC log from a list of ODBC tranfers taking place every 15 minutes and place in a report

      I created a filter that brings in data every hour. I would like to generate a report that lists the latest entry. How do I go about this?

       

      Thanks

        • Recent ODBC transfer Logs
          Data Kruncher

          Hello and welcome to the forum.

           

          If you want to generate the information regularly, you should be able to use the Windows Task Scheduler to automatically run a Monarch batch file which generates your report.

           

          The question though is how can you determine what the latest entry is? This depends on the data captured and/or its structure. Can you post a brief sample of this log so that we can be of more assistance? Please paste the sample between and / CODE tags (without the spaces).

            • Recent ODBC transfer Logs
              nclarke60 _

              Thanks for taking my question.

              Below is the samole requested:

               

              *****  8/19/2010 12:08:26 AM                                                

                      XFType:         XFODBC                                               

                      WorkStation:    NC                                                   

                      File Name:      MVWEB                                                

                      Long Filename:                                                                               

              The following IDs were successfully imported:                        

              ID             Start Time         Stop Time          Channels Intervals     

              XRTU054        08/18/10 00:01     08/19/10 00:00     1        96                                                                               

                        • 8/19/2010 12:12:38 AM                                                

                      XFType:         XFODBC                                               

                      WorkStation:    NC                                                   

                      File Name:      MVWEB                                                

                      Long Filename:                                                                               

              The following IDs were successfully imported:                        

              ID             Start Time         Stop Time          Channels Intervals     

              XRTU890        08/17/10 00:01     08/19/10 00:00     1        192                                                                               

                        • 8/19/2010 1:33:15 AM                                                 

                      XFType:         XFODBC                                               

                      WorkStation:    NC                                                   

                      File Name:      MVWEB                                                

                      Long Filename:                                                                               

              The following IDs were successfully imported:                        

              ID             Start Time         Stop Time          Channels Intervals     

              FRANKLIN ST    08/18/10 01:31     08/19/10 01:30     3        96                                                                               

                        • 8/19/2010 1:33:32 AM                                                 

                      XFType:         XFODBC                                               

                      WorkStation:    NC                                                   

                      File Name:      MVWEB                                                

                      Long Filename:                                                                               

              The following IDs were successfully imported:                        

              ID             Start Time         Stop Time          Channels Intervals     

              HOGAN RD01     08/18/10 01:31     08/19/10 01:31     4        97            

              /CODE

                • Recent ODBC transfer Logs
                  Olly Bond

                  Hello NClarke,

                   

                  If you trap on the **** line and select one field of the format Date/Time, e.g. 8/19/2010 12:08:26 AM, and call this field "LOGTIME", say. Then apply a sort order with "LOGTIME" in Descending order of value, then apply a filter with an empty expression, say just 1, but on the advanced filter tab select Row Count of 1, you should just see the latest entry.

                   

                  HTH,

                   

                  Olly