cancel
Showing results for 
Search instead for 
Did you mean: 

Opscenter SQL Query, Table which contains File List

Sid1987
Level 6
Certified

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

1 ACCEPTED SOLUTION

Accepted Solutions

Deeps
Level 6

Hi Techiz, its nb_jobfiles.Hope this will help .

 

DeepS

View solution in original post

7 REPLIES 7

Deeps
Level 6

Hi Techiz, its nb_jobfiles.Hope this will help .

 

DeepS

Sid1987
Level 6
Certified

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

Sid1987
Level 6
Certified

Hi,

 I am using following query

SELECT

nb_JobFiles.jobId as 'Job id',

domain_JobArchive.clientName as 'Client',
domain_JobArchive.statusCode as 'Exit Status',
nb_JobFiles.size as 'Size',
domain_JobArchive.throughPut as 'Throughput',
nb_JobFiles.fileinfo as 'File List',
UTCBigIntToNomTime(domain_JobArchive.startTime) as 'Start Time',
UTCBigIntToNomTime(domain_JobArchive.endTime) as 'End Time'
FROM nb_JobFiles, domain_JobArchive
WHERE
domain_JobArchive.Id=nb_JobFiles.jobId
AND DATEDIFF(hour,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 24;
 
Now in this it picks up only parent jobs which doesnt has any size (Null in that field), when i removed 24 hours constraint by removing last line, it does give me output but still not size.
 
When I tried to get size from doamin_ImageCopy, the query doesn't give me any output, it sits there and then says temporary size is exceeded.
 

SELECT

nb_JobFiles.jobId as 'Job id',

domain_JobArchive.clientName as 'Client',
domain_JobArchive.statusCode as 'Exit Status',
domain_ImageCopy.sizeInBytes as 'Size',
domain_JobArchive.throughPut as 'Throughput',
nb_JobFiles.fileinfo as 'File List',
UTCBigIntToNomTime(domain_JobArchive.startTime) as 'Start Time',
UTCBigIntToNomTime(domain_JobArchive.endTime) as 'End Time'
FROM nb_JobFiles, domain_JobArchive, domain_ImageCopy
WHERE
domain_JobArchive.Id=nb_JobFiles.jobId
 

Deeps
Level 6

What do you mean by 'error code description' ? You can get the Bytes written value from domain_JobArchive table.The column is 'bytesWritten'.

 

DeepS

Sid1987
Level 6
Certified

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

Sid1987
Level 6
Certified

Hi DeepS,

 

Found out the table, it's lookup_JobStatusCode.

 

Thanks for the help.

Sid

Sid1987
Level 6
Certified

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