Enhancing PowerShell Script: Active Directory Update
Budget: $30 – $250 USD
Project Brief: Active Directory Update from SQL Server Data with Additional Enhancements
Project Overview: I have developed a PowerShell script that updates Active Directory (AD) based on data stored in a SQL Server database. The core functionality is working as expected, but I need a few additional modifications to complete the project.
Project Goals:
Enhance the existing script to include an account expiry date field for Active Directory accounts.
Add email notification functionality to inform specified recipients when updates are made or if any errors occur.
Current Status:
A PowerShell script is already in place and successfully updates Active Directory from SQL Server data.
Script development was initially assisted by ChatGPT, and it meets the basic requirements.
Required Modifications:
Account Expiry Date:
Modify the script to include an expiry date field for each Active Directory account based on specific criteria or data in the SQL Server table.
Ensure the syntax for updating the expiry date is correct and functional.
Email Notification Feature:
Implement an email notification system within the script to send alerts upon successful updates and/or errors.
The email should include details on the updated accounts or a summary of any issues encountered.
Challenges:
Adjusting the syntax for setting the expiry date in Active Directory is taking longer than anticipated.
Limited experience in adding email notifications to PowerShell scripts.
Assistance Required:
Guidance or hands-on support in implementing the account expiry date update and ensuring it functions correctly.
Help in adding an email notification feature, including the configuration of recipients and message details.
Outcome: Upon completion, the script should:
Seamlessly update Active Directory with SQL Server data, including account expiry dates.
Send email notifications to inform designated recipients of update statuses and any issues encountered.
Contact: Please let me know if you can assist with these modifications.
Project Overview: I have developed a PowerShell script that updates Active Directory (AD) based on data stored in a SQL Server database. The core functionality is working as expected, but I need a few additional modifications to complete the project.
Project Goals:
Enhance the existing script to include an account expiry date field for Active Directory accounts.
Add email notification functionality to inform specified recipients when updates are made or if any errors occur.
Current Status:
A PowerShell script is already in place and successfully updates Active Directory from SQL Server data.
Script development was initially assisted by ChatGPT, and it meets the basic requirements.
Required Modifications:
Account Expiry Date:
Modify the script to include an expiry date field for each Active Directory account based on specific criteria or data in the SQL Server table.
Ensure the syntax for updating the expiry date is correct and functional.
Email Notification Feature:
Implement an email notification system within the script to send alerts upon successful updates and/or errors.
The email should include details on the updated accounts or a summary of any issues encountered.
Challenges:
Adjusting the syntax for setting the expiry date in Active Directory is taking longer than anticipated.
Limited experience in adding email notifications to PowerShell scripts.
Assistance Required:
Guidance or hands-on support in implementing the account expiry date update and ensuring it functions correctly.
Help in adding an email notification feature, including the configuration of recipients and message details.
Outcome: Upon completion, the script should:
Seamlessly update Active Directory with SQL Server data, including account expiry dates.
Send email notifications to inform designated recipients of update statuses and any issues encountered.
Contact: Please let me know if you can assist with these modifications.