I don't want to customize alert me in SharePoint like this link
But I want to get alerts properties like:
Question : Is there any way to access any of the above items ? (by call web service ? or SQL Query? or any other alternate solution?)
(my Goal : decide to have alternative channels like Telegram Bots or cloud phone (CloudCall can be used with many CRM systems) call and other attractive ways for customers to Notify them. relationship management)
Thanks in advance
Case number 4 or 5 has lower priority : If impossible or hard or spend your time or out of scope of this question we skip that.
Qabbas answer my question here and i add more description here for you.
you can achieve this via SQL query, where The Alerts in SharePoint have been stored in Content Database Specifically at ImmedSubscriptions
and SchedSubscriptionsTable
(more in this link). based on When to Send Alert Option
Also, you can use SSOM via C# To get alerts via SPAlertCollection
to return the collection of alerts for the Web site or user or list.
SPSite oSiteCollection = SPContext.Current.Site;
SPWebCollection collWebsites = oSite.AllWebs;
foreach (SPWeb oWebsite in collWebsites)
{
SPAlertCollection collAlerts = oWebsite.Alerts;
foreach (SPAlert oAlert in collAlerts)
{
Label1.Text = SPEncode.HtmlEncode(oWebsite.Title) + " :: " +
SPEncode.HtmlEncode(oAlert.Title) + " :: " +
oAlert.User.LoginName + "<BR>";
writer.Write(strLabelText);
}
oWebsite.Dispose();
}
more about above code here.
I wrote more details about The two methods and what's each field at ImmedSubscriptions
and SchedSubscriptionsTable
denote to with detail steps at Get All User Alerts By List Name in SharePoint 2013
unfortunately , I can't find any info about the created by for alerts at this tables , only the user ID
of the user who will receive alerts.
Some information may be available at EventCache
table but I am not sure but I Checked this article that describes in details some stored procedure and other tables related to alerts SharePoint E-Mail Confirmations and Alerts (under the hood)
Note : to achieve 3,4 you can also build your own custom simple alerts based on your requirement that will do the same functionality of build in alerts via workflow and event receiver (on item not on alerts it's not applicable
) to can track your notification in flexibility manner .
this article may help you External events and alerts in SharePoint 2013