tag:blogger.com,1999:blog-4640916315241010554.post3564447799076994484..comments2023-08-08T02:41:21.053-07:00Comments on Operations Manager 2012: SCOM - Query Notification Subscription Data via SQLUnknownnoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-4640916315241010554.post-5875577342467843922015-09-02T04:22:34.371-07:002015-09-02T04:22:34.371-07:00Excellent Brody, Thanks For Feeding BreadExcellent Brody, Thanks For Feeding BreadBloggerhttps://www.blogger.com/profile/04534906295104563358noreply@blogger.comtag:blogger.com,1999:blog-4640916315241010554.post-49197941574679862742015-08-18T13:59:57.296-07:002015-08-18T13:59:57.296-07:00Hello,
I have the Value for the Rule ID
Select r...Hello,<br /><br />I have the Value for the Rule ID <br />Select r.RuleId, r.RuleModuleId, r.enabled, R.DisplayName,D.C.value('Value[1]','varchar(4000)') Value<br />From (<br />Select RuleId, rm.RuleModuleId, enabled, r.DisplayName, cast(RuleModuleConfiguration as XML) xmlquery<br />FROM<br />RuleModule rm<br />join RuleView r on rm.RuleId = r.Id<br />where r.Category = 'Notification'<br />and RuleModuleName = 'DS1'<br />and R.DisplayName = 'XXXX - Pathology (UIC)'<br />) r<br />Cross Apply xmlquery.nodes('//ValueExpression') D(C)<br />now trying to get from thr RuleView the displayname, description, name for the subscription listed above...<br /><br />Thanks,<br />Dom<br /><br />Dominiquehttps://www.blogger.com/profile/01255525778656066370noreply@blogger.comtag:blogger.com,1999:blog-4640916315241010554.post-35993285612683888002015-08-18T07:46:35.718-07:002015-08-18T07:46:35.718-07:00I picked RuleModuleName = 'DS1' now looki...I picked RuleModuleName = 'DS1' now looking for the decrypt the xml which might gives me the list of criteria I am looking for...Dominiquehttps://www.blogger.com/profile/01255525778656066370noreply@blogger.comtag:blogger.com,1999:blog-4640916315241010554.post-50872505648966533502015-08-18T07:39:09.038-07:002015-08-18T07:39:09.038-07:00Hello,
What a beautiful queries... I got already ...Hello,<br /><br />What a beautiful queries... I got already all set with this... Now an extension for me would be to get the list of criteria listed from this query if it is possible... let me know.<br /><br />Thnaks,<br />DomDominiquehttps://www.blogger.com/profile/01255525778656066370noreply@blogger.com