Accessing RightNow Audit logs migrated to ADW in Fusion Service
in Fusion RAMP
This discussion outlines the steps required to access B2C (RightNow) Incident Audit Logs migrated to ADW within Fusion Service.
Assumption:
After migration, the RightNow Incident Reference Number is stored in field (SrNumber) in the Fusion Service Request (SR) object.
Make sure the below tables are migrated and available in ADW:
- Accounts
- Account Groups
- Audit Logs
- Channel Types
- Incident Statuses
- Queues
- Sources
- Source Reference
- Transaction Type
- Incident SR Reference Number Mapping
Create ADW View and Expose as REST API
- Create a database view using the required SQL logic to join and structure audit log data.
- Ensure the view includes the reference number (
0