Posts

LBI Auditing Part 3c – Overview of Service Now Admin Audit Reports

In LBI Auditing Part 3b we went over Reporting Service Admin Audit Reports. In this article we will go over the Service Now (SN) portion of reports.

 

SN01.List of Alerts:

This report allows you to view what user(s) and or group(s) have access to what SN alert/report.

Column NameDescription
Alert IDAssigned alert ID number.
Alert NameAlert name created by owner.
OwnerOwner who published alert.
Creation DateDate in which the alert was created.
Last Modified/RenderedDate when the alert was last modified.
Shared ToAlert shared access.
RolesRoles that grant access to the alert.
Security SpecifyType of access (public, user, or group).

 

SN02. User/Group Access on SN Alerts:

This is a security report showing user/group access to specific alerts.

Column NameDescription
User/GroupName of user or group.
SpecifyAccess type (user or group).
RolesRoles that grant access to the alert.
Alert IDAssigned alert ID number.
Last Modified/RenderedDate when the alert was last modified.
AlertAlert name created by owner.
Last RenderedDate when the alert was last modified.

 

SN03.Top Rendered Alerts and their Top Viewers:

This report shows statistics on your most viewed alerts and top viewers.

Column NameDescription
Top AlertAlerts with most views starting at the top
Alert NameAlert name created by owner.
No. of ViewsTotal number of alert views.
Alert IDAssigned alert ID number.
GroupGroup being notified
OwnerOwner who published alert.
RankTop ranked viewers of the specific alert.
ViewerUser viewing report.
RolesRoles that grant access to the alert.
User ViewsTotal number of views per user.

 

For more details on these admin audit reports, check out Part 3a “Overview of Framework Service Admin Audit Reports” and Part 3b “Overview of Reporting Service Admin Audit Reports”.

LBI Auditing Part 3b – Overview of Reporting Service Admin Audit Reports

In LBI Auditing Part 3a we went over Framework Service Admin Audit Reports. In this article we will go over the Reporting Service (RS) portion of reports.

 

RS01.RS Reports:

This report shows all your reports in LBI along with the below details.

Column NameDescription
Report IDAssigned ID when report was created.
Report NameReport Name (may differ from given dashboard name).
OwnerOwner who published report.
UserUser access to the report.
Date CreatedReport creation date.

 

RS02. User Access on Reports:

This is a security report showing user/group access to specific reports.

Column NameDescription
UserUser with LBI access.
Report IDAssigned ID when report was created.
Report NameReport Name (may differ from given dashboard name).

 

RS03.Top Viewed Reports in RS:

This report shows statistics on your most viewed reports, what users viewing them the most and total views per user.

Column NameDescription
Report IDAssigned ID when report was created.
Report NameReport Name (may differ from given dashboard name).
Access ViewerTop Viewer of a specific report
Number of ViewsTotal number of views by a specific user

 

RS04.Top Scheduled/Exported Reports

This report shows statistics on your most scheduled and exported reports.

Column NameDescription
Report IDAssigned ID when report was created.
Report NameReport Name (may differ from given dashboard name).
FrequencyTotal number of time a report has been scheduled/exported.

 

 

For more details on these admin audit reports, check out Part 3c “Overview of Service Now Admin Audit Reports” (coming soon) and/or Part 3a “Overview of Reporting Service Admin Audit Reports”.

 

 

LBI Auditing Part 2 – Setting up Admin Audit Reports

In LBI Auditing Part 1, we went over enabling dashboard auditing. This time we will go over how to set up special Admin Audit Reports to view more information about LBI activity via Framework/Reporting Services and Smart Notifications. These reports are for 10.6.0.0 and later but check with Infor if they are supported for older versions.

 

  1. Login to Infor Support Portal and go to the LBI Product Download page.
  2. Download the BI-Samples.zip file and unzip to a temporary location
  3. Locate Infor-LBI-Admin-Reports-SolutionPack.zip
  4. Login into LBI and go to Tools dashboard
  5. Click the Deployment Utility link and a Deployment Utility window will pop-up
  6. Browse for the solution pack mentioned in Step 3, select it and then click Import
    • NOTE: Framework Services content is delivered in a folder called fs; Reporting Services in a folder called rs; Smart Notification in a folder called sn.
    • No tab will be displayed for a service if the solution package does not contain a solution for that service or if the service is not registered/installed.
  7. When the import is completed, a screen is displayed with a tab for each imported package, click on a tab to view the import and additional details.
  8. If the import fails for any reason, try and correct the issue, verify zip file is not corrupt, re-import.
    • NOTE: Remove any applications directories where the import was successful to avoid duplicate content.

 

Make sure to check out Part 3a – “Overview of Framework Service Admin Audit Reports”  (coming soon) to get more insight into these reports.