Getting a user ip address 1

[mikelawrence]

My customers are have problems with fraud and want to store the ip address of the computer doing certain tasks and storing it with the task details in the db. The aim being to identify which PC has done things which are suspicious. Assumming fixed IP addresses is this possible?

thanks

mike

 

[acl03]

I think you need to provide more details about exactly what you are trying to track.

What type of database? What activities are you trying to monitor? What kind of database? What types of "things" and "tasks" are going on?

It is most likely possible, but it's impossible to answer without more details



Thanks,
Andrew

Hard work often pays off over time, but procrastination pays off right now!

 

[mikelawrence]

Hi, Thanks for the reply. I'm using ASP pages with SQL Server 2003. My customers are using generic logons so many people could use the same logon. I appreciate this is deeply flawed but this is the way the customer wants it. In order to identify the individual doing the transaction the customer wants to record the ip address of the pc making the transaction so in theory i want i just want to do an insert into a sql table along the lines of

INSERT INTO TransferTrackingHistory(Transfer_FromSys,Transfer_ToNbr, Transfer_Points, Transfer_Who,
Transfer_TransactionID, Transfer_Type, ipaddress)
VALUES(@frommemberId, @tomembernbr, @points, @editmemberid, @transactionid, @trackingtype, @ipaddress)

so my problem is how to get @ipaddress.

Any help is much appreciated

thanks

mike

 

[acl03]

Ok...this sounds more of a SQL server question then a windows 2003 one, right?

You might have better luck in the SQL Server Forum.

Thanks,
Andrew

Hard work often pays off over time, but procrastination pays off right now!