The AGRIS 17.4.0 release has added:
...
AGS-
...
AGRIS 17.3.0 includes the pilot for the MSSQL Audit project. The Audit provides the following benefits to AGRIS users on MSSQL by leveraging the Change Data Capture functionality in Microsoft SQL Server and the Greenstone Quantum platform.
- Improve flexibility to comply with corporate auditing and security policies.
- Provide the ability to perform forensic analysis on who modified certain data and when.
The user may:
1. Configure to enable tracking of any relational table / column for recording changes.
2. Inquire on tracked tables / columns.
3. Export inquiry results to Excel.
...
2938: AGRIS Database Relational Model - System Support tables added for Greenestone Audit Tracking
The Greenstone Audit Tracking system is available for organizations running on Miscrosoft SQL Server database engine. For the 17.4 release, additional data elements have been added to the AGRIS SQL Server relational database model in order to track individual database changes user-by-user to the following data entities:
- Document Number setup
- Processing Dates
- Reporting Dates
- Initialized Packages
- Data Replication Sites
- Dataset Definition
- Date Assignments
- Email and Proxy Setup
- Report Output Defaults
- Security Configuration
- System Configuration
- User Security Settings
This enhancement provides the ability to track and record changes that occur to security, dataset configuration and general AGRIS setup changes.
AGS-2939: AGRIS Database Relational Model - System Journal Interface and General Ledger tables added for Greenestone Audit Tracking
The Greenstone Audit Tracking system is available for organizations running on Miscrosoft SQL Server database engine. For the 17.4 release, additional data elements have also been added to the AGRIS SQL Server relational database model in order to track individual database changes user-by-user to the following data entities:
- General Ledger Accounts
- Execution IDs
- Execution ID Budgets
- Execution Work Files
- Execution ID Descriptions
- Journal Periods
- System Account Mapping
This enhancement provides the ability to track and record changes that occur to SJI account mappings, Journal periods, Journal entries and SJI setup areas.
Looking for more info? Details may be found in the AGRIS User Guide under Greenstone Audit.
...