locked
VB Script RRS feed

  • Question

  • Hi all, I need to write a script to pull AD attributes based on an input text and output the results to Excel or CSV. I need to be able to, at the most basic level, get display name and the enabled/disabled status of the account. I the account is not found, the output would need to denote that as well.

    I need to able to hand this off to someone who does not have Powershell, so I also need this to be a VBS file.

    Any help would be greatly appreciated!!!!

    • Moved by Bill_Stewart Tuesday, July 21, 2015 9:04 PM This is not "scripts on demand"
    Tuesday, June 16, 2015 11:17 AM

Answers

All replies

  • It sounds like you might be searching for a user object in AD. How is the input text used to query for the user?

    Richard Mueller - MVP Directory Services

    Tuesday, June 16, 2015 1:00 PM
  • Well, not exactly. :) The input file would be text file that contains the users. So, the context is, I work for a company who has decided to disable a user's account when they miss an online  training deadline. At any given point, they may say "give us the current account status (enabled or disabled) going back to November of last year of users that were disabled due to missed training.

    So, I want to take the list of users, stick them in a text file, run a script that will

    1. Grab the Display name and account status and

    2. For users that are no longer here write "User has been terminated"

    And output that to a CSV file.

    Does that make more sense?

    Tuesday, June 16, 2015 1:25 PM
  • Well, this isn't a "script on demand" forum. The script request form is here:

    https://gallery.technet.microsoft.com/scriptcenter/site/requests


    -- Bill Stewart [Bill_Stewart]

    • Proposed as answer by Mike Laughlin Tuesday, June 30, 2015 7:08 PM
    • Marked as answer by Bill_Stewart Tuesday, July 21, 2015 9:03 PM
    Tuesday, June 16, 2015 2:07 PM
  • Thanks Bill!
    Tuesday, June 16, 2015 9:55 PM