07-08-2013 07:34 AM
Hello all,
We would like to create a custom OPS report in a weekly basis with all the drives that were in a down state during that week.
Thank you in regards.
Solved! Go to Solution.
07-08-2013 11:49 AM
Try this:
07-08-2013 11:27 AM
Do you have alerts set up for the condition you want to report on? I don't think OpsCenter keeps track of drive status history like that.
07-08-2013 11:49 AM
Try this:
07-09-2013 01:41 AM
Dear MIles,
Thank you very much for your response, when we try to run the your sql query we get the following error:
"The report did not return any data"
Any ideas?
07-10-2013 12:34 AM
Hello Miles,
I have tried your query to another environment and also we get the "The report did not return any data".
Although we have drives in down state.
I think somethink is wrong with the WHERE ap.name = 'Drive Down' .
Thank in regards.
07-10-2013 10:27 AM
Sorry about the delay in my responce. You will need to have the alerts enabled for this query to work. It pulls the history of any drive down alerts. As far as the 'Drive Down' You will need to change that text to whatever the name of your Downed Drive alert is. Sorry for the lack of clarification.
07-11-2013 01:48 AM
For one more time Miles is right!!!!!We had to change the 'Drive Down' to 'Drive is Down' Thank you very much for your script and your help!!!!!!!