How can I get the query clear text from sql Monitor tables/ view
ssh4478
Posts: 8 Bronze 1
Hello,
How can I get the query clear text from sql Monitor tables/ view to use it further downstream in my setup
SQL views/table is [data].[AzureManagedInstance_SqlText_Instances_InstanceDateRange
Thanks
How can I get the query clear text from sql Monitor tables/ view to use it further downstream in my setup
SQL views/table is [data].[AzureManagedInstance_SqlText_Instances_InstanceDateRange
Thanks
Tagged:
Answers
We don't currently support directly querying the data repository at this time, however I have provided similar information on decompressing the _QueryText fields in the forum previously https://forum.red-gate.com/discussion/comment/167646#Comment_167646 (remove the <div> elements that the forum added) and you should be able to apply to the various tables.
The xxx_InstanceDateRange you mention there is a function that returns a table of instances of that sampler between that time range rather than being a table or view.
Kind regards,
Alex
Have you visited our Help Center?