Powershell Script to Query Exchange and add data to SQL Server
£10-20 GBP
Completed
Posted over 5 years ago
£10-20 GBP
Paid on delivery
Hi
I need to be able to list all the email addresses both primary and alias that exist in a domain (Exchange 2010), and place those into a SQL Server table.
I would therefore like a powershell script that populates a table with:
Username, EmailAddress, PrimaryOrAliasIndicator.
The script will be run as a scheduled task once per day. Therefore, it should run without user interaction. It is quite ok to delete the table and re-enter on each occasion, rather than update.
Table code below.
Thanks
Matthew
CREATE TABLE AD_EMAILS (
USERNAME varchar(100) default '',
EMAIL_ADDRESS varchar(300) default '',
E_TYPE varchar(20) default '')
I am a Powershell & MSSQL expert and can this done for you within the day. Quick Summary: 15 years experience with small - large organisations, native English speaker. Any questions let me know.
£15 GBP in 1 day
5.0 (23 reviews)
5.5
5.5
4 freelancers are bidding on average £28 GBP for this job
Hello,
my self Bharat Khunti. I have good hands on working experience on SharePoint, PowerShell, c#, sql.
so can help you to create PowerShell scripts that run on task scheduler and insert data to database with log file.
As mentioned on Job that you want to delete database table and create new one each time PowerShell run. Right?
looking forward to your response
thanks for your time.
Bharat Khunti