| Anchor | ||||
|---|---|---|---|---|
|
| Table of Contents | ||
|---|---|---|
|
Overview
Yellowfin has a complete audit facility for tracking which users are accessing data from your data sources. Each time a report is run a unique instance of that report definition and timestamp is saved.
...
EventTypeCode | EventCode | Description | SessionId | IpSource | UnitId | ReferenceId | Data |
|---|---|---|---|---|---|---|---|
EXPORT | EXPORTCATEGORY | Export category | Yes | IpPerson | 1 | ContentManagementId | Category, SubCategory, LoginAccess, ShortDescription |
EXPORT | EXPORTDASHBOARD | Export dashboard | Yes | IpPerson | 1 | Tab Id | GroupId (Tab Id), ShortDescription |
EXPORT | EXPORTREPORT | Export report | Yes | IpPerson | 1 | ReportId | ReportId, ReportName |
EXPORT | EXPORTSOURCE | Export data source | Yes | IpPerson | 1 | SourceId | SourceId, SourceName |
EXPORT | EXPORTVIEW | Export view | Yes | IpPerson | 1 | ViewId | ViewId, ViewDescription |
GROUP | CREATEGROUP | Group created | Yes | IpPerson | 1 | GroupId | Group |
GROUP | DELETEGROUP | Delete Group | Yes | IpPerson | 1 | GroupId | Group |
GROUP | UPDATEGROUP | Group updated | Yes | IpPerson | 1 | GroupId | Group |
IMPORT | IMPORTCATEGORY | Import category | Yes | IpPerson | 1 | ContentManagementId | Category, SubCategory, LoginAccess, ShortDescription |
IMPORT | IMPORTDASHBOARD | Import dashboard | Yes |
| 1 | Tab Id | GroupId, ShortDescription |
IMPORT | IMPORTREPORT | Import report | Yes | IpPerson | 1 | ReportId | ReportId, ReportName |
IMPORT | IMPORTSOURCE | Import data source | Yes | IpPerson | 1 | SourceId | SourceId, SourceName |
IMPORT | IMPORTUSERS | Import users | Yes | IpPerson | 1 | 99 | UserN (IpPerson) |
IMPORT | IMPORTVIEW | Import view | Yes | IpPerson | 1 | ViewId | ViewId, ViewDescription |
REGiSTRATION | CREATEUSER | Create user | Yes | IpPerson | 1 | New User's IpPerson | IpPerson, PersonName, UserId, RoleCode |
REGISTRATION | DELETEUSER | User deleted | Yes | IpPerson | 1 | IpPerson of deleted user | User (user’s name), email (user’s userid), org |
REGiSTRATION | EDITUSER | Edit user | Yes | IpPerson | 1 | User's IpPerson | IpPerson, PersonName, UserId, RoleCode |
REPORT | AUTOREFRESH | Scheduled report refreshed |
|
| 1 | ReportId | report |
REPORT | DASHACTIVATE | Dashboard activated | Yes | IpPerson | 1 | Tab Id | reportgroup |
REPORT | DASHADD | Existing tab added to user's dashboard | Yes | IpPerson | 1 | Tab Id | reportgroup |
REPORT | DASHADDREPORT | Report added to existing dashboard | Yes | IpPerson | 1 | Tab Id | reportgroup, report |
REPORT | DASHBOARD | Dashboard tab is run | Yes | IpPerson | 1 | Tab Id | requestortype, requestorid, dashboardid, dashboardtype, dashboardstatus, dashboardname |
REPORT | DASHCREATE | New dashboard created | Yes | IpPerson | 1 | Tab Id | reportgroup |
REPORT | DASHDELETE | Tab deleted from user's dashboard | Yes | IpPerson | 1 | Tab Id | reportgroup |
REPORT | DASHDELETEREPORT | Report deleted from a dashboard | Yes | IpPerson | 1 | Tab Id | reportgroup, report |
REPORT | DASHEDIT | Dashboard edited | Yes | IpPerson | 1 | Tab Id | reportgroup, parentgroup (if parent group exists) |
REPORT | DASHREMOVED | Corp Dashboard removed entirely | Yes | IpPerson | 1 | Tab Id | reportgroup |
REPORT | DASHRUN | Report is run from dashboard | Yes | IpPerson | 1 | ReportInstanceId | requestortype, requestor, timetorun, numrows, report |
REPORT | Report emailed to someone | Yes | IpPerson | 1 | ReportId | message, recipientN, subject | |
REPORT | EXPORT | Report saved as external format (pdf, xls etc) | Yes | IpPerson | 1 | ReportId | filename, exporttype, filesize |
REPORT | FAVEADD | Report added to favourites list | Yes | IpPerson | 1 | ReportId | report |
REPORT | FAVEDELETE | Report deleted from favourites list | Yes | IpPerson | 1 | ReportId | report |
REPORT | RPTBROADCAST | Scheduled broadcast run |
|
| BroadcastId | ReportId | report, error |
REPORT | RPTCOPY | Report copied | Yes | IpPerson | 1 | New ReportId | originalreport, newreport |
REPORT | RPTCREATE | Report created | Yes | IpPerson | 1 | ReportId | report |
REPORT | RPTDELETE | Report deleted | Yes | IpPerson | 1 | ReportId | report |
REPORT | RPTEDIT | Report edited | Yes | IpPerson | 1 | ReportId | report |
REPORT | RPTREFRESH | Refresh a manual-refresh report | Yes | IpPerson | 1 | ReportId | report |
REPORT | RPTRUN | Report is run | Yes | IpPerson | 1 | ReportInstanceId | requestortype, requestor, timetorun, numrows, report |
REPORT | RPTSEARCH | Report search performed | Yes | IpPerson | 1 | 99 | searchtext |
REPORT | RPTSUBSCRIBE | User subscribed to a report | Yes | IpPerson | BroadcastId | ReportId | report |
REPORT | XMLTOOBIG | VersionHistory flag is on, but xml exceeds max size | Yes | IpPerson | 1 | Reportid | ContentManagementId, MaxSize, XMLSize |
REPORTADMIN | CATCREATE | Report category created | Yes | IpPerson | 1 | ContentManagementId | Category, SubCategory, LoginAccess, ShortDescription |
REPORTADMIN | CATDELETE | Report category deleted | Yes | IpPerson | 1 | ContentManagementId | Category, SubCategory, LoginAccess, ShortDescription |
REPORTADMIN | CATEDIT | Report category edited | Yes | IpPerson | 1 | ContentManagementId | Category, SubCategory, LoginAccess, ShortDescription |
REPORTADMIN | COMPOSITEVIEWREFRESH | Scheduled composite view refresh |
|
| 1 | ViewId | view, error |
REPORTADMIN | DELETESCHEDULE | Scheduled task deleted | Yes | IpPerson | 1 | 99 | ScheduleSubjectCode, ScheduleUnitCode, ScheduleUnitId |
REPORTADMIN | DISTRIBUTEDASH | Dashboard tab distributed to another user | Yes | IpPerson | 1 | Tab Id | fullname (person sending the tab), userId (userid of person sending the tab), tabId, recipient (ipPerson) |
REPORTADMIN | DISTRIBUTEREPORT | Report distributed to another user | Yes | IpPerson | 1 | ReportId | fullname (person sending the report), userId (userid of person sending the report), reportId, recipient (ipPerson) |
REPORTADMIN | KILLSESSION | Session killed | Yes | IpPerson | 1 | 99 | KilledSessionId, UserName, UserId |
REPORTADMIN | LICENCELOADED | New Licence file loaded | Yes | IpPerson | 1 | DocumentId | DocumentId |
REPORTADMIN | SOURCECREATE | Data source created | Yes | IpPerson | 1 | SourceId | name, access, url, username |
REPORTADMIN | SOURCEDELETE | Data source deleted | Yes | IpPerson | 1 | SourceId | name, access, url, username |
REPORTADMIN | SOURCEEDIT | Data source edited | Yes | IpPerson | 1 | SourceId | name, access, url, username |
REPORTADMIN | SOURCEFILTERREFRESH | Scheduled source filter refresh |
|
| 1 | ReportTaskId | source, filter, error |
REPORTADMIN | UPDATECONFIG | Configuration updated | Yes | IpPerson | 1 | 99 |
|
REPORTADMIN | VIEWACTIVATE | View activated | Yes | IpPerson | 1 | ViewId | name, access, status |
REPORTADMIN | VIEWCREATE | View created | Yes | IpPerson | 1 | ViewId | name, access, status |
REPORTADMIN | VIEWDEACTIVATE | View deactivated (changed from active to draft mode) | Yes | IpPerson | 1 | ViewId | name, access, status |
REPORTADMIN | VIEWDELETE | View deleted | Yes | IpPerson | 1 | ViewId | name, access, status |
REPORTADMIN | VIEWEDIT | View edited | Yes | IpPerson | 1 | ViewId | name, access, status |
ROLEADMIN | CREATEROLE | Role created | Yes | IpPerson | 1 | 99 | Role |
ROLEADMIN | DELETEROLE | Role deleted | Yes | IpPerson | 1 | 99 | Role |
ROLEADMIN | UPDATEROLE | Role updated | Yes | IpPerson | 1 | 99 | Role |
SYSTEM | SHUTDOWN | System shutdown |
|
| 1 | 99 | ShutdownTime |
SYSTEM | STARTUP | System startup |
|
| 1 | 99 | StartupTime |
SYSTEMTASK | ADHOC | Used for various background system tasks (adhoc task started) |
|
| 1 | 99 | TaskName, StartTime |
SYSTEMTASK | COMPLETE | Used for various background system tasks (task completed) |
|
| 1 | 99 | TaskName, CompleteTime |
SYSTEMTASK | SCHEDULED | Used for various background system tasks (scheduled task started) |
|
| 1 | 99 | TaskName, StartTime |
USERACCESS | DASHBOARD | Dashboard record cleanup | Yes | IpPerson | 1 | 99 | message, dashboardid |
USERACCESS | LOGIN | User logs in | Yes | IpPerson | 1 | 99 | email (userid), browser, AccessType, ClientOrg?, ClientRefId?, webservices? |
USERACCESS | LOGOUT | User logs out | Yes | IpPerson | 1 | 99 | PersonName, PersonId, OrgName, OrgId, Userid |
USERACCESS | PASSWORDINVALID | User enters invalid password during logon attempt |
| IpPerson | 1 | 99 | attempt, userid |
USERACCESS | SESSIONTIMEOUT | User's session times out | Yes | IpPerson | 1 | 99 | userid, AccessType, Timeout |
USERACCESS | USERLOCKOUT | User enters invalid password 3 times and is locked out |
| IpPerson | 1 | 99 | attempt, userid |