Re: No data available for this statistic (email sent/received) Sbs usage report

From: javerity@xxxxxxxxxxx
Date: Tue, 05 Jun 2007 13:57:52 -0700

On 31 May, 08:32, v-ter...@xxxxxxxxxxxxxxxxxxxx (Terence Liu [MSFT])
wrote:

Hello James,

This is a broken thread. I wil do it with you in the original thread.

Thanks.

Best regards,

Terence Liu(MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! -www.microsoft.com/security

=====================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
checkhttp://support.microsoft.comfor regional support phone numbers.

Any input or comments in this thread are highly appreciated.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| From: javer...@xxxxxxxxxxx
| Newsgroups: microsoft.public.windows.server.sbs
| Subject: Re: No data available for this statistic (emailsent/received)
Sbs usage report
| Date: 30 May 2007 11:29:30 -0700
| Organization:http://groups.google.com
| Lines: 378
| Message-ID: <1180549770.582605.218...@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
| References: <1176407847.868942.211...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
| <1180433971.259982.290...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
| <VTjUy3qoHHA.5...@xxxxxxxxxxxxxxxxxxxxxx>
| NNTP-Posting-Host: 86.4.58.180
| Mime-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-1"
| Content-Transfer-Encoding: quoted-printable
| X-Trace: posting.google.com 1180549773 7986 127.0.0.1 (30 May 2007
18:29:33 GMT)
| X-Complaints-To: groups-ab...@xxxxxxxxxx
| NNTP-Posting-Date: Wed, 30 May 2007 18:29:33 +0000 (UTC)
| In-Reply-To: <VTjUy3qoHHA.5...@xxxxxxxxxxxxxxxxxxxxxx>
| User-Agent: G2/1.0
| X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;
.NET CLR 1.0.3705; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
| Complaints-To: groups-ab...@xxxxxxxxxx
| Injection-Info: g4g2000hsf.googlegroups.com; posting-host=86.4.58.180;
| posting-account=P7LODA0AAABeDz5dLy0p_SAeqBDjy9JP
| Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed0
0.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!border1.nntp.dca
.giganews.com!nntp.giganews.com!postnews.google.com!g4g2000hsf.googlegroups.
com!not-for-mail
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:40420
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| On 30 May, 11:14, v-ter...@xxxxxxxxxxxxxxxxxxxx (Terence Liu [MSFT])| wrote:

| > Hello James,
| >
| > Thanks for kind update.
| >
| > The information about e-mail usage is collected from the Exchange
message
| > tracking log files. On the SBS server, click Start, click Run, type
| > "\\localhost\<servername>.log" (without the quotation marks) and click
OK.
| > Are there any log files in the shared folder?
| >
| > Then, check if message tracking is enabled:
| >
| > A. Start Exchange System Manager.
| >
| > B. Expand Servers, right-click <ServerName>, and then click
"Properties".
| >
| > C. On the "General" tab, is the option "Enable message tracking"
checked?
| >
| > D. If not, please check it, and wait a moment to let log files to be
| > created.
| >
| > E. Then view the report again. Do you get the same issue?
| >
| > If we can not resolve the issue after we perform the above steps, please
| > kindly help me collect some information for further investigation:
| >
| > Please send me the MSSBSSSR.log and the DBAccess.log in the
| > %SBSProgramDir%\Support folder. Myemailaddress is v-ter...@xxxxxxxxxxxxx
| >
| > Thank you for your time.
| >
| > I'm looking forward to your update.
| >
| > Best regards,
| >
| > Terence Liu(MSFT)
| >
| > Microsoft CSS Online Newsgroup Support
| >
| > Get Secure! -www.microsoft.com/security
| >
| > =====================================================
| > This newsgroup only focuses on SBS technical issues. If you have issues
| > regarding other Microsoft products, you'd better post in the
corresponding
| > newsgroups so that they can be resolved in an efficient and timely
manner.
| > You can locate the newsgroup
here:http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
| >
| > When opening a new thread via the web interface, we recommend you check
the
| > "Notify me of replies" box to receive e-mail notifications when there
are
| > any updates in your thread. When responding to posts via your
newsreader,
| > please "Reply to Group" so that others may learn and benefit from your
| > issue.
| >
| > Microsoft engineers can only focus on one issue per thread. Although we
| > provide other information for your reference, we recommend you post
| > different incidents in different threads to keep the thread clean. In
doing
| > so, it will ensure your issues are resolved in a timely manner.
| >
| > For urgent issues, you may want to contact Microsoft CSS directly.
Please
| > checkhttp://support.microsoft.comforregional support phone numbers.
| >
| > Any input or comments in this thread are highly appreciated.
| > =====================================================
| >
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| > --------------------
| > | From: javer...@xxxxxxxxxxx
| > | Newsgroups: microsoft.public.windows.server.sbs
| > | Subject: Re: No data available for this statistic (emailsent/received)
| > Sbs usage report
| > | Date: 29 May 2007 03:19:31 -0700
| > | Organization:http://groups.google.com
| > | Lines: 224
| > | Message-ID: <1180433971.259982.290...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
| > | References: <1176407847.868942.211...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
| > | <rpGJn9YfHHA.5...@xxxxxxxxxxxxxxxxxxxxxx>
| > | NNTP-Posting-Host: 81.101.87.221
| > | Mime-Version: 1.0
| > | Content-Type: text/plain; charset="iso-8859-1"
| > | Content-Transfer-Encoding: quoted-printable
| > | X-Trace: posting.google.com 1180433971 27854 127.0.0.1 (29 May 2007
| > 10:19:31 GMT)
| > | X-Complaints-To: groups-ab...@xxxxxxxxxx
| > | NNTP-Posting-Date: Tue, 29 May 2007 10:19:31 +0000 (UTC)
| > | In-Reply-To: <rpGJn9YfHHA.5...@xxxxxxxxxxxxxxxxxxxxxx>
| > | User-Agent: G2/1.0
| > | X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;
SV1;
| > .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
| > | Complaints-To: groups-ab...@xxxxxxxxxx
| > | Injection-Info: q66g2000hsg.googlegroups.com;
posting-host=81.101.87.221;
| > | posting-account=P7LODA0AAABeDz5dLy0p_SAeqBDjy9JP
| > | Path:
| >
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS02.phx.gbl!newsfeed
0
| >
0.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews..c
o
| >
m!out01b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.
u
| >
senetserver.com!postnews.google.com!q66g2000hsg.googlegroups.com!not-for-ma
i
| > l
| > | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:40010
| > | X-Tomcat-NG: microsoft.public.windows.server.sbs
| > |
| > | On 13 Apr, 06:48, v-ter...@xxxxxxxxxxxxxxxxxxxx (Terence Liu [MSFT])|
wrote:
| >
| > | > Hello James,
| > | >
| > | > Thanks for posting here.
| > | >
| > | > According to your description, I understand that the SBS usage
report
| > | > displays "There is no data available for this statistic". If I have
| > | > misunderstood the problem, please don't hesitate to let me know.
| > | >
| > | > Based on my experience, the issue might be a bit complex than it
| > appears.
| > | > To troubleshoot the issue, we usually need to spend quite some time
to
| > | > perform steps to find the problem cause due to complexity on
technical
| > | > side. I appreciate your understanding and cooperation during the
| > | > troubleshooting process.
| > | >
| > | > Based on my research, please perform the following steps to isolate
this
| > | > issue:
| > | >
| > | > Step 1: Please follow the steps below to install SQL MSDE 2000 SP4.
| > | >
| > | > 1. Download the package:
| > | >
| > | >
| >
SQL2000.MSDE-KB884525-SP4-x86-ENUhttp://www.microsoft.com/downloads/info.asp
| > x?na=46&p=6&SrcDisplayLang...
| > | >
| >
CategoryId=&SrcFamilyId=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&u=http%3a%2f%2

| > f
| > | >
| >
download.microsoft.com%2fdownload%2f1%2fb%2fd%2f1bdf5b78-584e-4de0-b36f-c44

| > e
| > | > 06b0d2a3%2fSQL2000.MSDE-KB884525-SP4-x86-ENU.EXE
| > | >
| > | > 2. Double click the package and specify a folder for it to extract
files
| > | > (such as C:\SQLSP4).
| > | > 3. Open MCD prompt and go to C:\SQLSP4\MSDE.
| > | > 4. Run the following command to start setup:
| > | >
| > | > Setup /upgradesp sqlrun BLANKSAPWD=1 INSTANCENAME=SBSMonitoring
| > | > DISABLENETWORKPROTOCOLS=1 /L*v "C:\Program Files\Microsoft
| > | > Integration\Windows Small Business Server
2003\Logs\Monitoring_MSDE.Log"
| > | > REBOOT=ReallySuppress /qn
| > | >
| > | > 5. After the setup, please check whether the problem persists.
| > | >
| > | > Step 2: Completely reinstall the monitoring component.
| > | >
| > | > Since you've already tried reinstalling the monitoring and the
problem
| > | > persists, please follow these steps to completely reinstall it
again.
| > | >
| > | > - Uninstall the SBS Monitoring component
| > | >
| > | > 1. Click Start, click Control Panel, and then click Add or Remove
| > Programs.
| > | > 2. Select Windows Small Business Server 2003 and then click
| > Change/Remove.
| > | > The Setup Wizard appears.
| > | > 3. Click Next to start the wizard.
| > | > 4. On the Windows Configuration page, click Next.
| > | > 5. On the Component Selection page, in the Action column, change
Server
| > | > Tools to Maintenance, change Monitoring component to Remove, and
then
| > click
| > | > Next.
| > | > 6. On the Component Summary page, click Next.
| > | > 7. Click Finish.
| > | >
| > | > - Uninstall Microsoft SQL Server Desktop Engine (SBSMONITORING)
| > | >
| > | > In Add or Remove Programs, select Microsoft SQL Server Desktop
Engine
| > | > (SBSMONITORING) and then click Remove. A dialog box appears. To
confirm
| > | > that you want to remove, click Yes.
| > | >
| > | > - Delete Registry Keys
| > | >
| > | > 1. Delete
| > | > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SmallBusinessServer\Monitoring
| > | > 2. Delete
| > | > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\SBSMONITORING
| > | >
| > | > - Delete IIS Virtual Directory
| > | >
| > | > 1. Open IIS, expand servername, Web Sites, Default Web Site
| > | > 2. Delete Monitoring
| > | >
| > | > - Rename Folders
| > | >
| > | > 1. Rename C:\Program Files\Microsoft SQL Server\MSSQL$SBSMONITORING
to
| > | > MSSQL$SBSMONITORING.OLD
| > | > 2. Rename c:\inetpub\monitoring to monitoring.old
| > | >
| > | > - Install the Monitoring component
| > | >
| > | > 1. In Add or Remove Programs, select Windows Small Business Server
2003
| > and
| > | > then click Change/Remove. The Setup Wizard appears.
| > | > 2. Click Next.
| > | > 3. On the Windows Configuration page, click Next.
| > | > 4. On the Component Selection page, in the Action column, change
Server
| > | > Tools to Maintenance, change Monitoring component to Install, and
then
| > | > click Next.
| > | > 5. On the Logon Information page, click Next.
| > | > 6. On the Component Summary page, click Next.
| > | > 7. Click Finish.
| > | >
| > | > I appreciate your time and cooperation. If anything is unclear,
please
| > feel
| > | > free to let me know.
| > | >
| > | > Have a nice day!
| > | >
| > | > Best regards,
| > | >
| > | > Terence Liu(MSFT)
| > | >
| > | > Microsoft CSS Online Newsgroup Support
| > | >
| > | > Get Secure! -www.microsoft.com/security
| > | >
| > | > =====================================================
| > | > This newsgroup only focuses on SBS technical issues. If you have
issues
| > | > regarding other Microsoft products, you'd better post in the
| > corresponding
| > | > newsgroups so that they can be resolved in an efficient and timely
| > manner.
| > | > You can locate the newsgroup
| > here:http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
| > | >
| > | > When opening a new thread via the web interface, we recommend you
check
| > the
| > | > "Notify me of replies" box to receive e-mail notifications when
there
| > are
| > | > any updates in your thread. When responding to posts via your
| > newsreader,
| > | > please "Reply to Group" so that others may learn and benefit from
your
| > | > issue.
| > | >
| > | > Microsoft engineers can only focus on one issue per thread.
Although we
| > | > provide other information for your reference, we recommend you post
| > | > different incidents in different threads to keep the thread clean.
In
| > doing
| > | > so, it will ensure your issues are resolved in a timely manner.
| > | >
| > | > For urgent issues, you may want to contact Microsoft CSS directly.
| > Please
| > | > checkhttp://support.microsoft.comforregionalsupport phone numbers.
| > | >
| > | > Any input or comments in this thread are highly appreciated.
| > | > =====================================================
| > | >
| > | > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| > | >
| > | > --------------------
| > | > | From: javer...@xxxxxxxxxxx
| > | > | Newsgroups: microsoft.public.windows.server.sbs
| > | > | Subject: No data available for this statistic
(emailsent/received) Sbs
| > | > usage report
| > | > | Date: 12 Apr 2007 12:57:28 -0700
| > | > | Organization:http://groups.google.com
| > | > | Lines: 23
| > | > | Message-ID:
<1176407847.868942.211...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
| > | > | NNTP-Posting-Host: 86.4.58.180
| > | > | Mime-Version: 1.0
| > | > | Content-Type: text/plain; charset="iso-8859-1"
| > | > | X-Trace: posting.google.com 1176407848 8452 127.0.0.1 (12 Apr 2007
| > | > 19:57:28 GMT)
| > | > | X-Complaints-To: groups-ab...@xxxxxxxxxx
| > | > | NNTP-Posting-Date: Thu, 12 Apr 2007 19:57:28 +0000 (UTC)
| > | > | User-Agent: G2/1.0
| > | > | X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
5.1;
| > SV1;
| > | > .NET CLR 1.0.3705; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
| > | > | Complaints-To: groups-ab...@xxxxxxxxxx
| > | > | Injection-Info: p77g2000hsh.googlegroups.com;
| > posting-host=86.4.58.180;
| > | > | posting-account=P7LODA0AAABeDz5dLy0p_SAeqBDjy9JP
| > | > | Path:
| > | >
| >
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed

| > 0
| > | >
| >
0.sul.t-online.de!t-online.de!news.glorb.com!postnews.google.com!p77g2000hs

| > h
| > | > .googlegroups.com!not-for-mail
| > | > | Xref: TK2MSFTNGHUB02.phx.gbl
microsoft.public.windows.server.sbs:29653
| > | > | X-Tomcat-NG: microsoft.public.windows.server.sbs
| > | > |
| > | > | Hi,
| > | > |
| > | > | I am sorry if I am posting a similar message to other posts but I
too
| > | > | am getting this message "No data available for this statistic" in
the
| > | > |emailsent and received section of the SBS usage report, The rest of
| > | > | the data in this report is correct.
| > | > |
| > | > | I have tried resetting the monitoring and reporting component by
re
| > | > | running the wizard and I have also tried the solution as indicated
| > | > | from Brandy Nee but this has not worked either.
| > | > |
| > | > | The server in question is Windows 2003 SBS SP1. The reporting had
been
| > | > | working fine up until about 2 Months ago.
| > | > |
| > | > | The server is required almost all the time and I can only afford
| > | > | minimal downtime.
| > | > |
| > | > | can anyone suggest anything that may help restore the report data
| > | > |
| > | > | Thank you
| > | > |
| > | > | James
| > | > |
| > | > |
| > | Hi Terence,
| > | Sorry about the delay in trying your solution, I have carried out all
| > | the steps and reinstalled Monitoring and reporting but the problem
| > | still exists.
| > | as a note the server is running SBS service pack 1. the install disks
| > | have SBS service pack 1 integrated, It did not ask me to reservice
| > | pack after I reinstalled the components.
| > | I hope this is of some help
| > | Thanks
| > | I look forward to your reply
| > | James
| > |
| Hi Terence,
| I have looked at the message tracking settings and these appear to be
| in order but stilll noemailsent/recieved data I am afraid, anyway I
| have emailed you the log files as requested.
| Thanks for your help
| James
|

Hi Terence,

I think you may have emailed me the other day but unfortunately I must
have deleted the email. is it possible you can resend it, You
mentioned something about a microsoft error reporting tool I think.

Another thing that occurred to me is that we run Exclaimer archiver on
the server which uses envelope journalling and then archives the
emails in a SQL database, I just wondered whether this would be
anything to do with the problems I am experiencing.

Thanks

James

.

Follow-Ups:
- Re: No data available for this statistic (email sent/received) Sbs usage report
  - From: Terence Liu [MSFT]

Prev by Date: Windows XP guide for beginners
Next by Date: Re: ETA on SP2 for SBS
Previous by thread: Windows XP guide for beginners
Next by thread: Re: No data available for this statistic (email sent/received) Sbs usage report
Index(es):
- Date
- Thread

Relevant Pages

RE: CEICW KEEPS GIVING ERRORS
... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ...
(microsoft.public.windows.server.sbs)
Re: adprep not working on W2k server
... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ... OS that is on the disc you would use to install the 2003 Server? ...
(microsoft.public.windows.server.sbs)
Re: CEICW fails on Firewall config
... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
(microsoft.public.windows.server.sbs)
RE: mail enabled contacts sent to wrong mailbox in Exchange 2003
... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ... <Microsoft CSS Online Newsgroup Support ...
(microsoft.public.windows.server.sbs)
Re: IIS logs for Exchange/OMA Access
... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ...
(microsoft.public.windows.server.sbs)