Hi Jason All I am trying to do is track what url's on our Intranet a unique user accesses each day. There could be a couple of hundred pages.
The problem with most analytics software is that they do not capture the user's windows logon/network ID so we can identify exactly who is viewing what on the Intranet. Analytic software such as Google just captures a users IP address which is dynamic and changes each day so we can't tell what employees are accessing certain areas of the Intranet. It would be great if Coldfusion could help provide a solution for this ot if anybody knows of any 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 in a day. How many pages are we talking about? Couple dozen? Couple hundred? Couple thousand? -----Original Message----- From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk] Sent: Monday, December 07, 2009 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) = '#ucASE(user)#' This then captures user info such as Loginid Name Job Title Department IP address etc 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? And where would this query be better placed, as I don't really want to include it in each page manually. Any ideas would be welcome? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329156 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4