OpsCenter SQL Query - Number of skipped files

[old_mate]

Hi all, 

I'm having troubles obtaining some information for a custom report from OpsCenter (V7.1.0.2) via a SQL query.

Specifically - 'Number of skipped files' on a client.

I can gather the information from the skipped files summary report template, but cannot find anything in the schema which specifically relates to that field. I can only list specific skipped files, instead of a number.

Is anyone able to point me in the right direction?

Many thanks.

[tom_sprouse]

What data are you looking to return on the report?

Can you provide an example:

Client Name	Date	Server	Number of Skipped Files	Policy Name
FileServer1	3/1/2012	Master	45	FileServer_User_Shares
FileServer1	3/1/2012	Master	1023	FileServer_Dept_Shares
AppServer2	3/1/2012	Media1	13	AppServer_XYZ

[old_mate]

Hi Tom, I' m requir ed to report on the following - E.g

Client Name	Start Date/Time	End Date/Time	Exit Status	Exit Code
TEST01W386	5/03/2012 12:01am	5/03/2012 02:00am	Successful	0
TEST01W387	5/03/2012 12:01am	5/03/2012 12:02am	Partially Successful	1

Backup Selection	Size of Backup	Backup Type	Backup Location	Number of skipped Files
C:\Temp\Test	2.34 GB	Full	TAPE	3
D:\Testdirectory	2 GB	Incremental	LOCAL DISK	1

The requirement is an automatically generated daily report with this info.

Possible?

Thanks again.

[Zenshai]

Cart1 - So you want this report to have a new row for each job that ran on the specified client? Do you want to do that for 1 client or all of them? Over what time period?

[Bryabroad]

Looking for example opscenter SQL report query for Oracle Backup.  Or any other examples just to get me started on how the formt should be

[tom_sprouse]

Bryabroad, 

Please create a new thread for your Oracle Reporting needs, and I will be happy to assist...

Please provide as much detail you would like to see in the report.

--Tom