10-04-2022 08:22 AM - last edited on 05-02-2023 10:41 AM by JackLacava
Is there any function or SQL to identify the newly added member in OS ? Ex - If I added an new account and I want to check whether the data was loaded to that new account ?
Thanks
10-04-2022 11:20 AM
Hi Krishna!
As a reminder, you can get some reports showing the changes in metatada. It is part of the marketplace solutino Application Reports RPTA.
If you need further customization, you can use the Audit Table AuditMember.
In there you will find teh DimTYpeID, the MemberID, then Name ...etc... and also when it was created using the TimeStamp.
I hope it helps.
10-04-2022 12:30 PM
Thanks NicolasArgente. Appreciate your quick response. It is really helpful. I think I need to use SQL to join few tables and get the results. This would be a good starting point for me.