Download audit logs in csv from azure DevOps UI using powershell
Hi I am looking for a script which can download export logs in csv from azure DevOps using powershell for given time frame. like I can enter time frame and then script will download and return csv file from azure DevOps ui -
I found this script here https://developercommunity.visualstudio.com/content/problem/615053/question-we-want-to-get-the-export-audit-log-using.html
I am not sure what username , password and url to use here
$Username = 'domain\user'
$Password = 'password'
$Url = "https://server:8080/tfs/_api/_licenses/Export"
$Path = "D:\temp\data.csv"
$WebClient = New-Object System.Net.WebClient
$WebClient.Credentials = New-Object
System.Net.Networkcredential($Username, $Password)
$WebClient.DownloadFile( $url, $path )
I am not able to find any more data on this
The sample you shared is download audit log form Azure DevOps Server, the url is https://{your_server}/tfs/_api/_licenses/Export, username , password are your username and password to log on to TFS.
Note: Do not forget add domain name before the username.
If you are using Azure DevOps Service, you can try this REST API and power shell script to save the Audit log.
$outfile = "{Local path}"
$connectionToken="{PAT}"
$base64AuthInfo= [System.Convert]::ToBase64String([System.Text.Encoding]::ASCII.GetBytes(":$($connectionToken)"))
$AuditLogURL = "https://auditservice.dev.azure.com/{organization}/_apis/audit/downloadlog?format=csv&startTime={startTime}&endTime={endTime}&api-version=6.1-preview.1"
$AuditInfo = Invoke-RestMethod -Uri $AuditLogURL -Headers @{authorization = "Basic $base64AuthInfo"} -Method Get –OutFile $outfile
Result:
- I am missing simplexml on my ubuntu machine but I can't download it
- How can I get the number of CPU cores in Powershell?
- How to convert String System Object into a Byte System Array in powershell?
- CD command in batch file does not work in PowerShell
- Run a .cmd file through PowerShell
- Powershell break a long array into a array of array with length of N in one line?
- On Windows what is the difference between Git Bash vs Windows Power Shell vs Command prompt
- Applying ACL Permissions using PowerShell Set-Acl
- Strange characters found in XML file and PowerShell output after exporting from Excel: ​
- (Powershell) Catch "Get-WinEvent : No events were found" Get-WinEvent
- A few groups in my ad are not found by the following script
- Adding default parameter to Powershell Core script
- How to change language/region and speech in Windows 10 with Powershell script
- Graph Powershell adding a user to PIM for a privileged security group
- Error while copying Azure Storage table from one Storage to another storage table using Powershell script
- Powershell "special" switch parameter
- In PowerShell, how do I define a function in a file and call it from the PowerShell commandline?
- remove the first character of each .txt file with Powershell
- Calling a C# delegate and then handling a callback in powershell
- How to prevent flickering caused by cls in a batch script?
- How can I replace newlines using PowerShell?
- Get-Printer Powershell script still showing columns even though they are excluded
- Is it secure to use a password argument in a Windows command?
- Read 'Attribute & Claims' from SAML Entra application configuration using PowerShell
- powershell: Getting path error while replacing json file
- Powershell - Install Windows Updates?
- How to select files that have no extension using powershell
- How do I use Get-ChildItem to return files that don't have an extension?
- See the docstring of my function with Visual Studio Code
- Azure KeyVault Secret near expiry list to email as a notification