Reporting on Report Scheduling 1

[Siggy19]

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 ?

 

[TopJack]

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 ?

 

[Siggy19]

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
[\CODE]

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;

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

I hope that this helps,

Siggy.

 

[TopJack]

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.