I am trying to retrieve audit logs for specific group membership changes between May 2023 and May 2024 from our Azure DevOps Server. From my research, it seems that the auditing feature available in Azure DevOps Service is not present in Azure DevOps Server.
Could someone help me with a PowerShell script that can achieve this? I need the script to:
1. Connect to our Azure DevOps Server.
2. Identify and retrieve group membership changes for a specific group.
3. Filter the results to only include changes between May 2023 and May 2024.
Any guidance or script sample would be greatly appreciated. Thank you!
As you may have noticed, Auditing isn’t available for on-premises deployments of Azure DevOps Server and even for Azure DevOps Services, the events get stored for 90 days. See in Access, export, filter audit logs for Azure DevOps – Azure DevOps | Microsoft Learn.
You might have a try with the web administration page (http://MyServer:8080/tfs/_oi/) for the application-tier server, where you can view activity logs.
Besides, those activity logs are stored in tbl_Command of the Azure DevOps SQL server database; however, please DO NOT run queries against Azure DevOps SQL server directly.
I can understand your requirement to track the history entitlement changes. Per the current limitation, you may create a feature request via: https://developercommunity.visualstudio.com/report?space=21&entry=suggestion . That will allow you to directly interact with the appropriate Product Group, and make it more convenient for the product group to collect and categorize your suggestions