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

Eduardo Fuerte
Eduardo Fuerte used Ask the Experts™
on
Hi Experts

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

Accordingly to:
 img002
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!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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 Analyst

Author

Commented:
Hi

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 FavorFractional CTO
Distinguished Expert 2018

Commented:
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.
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

Eduardo FuerteDeveloper and Analyst

Author

Commented:
@David

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.
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
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.
Eduardo FuerteDeveloper and Analyst

Author

Commented:
Thnank you for help!
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You are welcome.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial