Annotations not clicking through

Hyperlance

We have started using applying annotations as per the documentation which works nicely. However when we create one with a URL, we cannot click through to the URL. It just behaves the same as an annotation without a URL. The documentation doesn't say it needs to be in a specific format like HTML i.e. '<a href=', so not sure why this is not working. We are on 13.0.32.24608

Jon_Kirkwood

Hi @Hyperlance

Thank you for reaching out on the Redgate forums regarding your SQL Monitor Annotation concern.

Are you able to share the Annotation snippet you are running so I can look into this.

I have created my own annotations and they do not seem to be clicking through to URLs either. Would like to confirm your usage matches mine and I can escalate to our developers as a possible bug.

Hyperlance

It is done via powershell

The RedgateSQM is imported and then the following call is done

Add-SqlMonitorAnnotation -Target $instance -UtcDate $utcdate -Source $source -Description $text -URL $url

Jon_Kirkwood

Updating this post with a fix.

I can advise that patch v13.0.42 has been released with a fix for URL's in annotations.
In testing, I passed in the following strings to my Add-SqlMonitorAnnotation command and all were clickable:
 
-Url 'https://www.google.com'
-Url 'http://www.google.com'
-Url 'mailto:<email address>'
 
Other link types may be usable, depending on your systems' ability to parse them. 
You will need the http/https in your website address.
 
Previously added annotations should be working also, provided they were formatted correctly when created.

Patch notes for this release are available here:
https://documentation.red-gate.com/sm/release-notes-and-other-versions/sql-monitor-13-0-release-notes
 
Download link here:
https://download.red-gate.com/checkforupdates/SQLMonitorWeb/SQLMonitorWeb_13.0.42.28300.exe