06-17-2014 03:10 AM
Hi Techiz,
I am trying to run a report through SQL query, and I would like to know the Table name which contains the File list information of the backup job in Job Overview when you double click it.
Thanks
Sid
Solved! Go to Solution.
06-17-2014 06:14 PM
06-17-2014 06:14 PM
Hi Techiz, its nb_jobfiles.Hope this will help .
DeepS
06-18-2014 03:23 AM
Hi DeepS,
Thanks for the table, I got the information I needed, However which Table would give me the error code description? Also which table gives correct kilobytes shown in activity monitor (domain_imagecopy)?
Thanks
Sid
06-18-2014 04:46 AM
Hi,
I am using following query
SELECT
nb_JobFiles.jobId as 'Job id',
SELECT
nb_JobFiles.jobId as 'Job id',
06-18-2014 09:20 PM
What do you mean by 'error code description' ? You can get the Bytes written value from domain_JobArchive table.The column is 'bytesWritten'.
DeepS
06-19-2014 02:11 AM
Hi DeepS,
Thanks for the response, by error description I mean what error code mean, 0 stating "The requested operation was successfully completed"
Thanks
Sid
06-19-2014 05:29 AM
Hi DeepS,
Found out the table, it's lookup_JobStatusCode.
Thanks for the help.
Sid
06-25-2014 08:24 AM
Hi Techiz,
Additional request, in the query when I am using DATEDIFF, its not giving me correct date range output.
DATEDIFF(hour,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 24
even if i use
DATEDIFF(day,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 1
Number of rows are pretty less, not showing all status for 24 hours, How do I achieve it?
Thanks
Sid