/
Time and Attendance Database Refresh Audit

Time and Attendance Database Refresh Audit

Owned by Knowledge Assistant
Apr 09, 2024
1 min read
Description of Issue

Client is wanting to know if there is a history in SQL that will determine the last time data was refreshed in their non-prod instance

Context

  • Time and Attendance

  • ExecuTime

  • SQL

  • SSMS

Cause

Informational

Resolution

  1. Open SSMS and connect to target SQL Instance

  2. Right-click the target database

  3. Select Reports > Standard Reports > Backup and Restore events > Successful Restore Options

    1. This will show the history of restore operations against target databases. 

Additional Information










Related content

How to audit Time Entry records and batches
How to audit Time Entry records and batches
Knowledge Assistant
More like this
Is There a Way to See if an Employee Modified the Time Sheet in Time and Attendance
Is There a Way to See if an Employee Modified the Time Sheet in Time and Attendance
Knowledge Assistant
More like this
How to view database restore history
How to view database restore history
Knowledge Assistant
More like this
Where To Access The Transaction Audit
Where To Access The Transaction Audit
Knowledge Assistant
More like this
Time-off Approval Audit Report
Time-off Approval Audit Report
Knowledge Assistant
More like this
How to Refresh Time and Attendance Prod to Non-Prod
How to Refresh Time and Attendance Prod to Non-Prod
Knowledge Assistant
More like this