7.8 Publishing Crystal Report Templates

Many report templates have been created by Novell for use in the Analysis and Advisor tabs of the Sentinel Control Center. The most recent reports can be downloaded from the Sentinel 6 content Web pages.

The core set of Sentinel reports are distributed in the Sentinel Core Solution Pack.

Use any of the following methods to add reports to the system:

IMPORTANT:To run any Top 10 reports, aggregation must be enabled and the EventFileRedirectService in the DAS_Binary.xml must be set to ON. This is already configured in a default Sentinel installation. For information on how to enable aggregation, see the Report Data Configuration section of Admin in the Sentinel 6.1 User Guide.

7.8.1 Using the Solution Manager to Publish Report Templates

If the Web server and Crystal Reports Server are configured properly, you can use the Solution Manager to directly publish the reports included in a Solution Pack or Collector Pack to the Crystal Reports Server. To configure the system, you must download the Sentinel Core Solution Pack, available in the Solution Packs tab at Sentinel 6.1 Content Web site.

The Sentinel Core Solution Pack includes auxiliary files that must be applied to both the Web server and the Crystal Reports server. These auxiliary files are available in the Solution Manager after you import the Core Solution Pack. When you select the Global Setup control, the auxiliary file attachments are available in the lower right corner of the screen.

Figure 7-1 Core Solution Pack in Solution Manager Showing Crystal Auxiliary Files

7.8.2 Using the Crystal Publishing Wizard to Publish Report Templates

Sentinel reports are now distributed through Solution Packs, but the method in this section can be used to publish report templates that are from a source other than a Solution Pack.

NOTE:If you want to publish your report templates again, delete your previous import of the report templates.

  1. Click Start > Programs > BusinessObjects > Crystal Reports Server > Publishing Wizard, then click Next and log in.

    System should be the hostname of the machine where Crystal is installed, and Authentication should be Enterprise. User Name can be Administrator.

  2. For security reasons, you should create a new user instead of using Administrator. Specify your password and click Next.

    Publishing reports as an Administrator user allows all users to access the reports.

  3. Click Add Folder.

  4. (Optional) Select Include Subfolders.

  5. Navigate to the location of the report templates. Click OK, then click Next.

  6. In the Specify Location window, click New Folder at the upper right corner and create a folder called SentinelReports if it does not exist already. Click Next.

  7. Select Duplicate the folder hierarchy, then click the down-arrow and select <include none>.

  8. Click Next.

  9. In the Confirm Location window, click Next.

  10. In the Specify Categories window, specify a category name (for example, sentinel), select the name, then click the + button.

  11. Click Next.

    After you click Next, only the first report displays in the category.

  12. In the Specify Schedule window, ensure that Let users update the object is selected, then click Next.

  13. In the Specify Repository Refresh window, click Enable All to enable repository refresh, then click Next.

  14. In the Specify Keep Saved Data window, click Enable All to keep saved data when publishing reports, then click Next.

  15. In the Change Defaults Values window, ensure that Publish reports without modifying properties is selected, then click Next.

  16. Click Next to add your objects.

    A published list displays.

  17. Click Finish.

When the Sentinel templates for Crystal Reports are published to Crystal Reports Server, the templates must reside within the SentinelReports directory, or they are not displayed in the Sentinel Control Center.

7.8.3 Using the Central Management Console to Publish Report Templates

Sentinel reports are now distributed through Solution Packs, but the method in this section can be used to publish report templates that are from a source other than a Solution Pack.

  1. Open a Web browser and provide the following URL:

    http://<hostname_or_IP_of_web_server>/businessobjects/enterprise115/WebTools/adminlaunch

  2. Click Central Management Console.

  3. Log in to your Crystal Reports Server.

  4. In the Organize pane, click Folders.

  5. On the upper right corner, click New Folder.

  6. Create a SentinelReports folder (if it does not exist already), then click OK.

    Ensure that the folder name is SentinelReports.

  7. Click SentinelReports.

  8. Click Subfolders and create subfolders if required. If you are manually adding the Sentinel core reports, create the following subfolders:

    • Advisor_Vulnerability

    • Dashboards

    • Incident Management

    • Internal Events

    • Security Events

    • Top 10

  9. Click Home > Objects > New Object.

  10. On left side of the page, select Report.

  11. Click Browse and browse to the location of the report templates you want to add. Pick a folder and select a report.

  12. Select SentinelReports, then click Show Subfolders.

  13. Select the appropriate folder for the report, then click Show Subfolders.

  14. Click Submit.

  15. To add the remaining reports, repeat Step 9 through Step 14 until all reports have been added.

7.8.4 Setting a Named User Account

