Child pages
  • Widgets

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


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.