000018283 - How to create RSA ACE/Server custom reports in a .CSV format for import into a spreadsheet

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000018283
Applies ToUNIX (AIX, HP-UX, Solaris)
RSA ACE/Server Reports
TFS Technology's Keon Security Server (KSS) 4.5
Microsoft Excel
Microsoft Windows
Report Creation Utility
IssueHow to create RSA ACE/Server custom reports in a .CSV format for import into a spreadsheet
All custom reports made from the RSA ACE/Server are currently created using a '|' (pipe), the Table delimiter. It is possible to reconfigure a spreadsheet application such as Microsoft Excel to use this character when importing tables (with Excel you need only rename the file to have a .XLS extension). However, most spreadsheets and other applications, including TFS Technology's Keon Security Server, are able to import from a CSV (Comma Separated Values) file. These will have a .CSV file extension and use the ',' (comma) as the delimiter.
ResolutionCreate a new report, and then edit the mytest.p file created, as follows:

Find the lines:
        
IF rpt-format = 2 THEN DO:
dir-name = dir-name + "/" + "mytest" + ".xls".
OUTPUT TO VALUE(dir-name).
PUT "LocalDate| LocalTOD| ShortMessage| UserName| Login| AffectedUserName| TokenSerialNum| ClientName| GroupName| SiteName| GMTDate| GMTOD" SKIP.
        
and change the ".xls" to ".csv", to look like this:
        
IF rpt-format = 2 THEN DO:
dir-name = dir-name + "/" + "mytest" + ".csv".
OUTPUT TO VALUE(dir-name).
PUT "LocalDate, LocalTOD, ShortMessage, UserName, Login, AffectedUserName, TokenSerialNum, ClientName, GroupName, SiteName, GMTDate, GMTOD" SKIP.
        
Save the file. Open logpipe.i with an editor, and replace all instances of "|" (pipe) with ","(comma).

Run the report again. This will create the required .CSV file. This procedure only works with custom reports.
Legacy Article ID6.0.3071187.2894864

Attachments

    Outcomes