07-22-2014 05:51 AM
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.
07-22-2014 07:24 AM
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;
07-23-2014 05:08 AM
Thaknks for you help!!
07-23-2014 05:46 AM
if you could mark the above as solution it would be appreciated :)