Link to home
Create AccountLog in
Avatar of Karmez
KarmezFlag for United Kingdom of Great Britain and Northern Ireland

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
Avatar of Sarang Tinguria
Sarang Tinguria
Flag of India image

Half of the Job /reports can be taken using below tool

Cjwdev | AD Info - Active Directory Reporting www.cjwdev.co.uk/Software/ADReportingTool/Info.html
Avatar of Karmez

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
Avatar of footech
footech
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Karmez

ASKER

Footech thanks for the advice I will try this later today