Red Gate forums :: View topic - Customized alert settings at 'All Servers' level.
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

Customized alert settings at 'All Servers' level.

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
fruyven



Joined: 23 Aug 2011
Posts: 6

PostPosted: Thu Nov 10, 2011 10:45 am    Post subject: Customized alert settings at 'All Servers' level. Reply with quote

How can I see what alert have been customized at this level?

This seems to be true: "You can see which alerts have been customized at which levels in the Monitored servers list; they are indicated by the number in brackets"

But at this level (All Servers) this seems to be untrue: "When you select a level in the Monitored servers list, those alerts that have been customized at the selected level are identified by <This level> and highlighted in bold"

(Quotes from http://www.red-gate.com/supportcenter/Content?p=SQL%20Monitor&c=SQL_Monitor/help/2.3/SM_CustomizingAlerts.htm&toc=SQL_Monitor/help/2.3/toc1418820.htm)
Back to top
View user's profile Send private message
fruyven



Joined: 23 Aug 2011
Posts: 6

PostPosted: Thu Nov 10, 2011 12:06 pm    Post subject: Reply with quote

I think I found a work-around.

select * from [alert].[Alert_Type] where [AlertType] in (select [_AlertType] from [config].[AlertConfiguration])
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Thu Nov 10, 2011 12:16 pm    Post subject: Reply with quote

Hi,

Thanks for your post.

Unfortunately, this is not very visible at 'All Servers' level. The idea was that if you change something at this level then it becomes default for you. Though you can see how many have changed (from factory default) by seeing the number against 'All Servers' level.

It would be nice to know why you would like to know what has been changed from factory defaults at 'All Servers' level?

Note: You can always retrieve this directly from SQL Monitor database repository.

Thanks,
Priya
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Thu Nov 10, 2011 12:18 pm    Post subject: Re: Reply with quote

fruyven wrote:
I think I found a work-around.

select * from [alert].[Alert_Type] where [AlertType] in (select [_AlertType] from [config].[AlertConfiguration])


Yes, you are absolutely correct Smile.

Regards,
Priya
Back to top
View user's profile Send private message
fruyven



Joined: 23 Aug 2011
Posts: 6

PostPosted: Thu Nov 10, 2011 1:00 pm    Post subject: Reply with quote

"It would be nice to know why you would like to know what has been changed from factory defaults at 'All Servers' level?"

The reason is that we have just recently started using SQL monitor and now I want to review the configuration changes we made before.

Thank you for your reply.

Regards,
Frits
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Thu Nov 10, 2011 1:02 pm    Post subject: Reply with quote

Thanks a lot for your reply Frits.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group