How to Read The MSDTC LOG.

Hello,
We have an application which uses DTC they are seeing some errors in the
application log and at the same time they want to see if there are any errors
in the MSDTC log but i am not sure how to open the file and with what .it
seems like
text file but when i open it i can't read it .is there anything i should do
Thanks ....
The log file is encrypted and the format is not publicly
available. The files are just used by DTS to manage
transactions and aren't really meant for viewing outside of
what the service itself reads and uses.
Errors with the service itself should show up in the windows
event logs. You may also want to check the RPC service and
make sure you don't have any errors with that as DTS depends
on and uses this service. Overall though, you may be better
off posting the errors you are seeing and going from there.
-Sue
On Thu, 18 Nov 2004 13:49:13 -0800, "chinn"
<chinn@.discussions.microsoft.com> wrote:

>Hello,
>We have an application which uses DTC they are seeing some errors in the
>application log and at the same time they want to see if there are any errors
>in the MSDTC log but i am not sure how to open the file and with what .it
>seems like
>text file but when i open it i can't read it .is there anything i should do
>Thanks ....
|||Oops...those references should be DTC not DTS.
-Sue
On Thu, 18 Nov 2004 17:12:55 -0700, Sue Hoegemeier
<Sue_H@.nomail.please> wrote:
[vbcol=seagreen]
>The log file is encrypted and the format is not publicly
>available. The files are just used by DTS to manage
>transactions and aren't really meant for viewing outside of
>what the service itself reads and uses.
>Errors with the service itself should show up in the windows
>event logs. You may also want to check the RPC service and
>make sure you don't have any errors with that as DTS depends
>on and uses this service. Overall though, you may be better
>off posting the errors you are seeing and going from there.
>-Sue
>On Thu, 18 Nov 2004 13:49:13 -0800, "chinn"
><chinn@.discussions.microsoft.com> wrote:

How to Read The MSDTC LOG.

Hello,
We have an application which uses DTC they are seeing some errors in the
application log and at the same time they want to see if there are any error
s
in the MSDTC log but i am not sure how to open the file and with what .it
seems like
text file but when i open it i can't read it .is there anything i should do
Thanks ....The log file is encrypted and the format is not publicly
available. The files are just used by DTS to manage
transactions and aren't really meant for viewing outside of
what the service itself reads and uses.
Errors with the service itself should show up in the windows
event logs. You may also want to check the RPC service and
make sure you don't have any errors with that as DTS depends
on and uses this service. Overall though, you may be better
off posting the errors you are seeing and going from there.
-Sue
On Thu, 18 Nov 2004 13:49:13 -0800, "chinn"
<chinn@.discussions.microsoft.com> wrote:

>Hello,
>We have an application which uses DTC they are seeing some errors in the
>application log and at the same time they want to see if there are any erro
rs
>in the MSDTC log but i am not sure how to open the file and with what .it
>seems like
>text file but when i open it i can't read it .is there anything i should do
>Thanks ....|||Oops...those references should be DTC not DTS.
-Sue
On Thu, 18 Nov 2004 17:12:55 -0700, Sue Hoegemeier
<Sue_H@.nomail.please> wrote:
[vbcol=seagreen]
>The log file is encrypted and the format is not publicly
>available. The files are just used by DTS to manage
>transactions and aren't really meant for viewing outside of
>what the service itself reads and uses.
>Errors with the service itself should show up in the windows
>event logs. You may also want to check the RPC service and
>make sure you don't have any errors with that as DTS depends
>on and uses this service. Overall though, you may be better
>off posting the errors you are seeing and going from there.
>-Sue
>On Thu, 18 Nov 2004 13:49:13 -0800, "chinn"
><chinn@.discussions.microsoft.com> wrote:
>

How to read IIS log files to get the hit count and distinct users information?

Hi All,
I am trying to read IIS log file to find out the hit count of the
application and also to find the user base (number of different users
who access our application).
Log files are created on a daily basis.
I am using DTS package to import IIS log files into the database but I
am finding difficulty in analyzing the data. My objective is to get the
users information and hit count on a daily basis so that I can then
consolidate it to find the hit count for the w/month and users who
accessed it during that period.
Thanks,
NareshNaresh,
Can you post the destination table DDL+sample rows+desired output?
Thanks
Jerry
"Naresh" <thatsnaresh@.gmail.com> wrote in message
news:1130169058.111355.64750@.g43g2000cwa.googlegroups.com...
> Hi All,
> I am trying to read IIS log file to find out the hit count of the
> application and also to find the user base (number of different users
> who access our application).
> Log files are created on a daily basis.
> I am using DTS package to import IIS log files into the database but I
> am finding difficulty in analyzing the data. My objective is to get the
> users information and hit count on a daily basis so that I can then
> consolidate it to find the hit count for the w/month and users who
> accessed it during that period.
> Thanks,
> Naresh
>|||
Hi Jerry,
I imported the IIS log file, Sql server automatically creates the table
during the import process.
Following is the extract from IIS log file
#Software: Microsoft Internet Information Services 6.0
#Version: 1.0
#Date: 2005-10-24 07:00:26
#Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query
s-port cs-username c-ip cs(User-Agent) cs(Referer) cs-host sc-status
sc-win32-status sc-bytes cs-bytes time-taken
It contains the columns information that is being logged.
Just curious to know whether each entry in IIS log file a HIT to the
application? i.e., can I treat the number of rows in the log file as the
hit count of the application?
As already requested I also wanted to find out different users who had
accessed the application?
Thanks much in advance.
Regards,
Naresh
*** Sent via Developersdex http://www.examnotes.net ***