How can I query the AAI database to get the System Calculated Late Criterion for each Jobstream?

Products

• Automation Analytics & Intelligence

Issue/Introduction

How can I query the AAI database to get the System Calculated Late Criterion for each Jobstream?

Environment

Release : 6.4.4

Resolution

For a specific jobstream:

select js.description , CONVERT(varchar(8), DATEADD(MILLISECOND, jsa.lateEndTime, 0), 8) from JobStreamAverage jsa , JobStream js

where js.jobStreamId = jsa.jobStreamId

and js.description ='<JobstreamName>';

 

 

For all Jobstreams:

 

select js.description , CONVERT(varchar(8), DATEADD(MILLISECOND, jsa.lateEndTime, 0), 8) from JobStreamAverage jsa , JobStream js

where js.jobStreamId = jsa.jobStreamId;