Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $env:ServerName = "MyServer"
- $env:JenkinsUser = "domain\login"
- $env:JenkinsPassword = "SuperSecretPassword"
- ## Ivoke OS Pester test output to OSreport.xml
- Invoke-Pester -Script @{Path ='C:\GIT\DBA\Build\Pester\SQL Server OS.test.ps1'; Parameters = @{ServerName = $($env:ServerName); JenkinsUser = $($env:JenkinsUser) ; JenkinsPassword = $($env:JenkinsPassword)}} -OutputFile OSreport.xml -OutputFormat NUnitXml
- ## Push data into SQL Server via DBATools
- $output = Parse-PesterXML -XMLFile ./OSreport.xml -Server $env:ServerName | Out-DbaDataTable
- Write-DbaDataTable -SqlServer PRD-SQL-INT01 -InputObject $output -Table admin.dbo.pesterresults -AutoCreateTable
Add Comment
Please, Sign In to add comment