Solved

How do I view ImmedSubscriptions Database Table?

Posted on 2012-03-16
17
827 Views
Last Modified: 2012-03-28
I'm having a problem with my sharepoint alerts and one solutions I found says I should

"Next thing I checked were the database tables, after I read about the same problem in this newsgroup posting. The following four tables in the content database contain entries related to the alert emails:"

Problem is I don't know how to check the immedsubscriptions table.  Can anyone help me?
0
Comment
Question by:Erin_J
  • 9
  • 8
17 Comments
 
LVL 29

Expert Comment

by:QPR
ID: 37731276
What do you need to do once you find the table? Altering any data at the sql server level is unsupported in sharepoint and may void any support you get from MS... besides anything you change may be overwritten in a future hotfix or service pack.

What problems are you have with alerts?
0
 
LVL 29

Accepted Solution

by:
QPR earned 500 total points
ID: 37731285
To answer your questiuon though, the table is in the content database so will depend on what the naming convention is. Will more than likely have the word content in the database name.
You'll need to use sql server tools to look at the table contents if you *really* want to go down that road
0
 

Author Comment

by:Erin_J
ID: 37731352
I'm just trying to track down why my alerts aren't working and I wanted to see if they were being logged.  I don't want to do anything with it I just want to confirm it's being logged.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 29

Expert Comment

by:QPR
ID: 37731359
You might be better off reading the sharepoint logs with a log viewer to try and find out why alerts aren't working
This is my viewer of choice

http://archive.msdn.microsoft.com/ULSViewer

So nobody gets alerts or some? Do people get a confirmation once they set up an alert?
0
 

Author Comment

by:Erin_J
ID: 37737503
Nobody gets alerts or confirmations.  But we can click on someones name and email them from within the site.
0
 

Author Comment

by:Erin_J
ID: 37737507
btw.  I downloaded that viewer this morning.  Gonna look and see what I can find out through that.
0
 

Author Comment

by:Erin_J
ID: 37737550
Also the Timer Job shows to be 100% see attached snapshot but I don't know what this Watson Policy update is.
timer-status.bmp
0
 
LVL 29

Expert Comment

by:QPR
ID: 37739226
Watson policy auto uploads error info so this could also point to connectivity problems. You say you can email by clicking on a name - you mean your email clients creates an email? That is different.

Do you have your email server set up under servers in this farm (central admin)?
0
 

Author Comment

by:Erin_J
ID: 37747251
Sorry for the delay but had a medical emergency that has kept me away the last 2 days.  But to answer your question
When I go to People - User Information I can click the hyper link and it works.  (see attached)

In Central Administration - I believe my email is setup incoming and outgoing but not sure how to confirm.  It appears to be right.

I don't use the Exchange feature in SBS2008.  We use a third party pop account and so I never setup exchange.
user-information.bmp
0
 
LVL 29

Expert Comment

by:QPR
ID: 37749531
Clicking the email address will just result in normal behaviour where your email program will create qa new email addressed to the person you clicked on... this is nothing to do with sharepoint.

You need to tell sharepoint the server address of your outgoing email server (regardless of whether it is on your network or a 3rd party server on the internet or if you have a local SMTP server that can relay).

Go to central admin -> System settings -> Configure outgoing e-mail settings

This is where you tell sharepoint where to send emails so they can be delievered
0
 

Author Comment

by:Erin_J
ID: 37750184
Yes I've done that.  It appears to be set up right.
see attached
email-outgoing.bmp
0
 
LVL 29

Expert Comment

by:QPR
ID: 37750246
and your sharepoint farm has access to the outside world?

If so, you might need to contact the email provider and see if they have any record of emails getting to them from your host.

Also check the windows event viewer and see if there are any errors there regarding smtp/email

If you aren't using a ULS log viewer then I'd try this one
http://archive.msdn.microsoft.com/ULSViewer

Open it up, point to ULS log, set up an alert and look at the messages in the log
0
 

Author Comment

by:Erin_J
ID: 37750263
I believe it has access to the outside world.
I will call my email provider in the morning to check with them.
I downloaded that viewer the other day but I haven't found any logs regarding alerts.

I'll let you know tomorrow how it turns out.
0
 

Author Comment

by:Erin_J
ID: 37757516
I've loaded the viewer but I'm don't know how to use it.   I am trying to load the ULS file to view it and I select "Use ULS feed from default log file directory" and nothing shows up.  What am I doing wrong.
0
 
LVL 29

Expert Comment

by:QPR
ID: 37758675
Have you changed the default log directory? I normally set mine to a drive other than C for performance.
You should a choice of loading from file, uls or something else which I forget at the moment.
Uls will open the current log.
You'll see icons on the toolbar that will say whether to show high, medium etc or you can right click and select show errors only.
Are you running this on your SP server? Not a client or the SQL Server
0
 

Author Comment

by:Erin_J
ID: 37758709
SP Server
Yes I tried loading from file but nothing is there
0
 
LVL 29

Expert Comment

by:QPR
ID: 37758829
Try uls not file
If nothing then check the logs folder under the "14" folder
It could turn out that logging has been switched off.

Did you find anything in the windows event viewer?
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question