Could you pont a way to obtain the volume of accesses to a customer portals (Apache/ MSSQLServer) ?

Hi Experts

Could you pont a way to obtain the volume of accesses to a customer portals (Apache/ MSSQLServer) ?

Accordingly to:
The customer enter on some site's pages with it's credentials, choosing it's name on a combo, etc...

Is it possible to obtain the access volume by using the Apache default features, f.e. ?

Thanks in advance!
Eduardo FuerteDeveloper and AnalystAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Julian HansenCommented:
The only option you have is the Apache logs - which will  record the requests on the resources. That won't give you the Customer / Vendor name though - that is a construct you place on top of the connection.

All Apache knows is that IP Address X.X.X.X requested Resource abc.html on port 80 at this particular time - and it returned the resource with a state of 200.

If you want to know about Customer access you would need to log that yourself - either recording it in your DB or using something like Google Analytics to track it for you.
Eduardo FuerteDeveloper and AnalystAuthor Commented:

Google analytics wasn't implemented here, so maybe it could be at a future release of the web app, or better, develop a feature to capture the customer and what he did and persist this at DB.
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
Whether you use GA or some other tracking (like database or other logging), you'll still require associating some unique string (like a cookie) with each session.

Keep in mind, most useful tracking will be session tracking rather than IP tracking.

Consider the situation of a large company location, like IBM Austin which NATs many 1000s of people through a single IP for outside connections to enforce security procedures.

If you only track by IP, then you lose the granularity of cases where many people behind one IP may be using your system. This also applies to anyone coming in by way of cell towers (many times) + VPNs (all the time).

Likely best to record this type of data during the login process... although... it's unclear what usefulness this data might provide.

Maybe describe how you'll be using this data, for additional suggestions.
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Eduardo FuerteDeveloper and AnalystAuthor Commented:

What I get by using IP is something to much "vague" about the customer localization, I guess.
And the worst we couldn't define who customer really is.
Julian HansenCommented:
You have two options as I mentioned before

1. GA - with custom parameters that you use to identify your clients after they logon
2. Custom solution - when client logs on you record the event in your DB along with their credentials.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Eduardo FuerteDeveloper and AnalystAuthor Commented:
Thnank you for help!
Julian HansenCommented:
You are welcome.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.