ALERT! The community will be read-only starting on April 19, 8am Pacific as the migration begins. Read more for important details.
ALERT! The community will be read-only starting on April 19, 8am Pacific as the migration begins.Read more for important details.
Cadet 1st Class
Cadet 1st Class
589 views

Including current year and week of the year in ESM reports

Jump to solution

Hi everybody,

I need to schedule weekly reports in ESM and send them by email and, in the email subject, it must be specified the current week of the year when the report is being submitted.

Does anyone know how this can be accomplished? I've carried out several tests and it seems to be working only with a few variables like $Now, $Today, $CurrentWeek, ...

Thanks a lot in advance,

Jose

Labels (1)
0 Likes
1 Solution

Accepted Solutions
Commodore
Commodore

Velocity parameters are somewhat more limited in reports than they are for everything else.  The ArcSight Console User guide (6.11) contains some additional detail.  Page 1011 is where you'll want to start.  Page 997 contains all supported timestamp functions.

Velocity template based variables are held only in memory and, therefore, can be used only in
Rules, Filters, and Data Monitors. Velocity template based variables cannot be used in resources
like Reports, which rely on persisted data. (There is a set of velocity references specifically for use
in Reports. See "Velocity References for Reports" on page 1011 for more information.)

You Could try something like this in the "Email Subject" under the Parameters tab.

$CurrentWeek | $ReportName

 Output: 05-29-2017 | Name of Report

Here are some additional time fields available in reports...

 

$ReportName | $CurrentDateTime | $CurrentDate | $CurrentWeek | $CurrentMonth | $CurrentYear

Output: Name | 05-31-2017-16:08:40 | 05-31-2017 | 05-29-2017 | 05-2017 | 2017

Hope it helps.

------

View solution in original post

0 Likes
3 Replies
Commodore
Commodore

Velocity parameters are somewhat more limited in reports than they are for everything else.  The ArcSight Console User guide (6.11) contains some additional detail.  Page 1011 is where you'll want to start.  Page 997 contains all supported timestamp functions.

Velocity template based variables are held only in memory and, therefore, can be used only in
Rules, Filters, and Data Monitors. Velocity template based variables cannot be used in resources
like Reports, which rely on persisted data. (There is a set of velocity references specifically for use
in Reports. See "Velocity References for Reports" on page 1011 for more information.)

You Could try something like this in the "Email Subject" under the Parameters tab.

$CurrentWeek | $ReportName

 Output: 05-29-2017 | Name of Report

Here are some additional time fields available in reports...

 

$ReportName | $CurrentDateTime | $CurrentDate | $CurrentWeek | $CurrentMonth | $CurrentYear

Output: Name | 05-31-2017-16:08:40 | 05-31-2017 | 05-29-2017 | 05-2017 | 2017

Hope it helps.

------

View solution in original post

0 Likes
Cadet 1st Class
Cadet 1st Class
Hi mat053241,
0 Likes
Cadet 1st Class
Cadet 1st Class
Hi mat053241, thanks a lot for your answer and your time. I had tested them, but none fits what we need. It seems that it can't be done. As you say, Velocity parameters are somewhat more limited in reports than they are for everything else. Warm regards, Jose
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.