on ‎2022 Nov 08 4:12 PM
Hi All,
I would like to create report to see who imported the Bank Holidays into the system.
I created canvas report > Time management > Time account without success. Is there a way that we can populate this data from the system?
I would appreciate help with this.
Request clarification before answering.
Advanced reporting will normally only show employee related data (bank holidays is not). Here it depends a bit as well on whether or not nothing else has been done after that import (as MDF tables commonly do not have any audit logs).
Assuming no action has been taken after the import you can do 2 things:
1. Go go Manage Data, Holiday or Holiday Calendar (depends a bit on what was imported) & select the records one by one (not ideal, but if you know at least 1 imported record that is already giving you the information in the bottom right corner.
2. Go to Integration center, create a new integration (Scheduled simple file output, as in the first option, be ok) and then either select the holiday or holiday assignment entity (depends a bit on what was imported, which you should be able to find back in monitor jobs if you're not sure). You'll want to select some fields here, but the main fields are the 3 last modified fields (as that answers your question). If you then go to the configure fields tab and sort the last modified date properly (click on that field and you'll already see the option to do so) then you will get a preview here. If you swap to the glasses icon on the right hand side and increase the max preview items you will get a pretty decent list (which you can even have exported to an sftp if desired).
Maybe people analytics could do more, but I'm assuming you don't have that to your disposal.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 8 | |
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.