Including current year and week of the year in ESM reports

[joseas1]

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

[mat053241 · Accepted solution]

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.

[joseas1]

Hi mat053241,

[joseas1]

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