there is no solution for this! Iv checked and sharepoint doesnt store who created the alert in the wss_content database under
Youll have to make your own! sorry! I presume when you say:
We have some admins who create these alerts for other people
You mean that they must be using "SubNew.aspx", goto 12hive or 14hive -> select templates -> layouts:
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS
C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\TEMPLATE\LAYOUTS
look for the file "SubNew.aspx". You need to make a delegate control
basicly a feature that intercepts that aspx so that it will use your version instead! You need to ammend the aspx page to contain the feilds you want (user input) like so:
<wssawc:InputFormTextBox Title="fghfghfghgfhf" class="ms-input" ID="TextTitleAlert" Columns="35" Runat="server" MaxLength=255 />
and do some working out or pickup the input in codebehind.
if your like me use codebehind that is called when the user clicks on a button (create alert), it will do its stuff but also writes to the DB in a new table that contains the alert ID, alert Name, creation Time and Creator.
That should do the trick ;)
sorry there isnt an easyeir method! nothing is easy in sharepoint and this simple thing like alert creator just doesnt exist so you would need to create a custom way of recording and retriving :)