Using SWQL/SQL with web-based reports
This topic applies to all SolarWinds Platform Self-Hosted products except for the following products:
ETS — LA — WPM
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.
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}