How do you use cloud databases? Take the survey.
Options
Annotations not clicking through
Hyperlance
Posts: 7 Bronze 1
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
Tagged:
Answers
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.
The RedgateSQM is imported and then the following call is done
Add-SqlMonitorAnnotation -Target $instance -UtcDate $utcdate -Source $source -Description $text -URL $url
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