Solved

Active Directory

Posted on 2004-08-30
14
263 Views
Last Modified: 2010-04-14
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.
0
Comment
Question by:Alpha-Male
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
  • +1
14 Comments
 
LVL 15

Expert Comment

by:Yan_west
ID: 11933727
0
 
LVL 15

Expert Comment

by:Yan_west
ID: 11933740
0
 

Author Comment

by:Alpha-Male
ID: 11935133
Do I need to have access to the domain controller?  
0
Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

 
LVL 15

Expert Comment

by:Yan_west
ID: 11935161
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
 

Author Comment

by:Alpha-Male
ID: 11943130
I still have no idea how to do this.  It needs to be done on a workstation.
0
 
LVL 18

Expert Comment

by:exx1976
ID: 11943211
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
 
LVL 5

Accepted Solution

by:
talphius earned 125 total points
ID: 11943462
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
 

Author Comment

by:Alpha-Male
ID: 11943755
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
 

Author Comment

by:Alpha-Male
ID: 12385045
talphius,

 are you still willing to keep helping?
0
 
LVL 5

Expert Comment

by:talphius
ID: 12386214
Sure, I'll do the best I can - What exactly do you need?
0
 

Author Comment

by:Alpha-Male
ID: 12390916
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

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
Building a cohesive image for your brand is vital to making an impression on consumers. When the economy is tough, brands do better than unbranded  products. This can have a huge impact on your long-term profits, as the economy goes up and down.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question