Guest User

Untitled

a guest
Oct 27th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. $env:ServerName = "MyServer"
  2. $env:JenkinsUser = "domain\login"
  3. $env:JenkinsPassword = "SuperSecretPassword"
  4.  
  5. ## Ivoke OS Pester test output to OSreport.xml
  6. 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
  7.  
  8. ## Push data into SQL Server via DBATools
  9. $output = Parse-PesterXML -XMLFile ./OSreport.xml -Server $env:ServerName | Out-DbaDataTable
  10. Write-DbaDataTable -SqlServer PRD-SQL-INT01 -InputObject $output -Table admin.dbo.pesterresults -AutoCreateTable
Add Comment
Please, Sign In to add comment