I need to query AD accounts in an OU (and sub-OUs) for the both MSIIS-FTPROOT and MSIIS-FTPDIR for all accounts that have these values set. It should be a simple LDAP query but I'm open to other methods of getting the same information. What I need is the values for both objects and the corresponding account names for which the values are set. I can view the information via ADSI edit but don't want to manually check all accounts in the domain for this extended attribute.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Does the last Powershell script export only the names of the accounts that have the ADSI objects configured or does it export everything and then it just needs sorted?
Also, will running the script have any performance impact on other AD functions? If so, I can just run it at an odd time.
Thanks for the help.
Hey,
It will only show you use accounts configured in Active Directory. If you want it to look for all objects (not just User Accounts, you would switch Get-QADUser for Get-QADObject). It won't look at anything configured on a local server.
At present it exports these fields:
Name
DN
msiis-ftproot
msiis-ftpdir
Although we can add more to that if you need something specific.
> Also, will running the script have any performance impact on other AD functions?
No, it's completely safe to run at any time.
Chris
I am looking to schedule a script like this that runs and actually sets the FTPRoot and Dir values so when new users arrive I don't have to manually set these values.
Can you please advise on somekind of set-QADUser script that will query the entire AD and set this value. Maybe even a check if the value exists and only set if it doesn't to speed up the task?
Thanks if possible
Business Accounts
Answer for Membership
by: Chris-DentPosted on 2009-11-16 at 05:37:29ID: 25830040
You probably want some kind of script to deal with this. If you don't have much or any experience with Scripting you might consider getting PowerShell:
http://support.microsoft.c
If you grab that, and these:
http://www.quest.com/power
Which will, finally, allow you to run something like this:
Get-QADUser -LdapFilter "(|(msiis-ftproot=*)(msiis
What are you interested in seeing on the accounts? This will return the users Name, Distinguished Name and those two values:
Get-QADUser -LdapFilter "(|(msiis-ftproot=*)(msiis
-IncludedProperties "msiis-ftproot", "msiis-ftpdir" | Select-Object Name, DN, "msiis-ftproot", "msiis-ftpdir"
That can be exported to a CSV file for use in Excel:
Get-QADUser -LdapFilter "(|(msiis-ftproot=*)(msiis
-IncludedProperties "msiis-ftproot", "msiis-ftpdir" | `
Select-Object Name, DN, "msiis-ftproot", "msiis-ftpdir" | `
Export-CSV "SomeFile.csv"
Note that the ` character allows the single command above to span multiple lines. It must be included, but has no other purpose here.
HTH
Chris