Audit request - applying filters to history export requests
Background - As a security audit process defined by P&G governance, we have to audit the application logs (from model history) to check if they are backed by request from business. However we do audit only for small subset of the data as the current log from models covers wide range.
This being a monthly task, we download data for previous month and then filter for certain actions (given below) and then audit them. We are facing issue as the file size of these history data runs into gigabytes (sometime as large as 40GB) and open this file in any tools is not supported to apply filter.
Help Needed - Can you share us an extract from model history post applying filters (as given below)? There is huge reduction of the output file post applying these filters. A gigabyte file gets downsized to kilobytes makes it easier to handle/process further.
Filter on "Description" column in the model history for these values -
'Add Dashboard', 'Import', 'Delete Item', 'Add Line Item', 'Add Module', 'Add Process', 'Add Property', 'Add Saved View', 'Add User', 'Change Action', 'Change Dashboard', 'Change Line Item', 'Change Module', 'Change Property', 'Change Role', 'Change Saved View', 'Change Time Scale', 'Move Dashboard', 'Name Changed', 'Parent Changed', 'Revision Synced', 'Set Action Access', 'Set List Access', 'Set Module Access', 'Set Selective Access', 'Set Version Access', 'User Role Changed'.
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!