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 '')

Microsoft SQL Server

Powershell

Shell Script

Project ID: 17674309

About the project

4 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@robnicholson

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

4 freelancers are bidding on average £28 GBP for this job

@khuntibharatc

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

£55 GBP in 2 days