Custom report based on VI job logs?

I'm trying to set up a report for an alert, after running an automated VI import.  The customer (v2014 Premium) wants to know if there are any failed / invalid records.  I know the data is available, because the UI can produce reports based on job results, but I can't find a way to build a custom report for this.  It seems the logs are in ProvideX files, even though the customer is Premium, with no ODBC exposure... \MAS90\VI\VIWI##.m4t (and not VI_JobLog.M4T as I originally suspected).

I know I can query SY_ActivityLog for some basic header information, but I believe that only shows failed lines, not lines imported with invalid fields (which are an important consideration for such an alert).

I see DSD has an old enhancement for moving the data from ProvideX to a text file, but I'm hoping for something more report-friendly.

I've looked briefly into this before, but we really need something this time.  Does anybody have a solution?  (And why is this data still in ProvideX, when the system is Premium?!?).

Parents
  • 0
    Why indeed. I remember that the Obe Wan of MAS90, Slade once had a perform logic job that translated the VI job file to a text file. Not sure if anyone has that code or if it can be updated. Maybe some of the old hands might have something otherwise DSD is it.
Reply
  • 0
    Why indeed. I remember that the Obe Wan of MAS90, Slade once had a perform logic job that translated the VI job file to a text file. Not sure if anyone has that code or if it can be updated. Maybe some of the old hands might have something otherwise DSD is it.
Children