Version 1

    With the release of the Database Performance Analyzer 12.1 and the Management API, I have started developing a PowerShell module called PSDPA. The module is now available through the PowerShell Gallery and GitHub. I would still consider this release a "beta" release, as not everything has been implemented and not everything has been tested. If you have ideas on additional features - feel free to submit a GitHub issue. Pull requests are also welcome!

     

    Prerequisites

    • PowerShell 5.x
    • PSFramework PowerShell Module
    • DPA 12.1 and an API Refresh Token

     

    Installation

    if (-not (Get-Module PSFramework -ListAvailable)) { Install-Module PSFramework }

    Install-Module PSDPA

     

    Configuration

    Set-DpaConfig -BaseUri 'http://yourserver:8123/iwc/api' -RefreshToken 'yourrefreshtoken'

     

    Links

    PowerShell Gallery

    GitHub

     

    Practical Examples

    # add an annotation to all servers after patching

    Get-DpaMonitor | Add-DpaAnnotation -Title "Patching" -Description "Operating system patching"

     

    # reboot a server, but make sure to stop/start DPA on the instance before so we don't get alerts

    Stop-DpaMonitor -MonitorName "MyServer"

    Restart-Computer -ComputerName "MyServer"

    Start-DpaMonitor -MonitorName "MyServer"