Last post Jun 08, 2009 06:33 PM by zhangzhu
Feb 12, 2009 12:45 PM|kldeutsch|LINK
Never done this and don't know how to begin. I need to query 9 groups in active directory for members and then take them members and add them to a datagrid where I can pull other information that deals with them. How can I do this. Please Help. Thanks
Feb 12, 2009 03:36 PM|DrivenTooFar|LINK
Try using these sites to get you started. It helped me out a lot when I was doing something similar.
It doesn't completely answer your question but it should help you to get started. Then you can post back with any questions that you have after trying to apply it.
Basically you need to filter by the group and once you get back all this information, you can store it into a DataSet (or something like that) and then link that to your DataGrid.
Feb 12, 2009 03:58 PM|kldeutsch|LINK
ok I got this to work, but I need help on the next part, I need to make this a stored procedure. How can I do this.
WHERE objectCategory = ''group''
and CN = ''NGMN SEC J6 Automation FTS''
or CN = ''NGMN SEC J6 Help Desk (Level 1)''
or CN = ''NGMN SEC J6 Help Desk (Level 2)''
or CN = ''NGMN SEC J4 Admins''
or CN = ''NGMN SEC J8 Admins''
or CN = ''NGMN SEC FMO Admins''
or CN = ''NGMN SEC RRM Admins''
or CN = ''MN Admins''
--order by displayName
Jun 08, 2009 06:33 PM|zhangzhu|LINK
You can use Enterprise Manger(SQL server 2000) or SQL server 2005 mangement studio to connect to the SQL server, then on the stored procedure to create new stored procedure, copy all your code, then past there, and then save. You may need to click the stored
procedure's properties to grant correct permissions. hope this will help.