Karmez
asked on
Scripting query
I have been asked to provide a report containing the below for a windows 2003 domain with exchange 2007 is there a script / query that can be run to provide the desired report and export to csv ?
1. Number of user accounts in AD
2. Names of users in current AD (to include Firstname, LastName, SAMACCOUNTNAME and UPN Name)
3. Last logon details of user account in current AD
4. Current AD security Groups (Global, Universal and Domain) including group membership
5. Current mail enabled Distribution group names and membership
6. List of mail enabled contacts in current AD (to include Firstname, LastName, Primary SMTP address etc etc)
7. Current Mailbox names (Site by Site). i.e. list of user mailbox names per mailbox server at each site
8. Current Mailbox sizes
9. Current Mailbox type (User or shared)
10. Current Mailbox sharing (Who has access to who’s mailbox’s). i.e. which user has collaboration/sharing to another mailbox
11. Current Exchange X500 address of each user
12. Current Primary SMTP address of each user
13. All proxy addresses associated to each user mailbox
1. Number of user accounts in AD
2. Names of users in current AD (to include Firstname, LastName, SAMACCOUNTNAME and UPN Name)
3. Last logon details of user account in current AD
4. Current AD security Groups (Global, Universal and Domain) including group membership
5. Current mail enabled Distribution group names and membership
6. List of mail enabled contacts in current AD (to include Firstname, LastName, Primary SMTP address etc etc)
7. Current Mailbox names (Site by Site). i.e. list of user mailbox names per mailbox server at each site
8. Current Mailbox sizes
9. Current Mailbox type (User or shared)
10. Current Mailbox sharing (Who has access to who’s mailbox’s). i.e. which user has collaboration/sharing to another mailbox
11. Current Exchange X500 address of each user
12. Current Primary SMTP address of each user
13. All proxy addresses associated to each user mailbox
ASKER
Unfortunately I don't think I will be able to install any third party tools in the environment so I was looking for a script to do it - plus I need to get it to CSV which is only available if I purchase the tool. I will keep the link though as it does look useful
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Footech thanks for the advice I will try this later today
Cjwdev | AD Info - Active Directory Reporting www.cjwdev.co.uk/Software/ADReportingTool/Info.html