To use SQL Variables, wrap the Variable Name with $ (Dollar Sign). For example, $MY_VARIABLE$.
Wrapping apostrophes around SQL Variables are not required.
SQL Variables (Optional)
Variable Name
Variable Type
Variable Value
Table Columns
Column Shows
Use Values Of This Field Column As
SQL Query
Preview SQL Statement With Variables
Test SQL
To use SQL Variables, wrap the Variable Name with $ (Dollar Sign). For example, $MY_VARIABLE$.
Wrapping apostrophes around SQL Variables are not required.
SQL Variables (Optional)
Variable Name
Variable Type
Variable Value
Table Columns
Column Heading
Column Shows
Display As Group Header
Column Alignment
%DATE%
Date (E.g. 25 Feb 2021)
%DATE_TIME%
Date/Time (E.g. 25 Feb 2021 2:55)
%DAY%
Day of Month (E.g. 25)
%FULL_DATE%
Full Date/Time (E.g. Thursday, 25 February 2021)
%HOUR%
Hour (E.g. 2)
%LAST_OF_MONTH%
Last Day of Month (E.g. 28)
%LAST_OF_PREV_MONTH%
Previous Month Last Day (E.g. 31)
%MINUTE%
Minute (E.g. 55)
%MONTH%
Full Month (E.g. February)
%MONTH_RANGE%
Report Range for First to Last Day of Month
%MONTH_SHORT%
Short Month (E.g. Feb)
%PREV_MONTH%
Previous Month (E.g. January)
%PREV_MONTH_RANGE%
Report Range for First to Last Day of Previous Month
%PREV_MONTH_SHORT%
Previous Short Month (E.g. Jan)
%RANGE%
Report Range (E.g. Past 24 Hours)
%RANGE_WITH_DATE%
Report Range for Specific Dates
%RANGE_WITH_DATETIME%
Report Range for Specific Dates with Times
%TIME%
Time (E.g. 2:55)
%WEEKDAY%
Full Weekday (E.g. Thursday)
%WEEKDAY_SHORT%
Short Weekday (E.g. Thu)
%YEAR%
Year (E.g. 2021)
%YEAR_OF_PREV_MONTH%
Previous Month Year (E.g. 2021)
%CLIENT_NAME%
%COMPANY_NAME%
Change Logs
Column Heading
Column Shows
Filter
Note: Date/Time is always shown as the first column for this report
Note: Results are grouped by Product and Node Name is always shown as the first column in this report
Cross-Reference Data
Column Heading
Column Shows
Filter
Note: Date/Time is always shown as the first column for this report
Note: Results are grouped by Product and Node Name is always shown as the first column in this report
Compliance Data
Column Heading
Column Shows
Filter
Note: Date/Time is always shown as the first column for this report
Note: Results are grouped by Product and Node Name is always shown as the first column in this report
Alert Data
Column Heading
Column Shows
Filter
Note: Date/Time is always shown as the first column for this report
Note: Results are grouped by Product and Node Name is always shown as the first column in this report
Exchange Mailbox Data
Column Heading
Column Shows
Filter
Note: Date/Time is always shown as the first column for this report
Note: Results are grouped by Product and Node Name is always shown as the first column in this report
File Audit Data
Column Heading
Column Shows
Filter
Note: Date/Time is always shown as the first column for this report
Note: Results are grouped by Product and Node Name is always shown as the first column in this report
Licensed Nodes Data
Column Heading
Column Shows
Filter
Note: Date/Time is always shown as the first column for this report
Note: Results are grouped by Product and Node Name is always shown as the first column in this report
Event Data
Column Heading
Column Shows
Filter
Note: Date/Time is always shown as the first column for this report
Note: Results are grouped by Product and Node Name is always shown as the first column in this report
Instances
Instance
Performance Counters
Label
Instance
Scale
Performance Counters
Column Heading
Column Shows
Filter
Performance Counters
Column Heading
Column Shows
Algorithm
Range
Performance Counter
Column Heading
Column Shows
Function
Filter
Apply To The Following Nodes
Node
Monitoring Group
SuperConsole
▼ ▼
Y-Axis Scale:
Threshold Lines:
in
Top
The following section adds trend analysis graphs (following the same order as the table):
▼
▼
▼
Y-Axis Scale:
Threshold Lines:
▼ ▼
Y-Axis Scale:
Threshold Lines:
Report Style Gallery:
▼
Report Sequence In This Report Group
Simply drag and drop to change the order of the report sequence
Definition
Prepend Page Break
Sections In This Report Layout
Report Layout Type
Reports In Section
(The link will be appended to the bottom of the email body automatically)
▼
▼
Report Or Report Group For This Automator
Report or Report Group
Schedule
Schedule
Override The Following Variables (Optional)
Variable Name
Default
Override To
Edit Headers
Edit Footers
Report Style Gallery:
This built-in variable substitutes the current date in the following format:
DAY MONTH_SHORT YEAR
E.g. 5 Oct 2011
This built-in variable substitutes the current date and time in the following format:
DAY MONTH_SHORT YEAR 24-HOUR:MINUTE
E.g. 5 Oct 2011 13:52
This built-in variable substitutes the current day of the month:
DAY
E.g. 31
This built-in variable substitutes the current date in the following format:
WEEKDAY, DAY MONTH_SHORT YEAR
E.g. Wed, 5 Oct 2011
This built-in variable substitutes the 24-hour format of the current hour:
HOUR
E.g. 16
This built-in variable substitutes the last day of the month:
1 MONTH_SHORT - LAST_OF_MONTH MONTH_SHORT
E.g. 1 Feb - 28 Feb
This built-in variable substitutes the last day of the previous month:
This built-in variable substitutes the minutes of the current time, with leading zeros:
MINUTE
E.g. 23
This built-in variable substitutes the current month in the following format:
MONTH
E.g. October
This built-in variable substitutes the start and end of the current month in the following format:
MONTH_RANGE
E.g. 1 Feb 2012 - 29 Feb 2012
This built-in variable substitutes the current month in the following format:
MONTH_SHORT
E.g. Oct
This built-in variable substitutes the previous month in the following format:
PREV_MONTH
E.g. January
This built-in variable substitutes the start and end of the previous month in the following format:
PREV_MONTH_RANGE
E.g. 1 Jan 2012 - 31 Jan 2012
This built-in variable substitutes the previous month in the following format:
PREV_MONTH_SHORT
E.g. Jan
This built-in variable substitutes selected range in Automator, or when previewing Reports:
RANGE
E.g. Past 6 Months
This built-in variable substitutes selected range in Automator, or when previewing Reports:
RANGE
E.g. Past 6 Months as of Thu, 26 Jan 2012
This built-in variable substitutes selected range in Automator, or when previewing Reports:
RANGE
E.g. Past 6 Months as of Thu, 26 Jan 2012 12:00 AM
This built-in variable substitutes the current time in the following format:
24-HOUR:MINUTE
E.g. 13:52
This built-in variable substitutes the current weekday in the following format:
WEEKDAY
E.g. Wednesday
This built-in variable substitutes the current weekday in the following format:
WEEKDAY_SHORT
E.g. Wed
This built-in variable substitutes the current year:
YEAR
E.g. 2011
This built-in variable substitutes the previous month in the following format:
PREV_MONTH_SHORT YEAR_OF_PREV_MONTH - MONTH_SHORT YEAR
E.g. Dec 2011 - Jan 2012
Test Email Settings
This Import/Export facility allows you to backup and restore your Argent Reports definitions for safekeeping, or import report definitions from another instance of Argent Reports
Exporting Definitions
Choose one or more reports to export. The exported file is an XML file containing the selected Argent Reports definitions
Export Definitions
Importing Definitions
During an import, you will be prompted to 'overwrite' or 'skip' the definition, if it already exists