How to resolve issue of custom Audit log table containing incorrect data?
We have created a parent table, child table & Audit log table in SQL Server database. For one parent record, there are multiple child records. When a child record in updated, a Stored Procedure is called in which a few fields of all the child records are updated that are associated with the parent record. We have 'for insert/for update' triggers created on the child table in SQL Server which inserts the new/updated child record into a custom Audit log table. The 'for update' trigger for the child table uses mapping based on the parent record id for inserted & deleted pseudo tables. This 'for update' trigger adds into Audit log table any changes done to the child record fields except the few fields that are updated using the Stored Procedure. We have noticed a pattern in the Audit log table which reoccurs again & again only in Production env. We are unable to reproduce this issue in Non-Production envs. After about 25 to 30 correct child records for several parent records are added in the Audit log table that the user had updated in the child table, several old child records for a parent record also get added into the Audit log table which were not updated in the child table by the user. Please let us know what is the root cause & resolution of this issue.
Two questions about sign-out of Teams app
We have each PC in each conference room that is used for Teams meetings. Each conference room PC has its own teams account which is kept as logged in to Teams app so that anyone can start and join to web conference without laptop PC. This works fine. However, Teams app sometimes automatically signs out. So we have two questions. 1. Sign-out action is logged in somewhere? Can we find it in admin center or other place? We would like to know whether someone operated Teams app and signed it out manually or not. 2. If anyone did not operate Teams app and sign it out, what setting causes Teams app automatically sign out? Thank you.
Export Teams user call history
Hi Is there a way to export the call history for individual teams users? (so you can filter on participants etc) I can view the user call history in the teams admin centre > manage users > select user > meetings & calls - but there is no option to export this? I want to view the call history between 2 teams users and the other suggestions found so far haven't worked, if anyone has a solution to export the 30 days listed in the admin centre or longer than this using the eDiscovery search please let me know 🙂