Subscribed Web Alert

Posted on By David Kittell

Will return you all the web alerts. The ID column represent the ID for the web alert

SELECT *
FROM subscriptions_tbl

Will return you the folder(s) where the web alert is assigned
The column Value_number represents the ID column from subscriptions_tbl
The column Object_ID represents the folder ID where the web alert is assigned

SELECT *
FROM dynamic_data_tbl
WHERE definition_id = 1
	AND definition_object_id = 1

Will return you the users subscribed to the web alert
The column Value_number represents the ID column from subscriptions_tbl
The column Object_ID represents the user ID for the user subscribed to the web alert

SELECT *
FROM dynamic_data_tbl
WHERE definition_id = 1
	AND definition_object_id = 2
Originally Posted on August 6, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code Ektron MSSQL MSSQL - Ektron MSSQL - Ektron 8.0.2 SQL

Related Posts

Get IP Address

Posted on

Public Function GetIPAddress() As String Dim h As System.Net.IPHostEntry = System.Net.Dns.GetHostEntry(System.Net.Dns.GetHostName) Return h.AddressList.GetValue(0).ToString End Function public string GetIPAddress() { string myHost = System.Net.Dns.GetHostName(); string myIP = null; for (int i = 0; i <= System.Net.Dns.GetHostEntry(myHost).AddressList.Length – 1; i++) { if (System.Net.Dns.GetHostEntry(myHost).AddressList[i].IsIPv6LinkLocal == false) { myIP = System.Net.Dns.GetHostEntry(myHost).AddressList[i].ToString(); } } return…

Read More

MessageBox Class

Posted on

Dim result = MessageBox.Show("Message To Display", "MessageBox Title", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question) If result = DialogResult.Cancel Then MessageBox.Show("Cancel Button Pressed", "MessageBox Title",MessageBoxButtons.OK , MessageBoxIcon.Exclamation) ElseIf result = DialogResult.No Then MessageBox.Show("No Button Pressed", "MessageBox Title", MessageBoxButtons.OK, MessageBoxIcon.Error) ElseIf result = DialogResult.Yes Then MessageBox.Show("Yes Button Pressed", "MessageBox Title", MessageBoxButtons.OK, MessageBoxIcon.Information) End If var result…

Read More