Windows Forum

Ask something
Discussion Locked

User Utilities

0 helpful
5 replies

by nsteere

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need recommendations for two utilities.

1. A utility/script that will take a CSV, SQL table, Excell spreadsheet (or whatever)and import/remove usernames and passwords from that list to AD, and can be done automaticaly. We will have a HUGE number of users and the list will change frequently. I guess it would be some kind of AD user manager program.

2. A utility that tells you who is logging into your Terminal servers (non-anonymously)and what OS they are running. We would need it to create a monthly report.

5 replies

by joseph moore

2. If you have Auditing of Successful Logons enabled, then all the info you need will be in the Event Viewer Security log.
You would get the following entry on a successful TS logon:

Event Type: Success Audit
Event Source: Security
Event Category: Logon/Logoff
Event ID: 528
Date: 10/29/2002
Time: 7:16:44 PM
User: MYDOMAIN\JOE
Computer: TS_SERVER
Description:
Successful Logon:
User Name: JOE
Domain: MYDOMAIN
Logon ID: (0x0,0x35EE61)
Logon Type: 2
Logon Process: User32
Authentication Package: Negotiate
Workstation Name: TS_SERVER

So, all you need to do is search through your Security log for Event ID: 528 with a Logon Type of 2. 2 is the Logon Type recorded by TS.
(note: a Logon Type of 3 is aninteractive logon over the network).
So, you could use a tool like the Event Log Viewer to parse the Security log for Event ID 528 with an optional parameter of Logon Type: 2.
Event Log Viewer can export the logs into a CSV.
You can get it here:http://www.engagent.com/Products/productsinfo.asp?product=EventLogView

NOTE: link is also at http://tinyurl.com/2b0z

hope this helps

by nsteere

Q #2 not really answered. No response to my follow-up post. Thanks for the info you did provide. If my situation was of a more limited scope, the metheds described would have been very useful.

by nsteere

I have received partial (but good)feedback so I should clartify:

We are starting a large ASP site that will be using the Microsoft SPLA licensing model, so I need any utility or 3rd party program tat will:

1. Let me generate a monthly report of users that logged in and what operating system they are using. I need this so i can submit our monthly use statements to Microsoft.

2. Due to the massive # of users being added and removed, Even a 3rd party program that will import users names/passwords from some format into AD.

I would like to know if any ASP techs who have experienced this could tell me what you used or are using.

by nsteere

That is a great way of getting the user info but I need what type of Windows OS they are using as well.

I also need to know there are any 3rd party programs to help manage user imports into AD that may be GUI based.

This discussion is closed to new replies.