Hi Experts,

Is there anyway get Subscription list from Operations Manager DB using SQL query?  I lost subscription list, and need to create subscription as it was. Very urgent.

Thanks in advance.

Regards

Karthick M

Hi,If it's just a subscription list so you can query

SELECT Displayname FROM [OperationsManager].[dbo].[RuleView] where Category = 'Notification'

Hi,If it's just a subscription list so you can query

SELECT Displayname FROM [OperationsManager].[dbo].[RuleView] where Category = 'Notification'

• Proposed as answer by Jeff (Netwrix) 22 hours 47 minutes ago

Hi,If it's just a subscription list so you can query

SELECT Displayname FROM [OperationsManager].[dbo].[RuleView] where Category = 'Notification'

• Proposed as answer by Jeff (Netwrix) Tuesday, February 17, 2015 12:46 PM

Hi,

Hope the powershell command Get-SCOMNotificationSubscription can be helpful for you:

Get-SCOMNotificationSubscription

Retrieves a list of notification subscriptions.

https://technet.microsoft.com/en-us/library/hh918490(v=sc.20).aspx

Regards,

Yan Li