×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Reporting on Report Scheduling

Reporting on Report Scheduling

Reporting on Report Scheduling

(OP)
We have Seagate Info running over 100 reports and I want to generate some sort of report that shows when the reports start and how long they are running.

While I can write my own report from the Access Database that stores the status information (CINFO is the database and CI_RUNTIMEIMAGE is the table), ideally I would prefer a graphical portrayal so I can see any gaps between reports etc.

Does Seagate Info have anything built in that does this or does anyone have any other suggestions ?

RE: Reporting on Report Scheduling

I was just thinking the same. Great minds think alike. This would be a nice way to view multiple reports easily.

Has anyone got any ideas ?

RE: Reporting on Report Scheduling

(OP)
This is nothing like the best possible solution but...

Seagate Info uses an old format Access database in a file called CINFO.mdb

The two tables in that database that seem to be relevent are CI_RUNTIMEIMAGE and CI_INFOOBJECTS.

Although you cannot (and should not) modify the original database, you can link to those tables from another Access database and then the following SQL will give you a list of the current day's reports in the order that they were run;


    SELECT a.CI_NAME, b.CI_PARAMETER, b.CI_STARTTIME, b.CI_ENDTIME
    FROM CI_INFOOBJECTS a, CI_RUNTIMEIMAGE b
    WHERE a.CI_ID = b.CI_REPORTID
        AND b.CI_STARTTIME >= DATE()
        AND b.CI_RECURPARENTID <> -1
    ORDER BY b.CI_STARTTIME, b.CI_ENDTIME


If you want to deliberately ignore some reports (for example, they run regularly during the day and so are not part of the overnight processing that you are really concerned about, adapt the following code and add it to the WHERE clause;


        AND a.CI_NAME NOT IN ('CA Report Server Update Check', 'Default Report Server Update Check')


I hope that this helps,

Siggy.

RE: Reporting on Report Scheduling

Thanks Siggy. You have confirmed what I thought. That CINFO database is the source of these kind of statistics. I guess I will have to graph from that database. Maybe next Seagate version upgrade will have something in built for us.

Thanks.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close