SQL Server Query Plans & Offline databases I recently asked a question about exporting query plans (here Export Query Plans) and got some great answers.

However, I did run into one issue, during the process of interrogating SQL Server to obtain the plans, the process fails if there are any offline databases.  Simple question, to which I suspect the answer is complex.  How do I have the interrogation ignore the offline databases?

Thank you in advance for your assistance!
Did you try:

get-sqldatabase -ServerInstance yourserver | Where-Object status -eq 'Normal'