The license key supplied with Crystal Reports Server is a Named User account key. The Guest account must be changed from Concurrent User to Named User.

  1. On the Windows desktop, click Start > Programs > BusinessObjects > Crystal Reports Server > .NET Administration Launchpad.

  2. Click Central Management Console.

    The System Name should be your host computer name. The Authentication Type should be Enterprise.

  3. Specify Administrator as the User Name. Specify your password (by default, this is blank).

  4. Click Log On. In the Organize pane, click Users.

  5. Click Guest.

  6. Change the connection type from Concurrent User to Named User.

    IMPORTANT:You should use the Named User License account to generate unlimited reports.

  7. Click Update.

7.8.5 Configuring Report Permissions and Testing Connectivity

Configuring Permissions

You use the .NET Administration Launchpad to configure the permissions to allow you to view and modify reports on demand.

  1. On the Windows desktop, click Start > Programs > BusinessObjects > Crystal Reports Server > .NET Administration Launchpad.

    If you see an HTTP 404- File or Directory not found error when you launch the .NET Administration Launchpad, see http://support.microsoft.com/kb/315122 for resolution.

  2. Click Central Management Console.

    The System Name should be your host computer name. The Authentication Type should be Enterprise.

  3. Specify Administrator as the User Name. Specify your password (by default, this is blank).

  4. Click Log On. In the Organize pane, click Folders.

  5. Click SentinelReports, then select All.

  6. Click Rights.

  7. From Access Level, select View on Demand.

  8. Click Update.

Testing the Web Server Connection to the Sentinel Database

  1. On your Windows desktop, click Start > Programs > BusinessObjects > Crystal Reports Server > .NET Administration Launchpad.

  2. Click Central Management Console.

  3. Specify Administrator as the User Name. Specify your password (by default, this is blank).

  4. Click Log On.

  5. Navigate to Folders > SentinelReports > Internal Events.

  6. Select Column Display Details, then click Preview.

  7. Depending on your system, login as esecrpt or as the Sentinel Report User.

  8. From the Sort field drop-down menu, select Tag.

  9. Click OK to display a report.

Testing Connectivity to the Web Server

  1. Go to another machine that is on the same network as your Web server.

  2. Open a Web browser and provide the following URL:

    http://<hostname_or_IP_of_web_server>/businessobjects/enterprise115/WebTools/adminlaunch/default.aspx

You should see a Crystal BusinessObjects Web page.

7.8.6 Disabling the Sentinel Top 10 Reports

By default, the Sentinel Top 10 Reports are enabled. If you do not want to use these reports, you can reduce database storage and CPU usage by disabling them.

To disable to the Sentinel Top 10 Reports, you must turn off aggregation and disable EventFileRedirectService.

Turning Off Aggregation

  1. Log in to Sentinel Control Center.

  2. Click Admin, then click Reporting Data.

  3. Disable the following summaries:

    • EventDestSummary

    • EventSevSummary

    • EventSrcSummary

  4. In the Status column, click Active until it changes to InActive.

Disabling EventFileRedirectService

  1. At your DAS machine, using the text editor, open the following file:

    For UNIX:  

    $ESEC_HOME/config/das_binary.xml

    For Windows:  

    %ESEC_HOME%\config\das_binary.xml

  2. For EventFileRedirectService, change the status to off:

    <property name="status">off</property>

  3. Restart the DAS component:

    On Windows: Use the Service Manager to stop and start the Sentinel service

7.8.7 Configuring the Sentinel Control Center to Integrate with Crystal Reports Server

You can view Crystal Reports from Sentinel Control Center by integrating Crystal Reports Server to the Sentinel Control Center

To enable Sentinel Control Center integration with Crystal Reports Server, perform the following instructions:

NOTE:This configuration must be performed only after Crystal Reports Server has been installed and Crystal Reports have been published to it.

  1. Log in to Sentinel Control Center as a user who has privileges to access the Admin tab.

  2. In the Admin tab, select Crystal Report Configuration.

  3. In the Analysis URL field, provide the following:

    http://<hostname_or_IP_of_web_server>/GetReports.asp?APS=<hostname>&user=Guest&password=&tab=Analysis

    <hostname_or_IP_of_web_server> must be replaced with the IP address or hostname of Crystal Reports Server. The URL does not work as expected if the Automated Process Scheduler (APS) is set to the IP address. It must be the host name of Crystal Reports Server.

  4. Click Refresh, which is next to the Analysis URL field.

  5. If you have Advisor installed, provide the following in the Advisor URL field:

    http://<hostname_or_IP_of_web_server>/GetReports.asp?APS=<hostname>&user=Guest&password=&tab=Advisor

    <hostname_or_IP_of_web_server> must be replaced with the IP address or hostname of Crystal Reports Server. The URL above does not work as expected if the APS is set to the IP address. It must be the host name of Crystal Reports Server.

  6. Click Refresh, which is next to the Advisor URL field, then click Save.

  7. Log out and log in to the Sentinel Control Center. The Crystal Report trees in the Analysis tab and Advisor tab (if Advisor is installed) are displayed in the Navigator window.