SQL command

[sel]

Hi there,

I am currently using the following command to get the output for my TSM backup failure:

q event * * EXceptionsonly=yes begind=-1 endd=today begint=now endt=now

I have TSM operations center and planning to utilise the reporting.

My question: is there any SQL statement which i can get similar output daily?

 

[marclant]

You can try this:

select * from events where node_name is not null and status <> 'Completed' and scheduled_start>current_timestamp-24 hours

You can find more queries here: http://thobias.org/tsm/sql/ They are not always an exact fit, but there are plenty of examples that you can customize them to fit your needs.

 

[Andrew21210]

You could use this

q event * * begintime=now-24 enddate=today exceptionsonly=yes

 

[marclant]

You could use this

q event * * begintime=now-24 enddate=today exceptionsonly=yes

Not with the Custom Reports in the Operation Center, which is what the OP is trying to do.

 

[Andrew21210]

Not with the Custom Reports in the Operation Center, which is what the OP is trying to do.

Ah, ok. I'm not using the OC yet so didn't realize.

 

[sel]

You can try this:

select * from events where node_name is not null and status <> 'Completed' and scheduled_start>current_timestamp-24 hours

You can find more queries here: http://thobias.org/tsm/sql/ They are not always an exact fit, but there are plenty of examples that you can customize them to fit your needs.

Thank you Marclant. Like you mentioned, it's not an exact fit but it was helpful. Thanks again