I have a need to create either a checklist, questionnaire or some sort of custom list in Sharepoint to track Group Ownership in Active Directory.
Currently, this form is a paper form that is printed out, given to the owner of the Group in AD to sign, effectively 'approving' the members of the group and verifying that they are allowed to be in that group.
Basically, we have some Powershell scripts that help make our lives easier. The first one reaches into a text file, grabs the A/D Group Names we have specified, and returns a .CSV of all group members, and some AD meta data such as 'Description' 'Network ID' whether the group member is 'Nested' and the 'Group Owner'. The second one grabs each .CSV file in the directory specified, and imports them into a custom list for processing.
My intentions, are to have a Workflow initiated when the .CSV is added to my Sharepoiint list, however I am not experienced enough with Sharepoint Workflows to determine the best course of action here.
The requirements are simple: I need to pull each .CSV created in a specific directory, into my list (this step is already functional) and then initiate a workflow that lists all group members with check boxes, or a similar way to select them in an email to the 'Group Owner' with an 'Approve' link somewhere....but I am not sure which tools provided by Sharepoint would be best for this particular situation.
Thank you for any and all advise!