I am having trouble coming up with a SQL view for restorals. We have account 123456 and the power goes out in zone 1 and 2. the power is restored in zone 1 but not 2. I need a sql script that can show me this. Sorry I am very new on this i hope this is enough information to get some answers.
It is not enough information. What are "Zone1" and "Zone2"? What account (123456) are you referring to (User? Login? Other?) What do you mean by "restoral" (Database restore? Power restore to database server? Application specific term?)
We don't know your environment. If you can elaborate, perhaps a solution can be found.