HP Reporter - Accessing Data

HP Reporter, formerly HP OpenView Reporter, captures enterprise systems management measurement data from Windows systems and many UNIX variants such as HP-UX, SunOS Solaris, IBM AIX, Tru 64 UNIX, and Linux.

For information about the performance areas that are collected by HP Reporter, see HP Perf Agent and HP Reporter Adapters.

If the HP Reporter raw data is in a Microsoft Access database, you need to set up a PC files library.

To set up a library, perform the following steps:

Log on to SAS Management Console as an unrestricted user.

To access SAS Management Console, from your Windows desktop, select StartProgramsSASSAS Management Console.
Navigate to the Data Library Manager.
Right-click Libraries and select New Library from the drop-down list. The New Library Wizard opens.

As shown in the following display, select Generic Library from the list of Resource Templates.

New Library Wizard
On the next page of the wizard, enter the name of the new library. Use the Browse button to display the list of folders from which you can select the Location that you want to use for your library.

Enter Identifying Information for the New Library
On the next page of the wizard, from the list of available servers select SASITRM.
On the next page, specify the fields as shown in the following display.

Enter Information for the Libref
- In the Libref field, enter the name by which you want to refer to the new library.
- In the Engine field, enter pcfiles.
- In the Option(s) to be appended field, enter the specifications for the server, port, and path.
  
  The following example shows how to enter these specifications.
  server="server56.na.co.com" port=9621 path="D:\Public\ReporterDatabase29Feb2008.mdb";
Note: You do not need to specify a path in the Path Specification box. The path should be entered in the Option(s) to be appended field, as shown in the preceding code fragment.
Click Next and then Finish to create the new library.