Active Directory

I didn't see an Active Directory question forum so I'm going to ask here.  If anyone knows of a better place to post the question let me know.  

Here is the senerio we have a network user training that everyone on the network must complete it is good for 1 year and then they renew it.  We set thier accounts to expire 1 year from the date of training.  However we want to be able to gather some metrics based on this.  What I would really love is a way to export the following fields from a users account.  
First Name | Last Name | Description | User logon name | Expiration Date

If I could get those fields to a access database or even an excell spreadsheet that would save so much time.  Any ideas.
Alpha-MaleAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
talphiusConnect With a Mentor Commented:
You can write a VBScript that gathers this information from AD for you, using ADSI.

MS has a tool called scriptomatic that can help you with this:
http://www.microsoft.com/technet/community/scriptcenter/tools/admatic.mspx

The AD values you will want to pull are:
First Name =  givenname
Last Name = sn
Description = description
Logon = userprincipalname
Expires = accountexpires

Let me know if you need further help...
0
 
Yan_westCommented:
0
 
Yan_westCommented:
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Alpha-MaleAuthor Commented:
Do I need to have access to the domain controller?  
0
 
Yan_westCommented:
I did it on the domain controller personnaly... Don't think it would work on an xp domain member computer.. not sure, did not try it..
0
 
Alpha-MaleAuthor Commented:
I still have no idea how to do this.  It needs to be done on a workstation.
0
 
exx1976Commented:
This could be done very easily using VBScript.  But..  Why do you need to do it on a workstation??  All of my scripts run directly on the DCs or the Exchange Server..  It's WAY easier to code them that way...    ??
0
 
Alpha-MaleAuthor Commented:
talphius,

Your real close to what I need.  We already have a VBS that is ran as a login script.  Below is an part of the script.  It all outputs to a log file.  At best I want to add what you've mentioned to output to a separate log file and not create duplicate entries.  Also as I'm working with this how do I test this without puting it out into production.  I'm new to VB the most I've written is some Macros in excel.
0
 
Alpha-MaleAuthor Commented:
talphius,

 are you still willing to keep helping?
0
 
talphiusCommented:
Sure, I'll do the best I can - What exactly do you need?
0
 
Alpha-MaleAuthor Commented:
The need has passed and I'm going to give you the points for the time you spent.  I may need to do something else here soon.  It's kinda a database that already exists and can't be changed. They need a web front-end and the ability to input using a scantron scanner.  Does that sound interesting?  If you don't want the points you tell me what to do with them.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.