How do you use cloud databases? Take the survey.

SQL Monitor Powershell cmdlet issue

Hi all.
I'm having trouble setting up access to SQL Monitor via Powershell. I am getting the error "Invoke-RestMethod : Invalid URI: The hostname could not be parsed."

Here is what I have done to get this far:
  • downloaded the Powershell module and used Import-Module to activate the command manifest
  • generated an authentication token and initialised it
  • ran the get-clusters and get-standalonemachines commands
  • error is displayed
Any advice on what I need to do to get this working?
Thanks in advance.
Tagged:

Answers

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    Hi, thank you for your forum post.

    Would it be possible for you to reply with the actual parameters (with the machine names or cluster names changed) for me to review?

    I suspect from the error that you may have entered an incorrect host name for your cluster or stand-alone machine.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • @robinw there was an actual problem with Get-Clusters a few versions ago fixed recently, so if you're not running 9.1.2 please upgrade and try again, and if you still have issues come back to us with the above requested information.
    Have you visited our Help Centre?
Sign In or Register to comment.