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
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
ASKER
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
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.
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.
In most networks DHCP is used and that change for the IP address for users in many cases.
ASKER
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
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
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.