Ops Center skipped files reporting-drilling down detalis needed

[Jonathan_Sees1]

Hi all,

I can run the skipped files report normally from ops center but doesn't quit give me all the information I need.

When logged into ops center you can drill down and see which files have been skipped.

Is there any way I can have this information included in the report that's emailed?

If drill down into a client and the email it, it shows the skipped flies.

But I need this included in the report from the outset.

Hope this make sense!!

Cheers Jonathan.

[DG-2005]

I think this will cover what you are looking for :D

Shows Client, Job ID, files Skipped, Error reason, Error code #, and Time skipped.

This handles for past 24 hours but can be easily extended.

If this is what you were looking for please, mark as solution

SELECT clientName AS "Client",
jobID AS "Job ID",
name AS "Skipped",
reason AS "Error",
code as "Code",
UtcBigIntToNomTime(skipTime) AS "Time"
FROM domain_SkippedFileArchive
WHERE DATEDIFF(hour, UtcBigIntToNomTime(skipTime), GETDATE()) <= 24
ORDER BY jobid DESC;

[Jonathan_Sees1]

Thaknks for you help!!

[DG-2005]

if you could mark the above as solution it would be appreciated :)