How can we help you today? How can we help you today?
DustinM
Activity overview Badges (0) Posts (0) Comments (66)

Comments

Sort by recent activity
Hi Chris, Would you be able to update to the most recent version of SQL Prompt v10.12.3 and see if the issue is still occurring? Best, Dustin / comments
  1. Community
  2. SQL Prompt
  3. Formatting problem
Hi Chris,Would you be able to update to the most recent version of SQL Prompt v10.12.3 and see if the issue is still occurring?Best,Dustin
0 votes
Hi Chris, Could you confirm which version of SSMS and SQL Prompt you are currently using? Best, Dustin / comments
  1. Community
  2. SQL Prompt
  3. Formatting problem
Hi Chris,Could you confirm which version of SSMS and SQL Prompt you are currently using?Best,Dustin
0 votes
There are a few things we can do to check what is happening with the webhooks.   Can you run the script below against the base monitor database to check if the webhook is enabled?   SELECT 'Root' Level, NULL Name1, NULL Name2, NULL Name3, alert.Alert_Type.AlertType, alert.Alert_Type.Name AS 'Alert Name', SubType, Configuration, Enabled, AlertNotification, EmailAddress, Version, WebhookEnabled<br>FROM config.AlertConfiguration_View<br>JOIN alert.Alert_Type ON alert.Alert_Type.AlertType = config.AlertConfiguration_View.AlertType<br>UNION ALL<br>SELECT 'Group', Group_Name, NULL, NULL, Group_AlertType, alert.Alert_Type.Name, Group_SubType, Group_Configuration, Group_Enabled, Group_AlertNotification, Group_EmailAddress, Group_Version, Group_WebhookEnabled<br>FROM config.Group_AlertConfiguration_View<br>JOIN alert.Alert_Type ON alert.Alert_Type.AlertType = config.Group_AlertConfiguration_View.Group_AlertType<br>UNION ALL<br>SELECT 'Cluster', Cluster_Name, NULL, NULL, Cluster_AlertType, alert.Alert_Type.Name, Cluster_SubType, Cluster_Configuration, Cluster_Enabled, Cluster_AlertNotification, Cluster_EmailAddress, Cluster_Version, Cluster_WebhookEnabled<br>FROM config.Cluster_AlertConfiguration_View<br>JOIN alert.Alert_Type ON alert.Alert_Type.AlertType = config.Cluster_AlertConfiguration_View.Cluster_AlertType<br>UNION ALL<br>SELECT 'Machine', Cluster_Name, Cluster_Machine_Name, NULL, Cluster_Machine_AlertType, alert.Alert_Type.Name, Cluster_Machine_SubType, Cluster_Machine_Configuration, Cluster_Machine_Enabled, Cluster_Machine_AlertNotification, Cluster_Machine_EmailAddress, Cluster_Machine_Version, Cluster_Machine_WebhookEnabled<br>FROM config.Cluster_Machine_AlertConfiguration_View<br>JOIN alert.Alert_Type ON alert.Alert_Type.AlertType = config.Cluster_Machine_AlertConfiguration_View.Cluster_Machine_AlertType<br>UNION ALL<br>SELECT 'SqlServer', Cluster_Name, Cluster_SqlServer_Name, NULL, Cluster_SqlServer_AlertType, alert.Alert_Type.Name, Cluster_SqlServer_SubType, Cluster_SqlServer_Configuration, Cluster_SqlServer_Enabled, Cluster_SqlServer_AlertNotification, Cluster_SqlServer_EmailAddress, Cluster_SqlServer_Version, Cluster_SqlServer_WebhookEnabled<br>FROM config.Cluster_SqlServer_AlertConfiguration_View<br>JOIN alert.Alert_Type ON alert.Alert_Type.AlertType = config.Cluster_SqlServer_AlertConfiguration_View.Cluster_SqlServer_AlertType<br>UNION ALL<br>SELECT 'Database', Cluster_Name, Cluster_SqlServer_Name, Cluster_SqlServer_Database_Name, Cluster_SqlServer_Database_AlertType, alert.Alert_Type.Name, Cluster_SqlServer_Database_SubType, Cluster_SqlServer_Database_Configuration, Cluster_SqlServer_Database_Enabled, Cluster_SqlServer_Database_AlertNotification, Cluster_SqlServer_Database_EmailAddress, Cluster_SqlServer_Database_Version, Cluster_SqlServer_Database_WebhookEnabled<br>FROM config.Cluster_SqlServer_Database_AlertConfiguration_View<br>JOIN alert.Alert_Type ON alert.Alert_Type.AlertType = config.Cluster_SqlServer_Database_AlertConfiguration_View.Cluster_SqlServer_Database_AlertType<br>UNION ALL<br>SELECT 'Job', Cluster_Name, Cluster_SqlServer_Name, Cluster_SqlServer_Agent_Job_Name, Cluster_SqlServer_Agent_Job_AlertType, alert.Alert_Type.Name, Cluster_SqlServer_Agent_Job_SubType, Cluster_SqlServer_Agent_Job_Configuration, Cluster_SqlServer_Agent_Job_Enabled, Cluster_SqlServer_Agent_Job_AlertNotification, Cluster_SqlServer_Agent_Job_EmailAddress, Cluster_SqlServer_Agent_Job_Version, Cluster_SqlServer_Agent_Job_WebhookEnabled<br>FROM config.Cluster_SqlServer_Agent_Job_AlertConfiguration_View<br>JOIN alert.Alert_Type ON alert.Alert_Type.AlertType = config.Cluster_SqlServer_Agent_Job_AlertConfiguration_View.Cluster_SqlServer_Agent_Job_AlertType<br>UNION ALL<br>SELECT 'Disk', Cluster_Name, Cluster_Machine_Name, Cluster_Machine_LogicalDisk_Name, Cluster_Machine_LogicalDisk_AlertType, alert.Alert_Type.Name, Cluster_Machine_LogicalDisk_SubType, Cluster_Machine_LogicalDisk_Configuration, Cluster_Machine_LogicalDisk_Enabled, Cluster_Machine_LogicalDisk_AlertNotification, Cluster_Machine_LogicalDisk_EmailAddress, Cluster_Machine_LogicalDisk_Version, Cluster_Machine_LogicalDisk_WebhookEnabled<br>FROM config.Cluster_Machine_LogicalDisk_AlertConfiguration_View<br>JOIN alert.Alert_Type ON alert.Alert_Type.AlertType = config.Cluster_Machine_LogicalDisk_AlertConfiguration_View.Cluster_Machine_LogicalDisk_AlertType  If the above script shows that webhook is enabled could you also run the script below to check if any webhook notifications are being sent? SELECT TOP 1000 [n].[AlertId]<br> ,[utils].[TicksToDateTime]([n].[SeverityDate]) AS SeverityDate<br> ,[utils].[TicksToDateTime]([n].[NotificationDate]) AS NotificationDate<br> ,CASE<br>WHEN [n].[NotificationType] = 0 THEN 'Email'<br>WHEN [n].[NotificationType] = 1 THEN 'Slack'<br>WHEN [n].[NotificationType] = 2 THEN 'SNMP'<br>WHEN [n].[NotificationType] = 3 THEN 'Webhook'<br>END AS NotificationType<br>FROM [alert].[Notifications] AS [n]<br>WHERE [n].[NotificationType] = 3<br>ORDER BY n.NotificationDate DESCBest,   Dustin  / comments
  1. Community
  2. Redgate Monitor
  3. SQLMonitor integration with ServiceNow
