Difference between revisions of "Backup and Update Replica Database Audit"

From Charitylog Manual
Jump to: navigation, search
 
(10 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
[[file:helpheader_small.png|right]]
 
[[file:helpheader_small.png|right]]
  
[[file:Cl_BURDA_2.PNG]]
+
[[file:audit_rep1.jpg|300px|alt="a screenshot of the audit report button in the reporting menu"]]
  
  
The Backup and Update Replica Database Audit feature produces a report about when the system has been backed up.
+
The Backup Audit reports on [[Backup_Data|System Backups]] and [[Update Replica Databases|updates to replica systems (training, test and temps)]].
  
[[file:cl_BURDA_2.png|border]]
+
[[file:audit_rep2.jpg|500px|alt="a screenshot of the backup audit report fields. There are two date range fields."]]
  
 +
* '''Earliest Date''' - Specify the earliest date you wish to include on the report.
 +
* '''Latest Date''' - Specify the latest date you wish to include on the report.
 +
* '''Type''' - Specify what you want included on the report.
  
Your data can be backed up at any time using the [[Backup Data]] feature - in essence this is a wholesale copy of the system data which you can download. The [[Update Replica Databases]] feature also allows a wholesale copy of the system, except in this case, the copy is made to another Crossdata system. When the [[Backup Data]] option is used, the data is downloaded in SQL format, and is not encrypted, so this could represent a significant security risk if not properly controlled.
+
Click 'Display in Browser' to run the report or 'Export to Spreadsheet'.
  
The system keeps an audit of when the [[Backup Data]] feature is used, as well as the [[Update Replica Databases]] feature (because once the data is copied to a replica system, it could also be downloaded from there), and this report is the output for that audit record. Backups of uploaded documents are also audited in this way because uploaded document backups also allow the user to download readable data.
+
[[File:audit_rep3.jpg|800px|alt="a screenshot of the audit report results, showing that Allan Conway updated the training system on 16th of October 2023."]]
 
 
 
 
===Report filters===
 
 
 
You can filter the reporting output by:
 
 
 
* '''Earliest Date''' and '''Latest Date''' - use these to set a date range for the report
 
* '''Type''' - report on all backups, or narrow the results to Database Backups, Update Replica Database, or Uploaded Document Backups.
 
  
 +
* '''Date''' - The date and time the action was started.
 +
* '''Type'''
 +
** '''Database Backup''' - Backup of the SQL data, all settings and information on the system excluding uploaded documents.
 +
** '''Uploaded Documents''' - Backup of uploaded documents.
 +
** '''Update Replica Database for Test system''' - Updates to replica systems (training, test and temps), specifies which one.
 +
** '''User''' - The user that completed the action.
 +
** '''IP Address''' - This is an address given to a device that connects to the internet, normally the broad band router.
  
 
----
 
----
[[User:Rob Kay|Rob Kay - manual author]] ([[User talk:Rob Kay|talk]]) 14:43, 13 June 2017 (BST)
 
 
[[file:helpheader_small.png|right]]
 
[[file:helpheader_small.png|right]]
[[Category:Reporting]]
 

Latest revision as of 15:17, 25 March 2024

Helpheader small.png

"a screenshot of the audit report button in the reporting menu"


The Backup Audit reports on System Backups and updates to replica systems (training, test and temps).

"a screenshot of the backup audit report fields. There are two date range fields."

  • Earliest Date - Specify the earliest date you wish to include on the report.
  • Latest Date - Specify the latest date you wish to include on the report.
  • Type - Specify what you want included on the report.

Click 'Display in Browser' to run the report or 'Export to Spreadsheet'.

"a screenshot of the audit report results, showing that Allan Conway updated the training system on 16th of October 2023."

  • Date - The date and time the action was started.
  • Type
    • Database Backup - Backup of the SQL data, all settings and information on the system excluding uploaded documents.
    • Uploaded Documents - Backup of uploaded documents.
    • Update Replica Database for Test system - Updates to replica systems (training, test and temps), specifies which one.
    • User - The user that completed the action.
    • IP Address - This is an address given to a device that connects to the internet, normally the broad band router.

Helpheader small.png