Working with External Reports

Powertech Compliance Monitor for IBM i allows you to run Powertech Authority Broker Event Reports. You might generate this kind of report, for example, to identify all user profile switches that have occurred within a certain period of time. Authority Broker event reports include all commands that are not specifically omitted from reports (specified in Authority Broker's "Work with Report Exceptions" screen). Unlike internal assessment reports, external reports cannot be filtered in Powertech Compliance Monitor for IBM i, and there are fewer sorting options. (As such, you will notice the and tabs are not available when viewing external reports). While columns in the grid can be omitted and reordered, additional filtering to the data must be done externally after exporting the report (in a spreadsheet editor like Excel).

You must give the Compliance Monitor product profile authority to use the Authority Broker reports. On each Endpoint system where Authority Broker is installed, use the following commands to add the appropriate entries:

ADDAUTLE AUTL(POWERABRPT) USER(PLCMADM) AUT(*USE)

To generate an Authority Broker Event Report

  1. Right-click on the Consolidator and select Request Assessment.
  2. Expand the Powertech list and click on the words Powertech Authority Broker (not the check box). The Authority Broker reports appear in the window to the right.
  3. Check Powertech Authority Broker Event Report.
  4. Note the external Authority Broker report icon is purple and includes an "x" - .

  5. Click the tab.
  6. Set the Start and End date and time.
  7. Set the Report Type (Commands, Summary, etc) and the User Type (System, Switch or Intparty). In the User field, replace "*ALL" with a user profile name to specify if the report should be limited to only that user. For example, if you want to generate a report that includes only commands associated with a particular Interested Party, set User Type to *INTPARTY and for USER, replace *ALL with the user profile name. - for details, see External Reports.
  8. Configure the other settings as required and click .
  9. When the assessment is complete, select it (under Collections and Available Reports) to display the results in the Grid Report View.
  10. Now that the report has been created, you can add or remove columns from the list, reorder the grid according to the ascending or descending order of any column, and filter results, which we'll cover in the next section.