There are a few things we can do to check what is happening with the webhooks. Can you run the script below against the base monitor database to check if the webhook is enabled? SELECT 'Root' Leve...
0 votes
Hi Tanner,   Thank you for your inquiry into SQL Dependency Tracker. Unfortunately it looks like there are currently no plans to produce a 64 bit version of this offering.   A potential workaround is to use Large Address Aware utility which will enable Redgate.DependencyViewer.UI.exe Large Address Aware (allowing this process to use up to 4GB RAM within a 64bit system). The following link will provide further information and the utility to download - https://www.techpowerup.com/forums/threads/large-address-aware.112556/     Best,   Dustin  / comments
  1. Community
  2. SQL Dependency Tracker
  3. SQL Dependency Tracker Hangs On VERY large SQL databases - 64bit or command line execution options?
Hi Tanner, Thank you for your inquiry into SQL Dependency Tracker. Unfortunately it looks like there are currently no plans to produce a 64 bit version of this offering. A potential workaround is t...
0 votes
Hello, Thank you for your inquiry into SQL Prompt. Currently, the SQL servers that are supported outside of the standard SQL Server 2012 - 2022 are below. https://documentation.red-gate.com/sp/getting-started/requirements Azure SQL Database SQL Server on Azure VM Google Cloud SQL for SQL Server & Virtual Machines Amazon SQL Server RDS & Virtual Machines I will leave the SQL Prompt UserVoice forum here if you would like to suggest this addition to our dev team. https://redgate.uservoice.com/forums/94413-sql-prompt Best, Dustin  / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Prompt is not showing all linked server contents
Hello,Thank you for your inquiry into SQL Prompt. Currently, the SQL servers that are supported outside of the standard SQL Server 2012 - 2022 are below.https://documentation.red-gate.com/sp/gettin...
0 votes
AWS Redshift is a different offering from Amazon SQL Server RDS, the method in which the way data is stored is different between the two platforms and is unfortunetly not currently supported by SQL Prompt. Best,  Dustin  / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Prompt is not showing all linked server contents
AWS Redshift is a different offering from Amazon SQL Server RDS, the method in which the way data is stored is different between the two platforms and is unfortunetly not currently supported by SQL...
0 votes
Total activity
112
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
46