H
H0MELY
Thank you in advance for your help. Basically what is happening is that
after much harping, my department is going to start analyzing the access
statistics from the website. This is good news, but the bad news is that up
until recently there were no statistics to get at all and the server is not,
and will not, be running any statistical software anytime soon. What is
basically being delivered to me is a table that contains Action Date-Time,
Session Reference, IP, Browser, USERID, USER, Session Start Date-Time and
Action.
What I would like to ascertain is the number of Concurrent Users (users on
at the same time). I know this isn't going to be exact, but I think it is
important to get an idea. I can easily get session a sessions begin time and
last activity. The problem is getting all of teh intersections. In my head
I can picture how to do it, I just can't seem to put it into query design.
Any assistance would be GREATLY appreciated. One more thing, the date/time
stamp fields are formatted like this...6/18/2008 7:10:00 AM. It has caused
me a little bit of a headache, so I wanted to be sure and relay that. Thanks
again and I can't wait for the responses.
-john
after much harping, my department is going to start analyzing the access
statistics from the website. This is good news, but the bad news is that up
until recently there were no statistics to get at all and the server is not,
and will not, be running any statistical software anytime soon. What is
basically being delivered to me is a table that contains Action Date-Time,
Session Reference, IP, Browser, USERID, USER, Session Start Date-Time and
Action.
What I would like to ascertain is the number of Concurrent Users (users on
at the same time). I know this isn't going to be exact, but I think it is
important to get an idea. I can easily get session a sessions begin time and
last activity. The problem is getting all of teh intersections. In my head
I can picture how to do it, I just can't seem to put it into query design.
Any assistance would be GREATLY appreciated. One more thing, the date/time
stamp fields are formatted like this...6/18/2008 7:10:00 AM. It has caused
me a little bit of a headache, so I wanted to be sure and relay that. Thanks
again and I can't wait for the responses.
-john