Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Highlighted
Super Contributor.. ftavares Super Contributor..
Super Contributor..
266 views

Change Report Returned Values

Jump to solution

Hi all,

today we have a scheduled Report that runs a SQL query to return some specific data in our Logger.

Now, we have a request to translate some specific returned values to others more user-friendly. Our goal is clarify our customer's understanding about report's content.

So, we have tried to change the QUERY object appending some CASE and WHEN tags, trying to modify our returned value with SQL statements, but, every SQL combination that we have used, did not pass in ArcSight Logger's SQL Validation tool in Logger's Web Interface. It says that SQL Query is wrong every time.

So, we need to accomplish this result, what's the best approach to modify our returned data and deliver our report with those modifications to our customer?

Labels (1)
0 Likes
Reply
1 Solution

Accepted Solutions
Super Contributor.. ftavares Super Contributor..
Super Contributor..

Re: Change Report Returned Values

Jump to solution

Updating this:

the Logger mentioned was the oldest still playing in our farm. The problem was solved after apllying its version update. The construction of report worked well using regular SQL sintax.

Regards,

Fabiano.

View solution in original post

0 Likes
Reply
1 Reply
Super Contributor.. ftavares Super Contributor..
Super Contributor..

Re: Change Report Returned Values

Jump to solution

Updating this:

the Logger mentioned was the oldest still playing in our farm. The problem was solved after apllying its version update. The construction of report worked well using regular SQL sintax.

Regards,

Fabiano.

View solution in original post

0 Likes
Reply
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.