, 2009 10:54 AM
To: cf-talk
Subject: RE: Basic user stats via Coldfusion
Ian,
This sounds like you should be looking at the webserver logs. If you
are using IIS, you can have it log the Windows Login info in the IIS
logs.
I don't know if Apache can or not.
Then you can use something
like you would with a database.
Steve
-Original Message-
From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk]
Sent: Tuesday, December 15, 2009 11:47 AM
To: cf-talk
Subject: RE: Basic user stats via Coldfusion
Hi Jason
All I am trying to do is track what url's on our Intranet
just like you would with a database.
Steve
-Original Message-
From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk]
Sent: Tuesday, December 15, 2009 11:47 AM
To: cf-talk
Subject: RE: Basic user stats via Coldfusion
Hi Jason
All I am trying to do is track what url's on our
-Original Message-
From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk]
Sent: Thursday, December 17, 2009 6:01 AM
To: cf-talk
Subject: RE: Basic user stats via Coldfusion
Hi Steve
I have looked in the IIS logs but for some reason the 'cs-username'
field is not being populated? Any ideas
...@gmail.com]
Sent: 07 December 2009 17:44
To: cf-talk
Subject: Re: Basic user stats via Coldfusion
Log minimal data to a database table and process the results when the
server is less busy. Possibly skip the processing until the report
needs to be generated. All you need to store is the page identifier
analytical software that would capture this
information?
-Original Message-
From: Jason Durham [mailto:jdur...@cti-stl.com]
Sent: 07 December 2009 17:32
To: cf-talk
Subject: RE: Basic user stats via Coldfusion
Am I properly restating this...
You want to track what pages each user hits
with a database.
Steve
-Original Message-
From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk]
Sent: Tuesday, December 15, 2009 11:47 AM
To: cf-talk
Subject: RE: Basic user stats via Coldfusion
Hi Jason
All I am trying to do is track what url's on our Intranet a unique user
accesses
-talk
Subject: RE: Basic user stats via Coldfusion
Ian,
This sounds like you should be looking at the webserver logs. If you
are using IIS, you can have it log the Windows Login info in the IIS
logs.
I don't know if Apache can or not.
Then you can use something like LOG Parser from Microsoft
AM
To: cf-talk
Subject: RE: Basic user stats via Coldfusion
Ian,
This sounds like you should be looking at the webserver logs. If you
are using IIS, you can have it log the Windows Login info in the IIS
logs.
I don't know if Apache can or not.
Then you can use something like LOG Parser
On our intranet I have a coldfusion script that captures a user's
network/loginid
cfset user = listLast(cgi.REMOTE_USER,\)
This variable is then run against a user table with the following
'where' clause
WHERE uPPER(NETWORK_ID) = '#ucASE(user)#'
This then captures user info such as
Loginid
How would you restrict the query so it only runs once on each page per
day for each user, instead of running every time the page is loaded?
Set a cookie that expires after 24 hours. If the cookie doesn't exist, run
the query.
And where would this query be better placed, as I don't really
11:06 AM
To: cf-talk
Subject: Basic user stats via Coldfusion
On our intranet I have a coldfusion script that captures a user's
network/loginid
cfset user = listLast(cgi.REMOTE_USER,\)
This variable is then run against a user table with the following
'where' clause
WHERE uPPER(NETWORK_ID
Log minimal data to a database table and process the results when the
server is less busy. Possibly skip the processing until the report
needs to be generated. All you need to store is the page identifier,
the user identifier, and the timestamp. You can screen out duplicate
page hits in the
Include it in the onSessionStart method of Application.cfc and it will run
only once per login.
If you really only want it once per day (if, for example, users sometimes
logout/in several times per day), then you could add a date test to the log
INSERT query:
cfquery ...
IF NOT EXISTS (
How would you restrict the query so it only runs once on each page per
day for each user, instead of running every time the page is loaded?
Set a cookie that expires after 24 hours. If the cookie doesn't exist, run
the query.
That probably wouldn't be a good idea, as you'd be setting a
15 matches
Mail list logo
