New App Question

[BobBob10]

Hi there I'm creating an App where I want to write everyones IP address and UserName to a SQL Table. However, I was wondering how to go about this.

Do I need to create a windows app that needs to be loaded onto everyones machine so that everyday I can get that information.

Any ideas.

Cheers.

Bob

 

[hwkranger]

I do this. My Application has a separate username and password than the window's login.

What I do is when they start their application, they use their user name and password for the application. The table is updated using a adodb.net recordset by pulling in the information. MSSQL already knows the window's log in, since I use window's authentication -- susername()

You don't need a separate app to do this. What you can do if you want is create a log table and log connectivity and capture the same information on a daily basis. Use aggregation just to a day or period.

Randall Vollen
National City Bank Corp.

 

[chiph]

Hi there I'm creating an App where I want to write everyones IP address and UserName to a SQL Table. However, I was wondering how to go about this.

Define "everyone".

Plus, define the conditions which will cause this to need to happen. -- will they go to a web page, run an app, log into their PC?

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[chrissie1]

I was thinking of a service. Perhaps even in stealth mode (No I won't tell you how that is done.)

Christiaan Baes
Belgium

"My new site" - Me

 

[TipGiver]

Bob,
if you mean a web app then it is very easy, using 2.0. You said about password and username: use the membership class and-or the new login controls. If the app runs to a local intanet then use windows authentication. If on internet -> forms authentications. At this point you won't need any code for this; only for the database insert statements.
If it is a web app, apart from the above, goto aspnet forum area.

 

[BobBob10]

Sorry for the late reply.

No what I need to do is to write some code that will go into the login script so that when everyone in the company logs on, the code will collect the IP address and UserName and write this information to a table in a SQL Server 2000 Database.

 

[chrissie1]

I can only guess that this information is available on your domain controller.

Christiaan Baes
Belgium

"My new site" - Me

 

[BobBob10]

Not sure!!

How would I go about doing a vb.net app which is part of the login script?