Anonymous_User Absent Member.
Absent Member.
492 views

Can Sentinel RD reports be in CSV format instead of PDF


Hi,

I am working with Sentinel RD and generating custom reports using
iReport. I was wondering if I can generate a custom report where the
output is in CSV format instead of PDF and can be scheduled in the same
way as the PDF are.

What do I need to do to achieve this?


--
ankurrane
------------------------------------------------------------------------
ankurrane's Profile: http://forums.novell.com/member.php?userid=92392
View this thread: http://forums.novell.com/showthread.php?t=428324

0 Likes
7 Replies
Anonymous_User Absent Member.
Absent Member.

Re: Can Sentinel RD reports be in CSV format instead of PDF

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not that I know of, though you could easily setup your own Jasper Server
(free, Java-based, easy enough that I have done it) and point it to your
PostgreSQL instance for RD then create any output you like. Jasper has
the ability to do multiple types (CSV, XML, HTML, PDF) so with its full
functionality (vs. the simplified UI given to you in Sentinel RD) you can
do this. The downside is this will require setting up a Jasper instance
in Tomcat somewhere.

Good luck.






On 12/16/2010 03:36 PM, ankurrane wrote:
>
> Hi,
>
> I am working with Sentinel RD and generating custom reports using
> iReport. I was wondering if I can generate a custom report where the
> output is in CSV format instead of PDF and can be scheduled in the same
> way as the PDF are.
>
> What do I need to do to achieve this?
>
>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.15 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQIcBAEBAgAGBQJNC/TcAAoJEF+XTK08PnB5ATYQAIXJGciWWRPciVmJ/md56+uz
afWzmAOyXbgwEdNWDOw0AWmY3fLfz+OMSIfuQ27jERCf3rGqt8amPTymzS5jtz8m
KX0JdAfThqB3tq9kbw1VdHeKi4mTOnPWoERse2i1a9nBD2l/+n0mzdvHrEvWrcIm
0v0xqqGaC/gfaiw2NMpjQIKchv+MkrRdy4o2Z9HvV5Aw4qHjqd+RAKQBJeNN32jD
6FxujXN87dAAoe45+c2fd/l1vazOjpLXfbnJipgaQbdWnDIsM/l3Tj04J3ZoRK/9
YaO3HOs5Xdc8lqBhq2i9JFzuq+yNX8NFNCC7Umv9Cff+sSEg1PC7TRgG20PLuNg1
5Ol4HD2Pwzg5DDN7tId2h+10V5lQphSHUkgcbljcPHsKiZXg2g+aKXlsWIxZ631N
NHdhqeO5uEw59J8K/l4Fb7Pm7fglW34T0fnwiLbinPiz9Y2Vd77J0n/w8pvinwk4
P15EWN0AdjbrLBH3vGzyX6rJjxfLQs1p0itrSqWwFKclqiTyNxbv/CcPk4M+GdKQ
UIzFCbn2YxhiYrEtUnX9tq0mUJpo9EVwVhuvK8CE2oKnKm/QcdqWUjO/fSnYPuHZ
jeZDXS9x4L8bJEk9WGDPrgKDD6hQw0uzusWn7RcvHw/eC46HAuA4+VnFTQkgrsCz
rGSAsb/wu6JAlR68lH9l
=vMKy
-----END PGP SIGNATURE-----
0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Can Sentinel RD reports be in CSV format instead of PDF


Hello,

Not quite yet, but we've added this feature in SLM 1.1 and that code
will migrate back to Sentinel SIEM, I believe when Sentinel 7 ships
(mid-2011?). If your data goes through SLM before it gets to RD, you can
of course do it there.


--
DCorlette
------------------------------------------------------------------------
DCorlette's Profile: http://forums.novell.com/member.php?userid=4437
View this thread: http://forums.novell.com/showthread.php?t=428324

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Can Sentinel RD reports be in CSV format instead of PDF


Just found this topic and have a question:

How can i export as CSV on SLM 1.1 because our developer didn't found
how. Can you give me some tips for it?


--
kamujin
------------------------------------------------------------------------
kamujin's Profile: http://forums.novell.com/member.php?userid=58035
View this thread: http://forums.novell.com/showthread.php?t=428324

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Can Sentinel RD reports be in CSV format instead of PDF


I'm traveling right now and don't have access to an SLM system, but IIRC
the demos I saw you specify the output format when you schedule and/or
run a report. If you don't find it, let me know and I'll check when I
can get access.


--
DCorlette
------------------------------------------------------------------------
DCorlette's Profile: http://forums.novell.com/member.php?userid=4437
View this thread: http://forums.novell.com/showthread.php?t=428324

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Can Sentinel RD reports be in CSV format instead of PDF


Back again,

At least for the reports i checked none have an alternative output
besides pdf.
Thanks in advance for any help you can provide.


--
kamujin
------------------------------------------------------------------------
kamujin's Profile: http://forums.novell.com/member.php?userid=58035
View this thread: http://forums.novell.com/showthread.php?t=428324

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Can Sentinel RD reports be in CSV format instead of PDF


Here is how to output report results in CSV format in SLM 1.1 (or
later):

STEP 1: Go to the $ESEC_CONFIG_HOME directory on your SLM server (It
will be something like: /etc/opt/novell/sentinel_log_mgr/config).
STEP 2: Open the file
"obj-component.JasperReportingComponent.properties" for editing.
STEP 3: Specify the following fields/values in that properties file:

reporting.csv.enable=true
reporting.csv.email=true
reporting.csv.outputdir=/opt/mycsvreportresults

STEP 4: Save the file.
STEP 5: I *think* you have to restart the SLM server after making
changes to any of these properties.

Some things to take note of:

NOTE 1: You can specify any directory (that the novell user has
permission to write to) in the "reporting.csv.outputdir" setting. This
will cause a .csv file to be created in that directory whenever a report
is run.

NOTE 2: If you set the "reporting.csv.email" setting to true, the .csv
report results will be included with any report results that are
emailed.

NOTE 3: The CSV results will include all of the report information in
the the .csv... including the header information any output from any
subreports. That additional information may not always be desireable in
the CSV results, so if you find the format of the .csv to not be what
you need or too difficult to work with, you might want to consider
creating a new report where there results/output are more optimized for
.csv output (may without any header or subreport information).

NOTE 4: Regardless of whether csv output is enabled or not, the
standard PDFs results will always be generated.

NOTE 5: The CSV results are not accessible through the GUI, but instead
are accessible by looking in the directory you specify via the
"reporting.csv.outputdir" property ... or via any report result emails
if the "reporting.csv.email" property is set to true.

NOTE 6: Just FYI: That "reporting.pdf.outputdir" property that you will
also see in the "obj-component.JasperReportingComponent.properties" file
is if you want to have the PDF results to be placed in a directory on
the server. (PDF results will always be accessible via the GUI
regardless of this setting.)


--
bweiner12345
------------------------------------------------------------------------
bweiner12345's Profile: http://forums.novell.com/member.php?userid=55576
View this thread: http://forums.novell.com/showthread.php?t=428324

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Can Sentinel RD reports be in CSV format instead of PDF


Hello bweiner12345

couldn't ask for anything better. Worked as planned.

Thank you


--
kamujin
------------------------------------------------------------------------
kamujin's Profile: http://forums.novell.com/member.php?userid=58035
View this thread: http://forums.novell.com/showthread.php?t=428324

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.