This is for SQL 2008. I've created a policy to check the recovery model of my database. I had also created a filter that limited the policy to online user databases only.
I'm now trying to exclude any databases that are being log shipped to, one in particular is in StandBy. I created a new expression in the condition where @Status != "StandBy". This won't work as the actual @Status is "Normal, Standby, Shutdown". Now I'm trying to use NOT IN but having no luck.
I keep getting "Operator 'NOT IN' must have a value as its left operand and its right operand must be an Array."
Any help in how to exclude a Database that is in StandBy mode or being log shipped to?