Get LAN ID of intranet user by SQL

We are using an older Rainbow Portal Intranet site at work which allows users to sign in (For certain permissions) or use without signing in to use default permissions.

We have set up a page which ALL associates must read. So we want to log the users name or LAN ID when they open the page, The site has a log built in , it logs the date, time, user name (which is always blank), what page they looked at and length of time they were there. This gives us everything we need except assoc name.

Is there away I can get the LAN name of the user if they have not signed into the site in the Stored Procedure.
If you have any questions I will try to answer, but trying to put code in the HTML of the site would be very difficult if possible
Niall GallagherDeveloperAsked:
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.

slightwv (䄆 Netminder) Commented:
Since it is the web server that is likely connecting to the database, unless that passes the information to the database server I don't think you can get the end user information.

If you think about it, it seems impossible and pretty dangerous:  You want the database server to reach out to the end user's browser to retrieve information about the machine.
Niall GallagherDeveloperAuthor Commented:
I never really thought of it that way and you are right that would be pretty dangerous. Oh but sorry something I forgot to put in the list of thing in the report. It returns the IP address they used. So can I query AD for who is signed on to that IP address, and/or would it use too many resources to run instantly
slightwv (䄆 Netminder) Commented:
If you have the client IP address, I would think a call out to AD should be pretty quick.  It would all depend on your systems and number of simultaneous users accessing the website.
nociSoftware EngineerCommented:
One note: You will need to do the call out at the moment the access is done.
In most networks DHCP is used and that change for the IP address for users in many cases.
Niall GallagherDeveloperAuthor Commented:
Yeah, I was thinking of doing the query to AD at the same time as the record is entered but honestly I'm not sure which way to do it
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
HTML

From novice to tech pro — start learning today.