I am in need of a VBScript to manage AD Users and Security Groups.
What I am trying to achieve:
According to the attached .xls spreadsheets you will see in template.xls there are AD User accounts listed against Security Groups and in Template2.xls there are security groups listed against their higher level security groups.
I need a VBS that can read the columns in these .xls or .csv and then perform the folllwing;
Template.xls (.csv whichever format suits to reading info effectively)
Add Users in the users column to their corresponding security groups
Template2.xls (.csv whichever format suits to reading info effectively)
Add Security Groups listed under Level1 Group column to level2 Security Group.
there will be an empty row after a security group listing finishes. so there could be some check done for an empty row or something like that.
I am sure you guys will need more info that what i gave you above please let me know what other info you need.
Thanks in advance.