References > References > Filter syntax reference and navigation > Using SWQL/SQL with web-based reports

Using SWQL/SQL with web-based reports

In addition to the guidelines provided above, if you are using SWQL or SQL to define a datasource for a web-based report, you can also use the following time-related properties and associated macros.
Note: Web-based reports do not allow the use of variables that are created by preceding a property or database column name with a dollar sign ($) and an open brace ({) and then following it with a close brace (}), as in ${Node.LastBoot}.

Property

Description

Macro

FromTime Beginning of valid time window for a resource, in local server time. ${FromTime}
ToTime End of valid time window for a resource, in local server time. ${ToTime}
FromTimeUTC Beginning of valid time window for a resource, in UTC time. ${FromTimeUTC}
ToTimeUTC End of valid time window for a resource, in UTC time. ${ToTimeUTC}

The time macro is mandatory in the SQL data source for the Custom Chart resource. Without using the time macro, the chart will not be displayed. You can add this macro as a comment in the following ways:

  • /*${FromTime}*/
  • --${FromTime}