...
The WHERE section of your SQL must contain WHERE @filter so Open-AudIT knows to restrict your query to the appropriate Orgs.
SQL not containing this condition will result in the widget failing to be executed.
The SQL cannot contain WHERE @filter WHERE @filter OR. That SQL will not be executed, however WHERE @filter AND queries queries are allowed.
An example widget SQL showing devices counted per location.
...