I've seen this sort of issue if the addressablity of the drive is wrong,
e.g. logical drive 1 has physical drive 2 address. So library mounts tape
in drive 1 but instance tries to read label in drive 2 and fails, marks the
tape as unavailable and then works its way through all the scratch tapes.
T
I need to use different syntax from the one of Eric, like:
select * from (select count(*) as "Number_Of_Failed" from events where
scheduled_start>current_timestamp-24 hours and status='Failed') as failed,
(select count(*) as "Number_Of_Missed" from events where
scheduled_start>current_timestam
Hi Eric,
You can combine these two queries by executing them as subqueries:
select
*
from (
select count(*) as "Number_Of_Failed" from events where
scheduled_start>current_timestamp-24 hours and status='Failed'
) failed,
(
select count(*) as "Number_Of_Missed" from events where
schedul
Something like this (name columns as desired):
select status, count(*) from events -
where scheduled_start>current_timestamp-24 hours and -
( status='Failed' or status='Missed' ) -
group by status
On 3/26/20 10:51 AM, Loon, Eric van (ITOP NS) - KLM wrote:
> Hi guys,
>
> I have two SQL
Hi guys,
I have two SQL queries:
select count(*) as "Number_Of_Failed" from events where
scheduled_start>current_timestamp-24 hours and status='Failed'
select count(*) as "Number_Of_Missed" from events where
scheduled_start>current_timestamp-24 hours and status='Missed'
Is it somehow possible
Hi Erwann,
Yes, that's indeed what I discovered too. When I issue the command q
monitorstatus status=error, the error status trigger which SPOC uses is
displayed. In my case:
Server Name Activity DateActivity NameElement Name Element
Element String Element State
