Creating Database

        To manage AD accounts Using PHP5+Mysql5

        How to let the good idea work in practice?

        First,Export users list from exchange server 2003  into a txt file easily and modify its data just a little,so that microsoft excel can read and transfer it,then,open a blank excel file,click menu "file",select "open",search for that txt file and select it to open,modify it and save  as a csv type file. as someone knows,database has a function that allowed importing some kinds of file into a table, one kind of them is csv.At this monment,i think you have known how to do.

        Second,export member list of group including distribution group and security group,you have no any idea exporting member list unless using commant line looks like DOS mode,the data file you have exported need to modify too,at last,import the fixed file into one table of your database.there are always some kind of relationship between users list and members list.

        Basic data has been builded,Final,apply your skill of database to do it.you will find a way to realize.

 

Relational database software is a perfect tool use for AD accounts managerment.

Recently,I manage about over one thousand accounts,including windows server logon account and email account.we are currently using exchange 2003 as mail server,each account contains many information,I equate complete it with a database,so there is always a good idea in my heard,that is using relational datebase to manage our AD accounts,I select sql server2000 and mysql5 as my tool.sql server 2000 is powerful,and perform a very good compatibility,mysql5 is powerful too and it is for free, its compatibility is not as perfect as sql server2000.I am very good at Structure Query Language(SQL)
Company I work for insists using legal software which be with a lisence or for free,the boss may not buy a relational database software just for account management because of costing,so I select Mysql5 to manage accounts,in order to enjoy the result by someone who don't know mysql5 much,I will build a program using PHP5 partners Mysql5,and base on B/S structure,any one can query accounts anywhere intranet by any brower.I will not only make account management more powerful,smart,converient and effective,but also never don't increase the cost of management.