Powershell Script to Query Exchange and add data to SQL Server

£10-20 GBP

Imekamilika

Imechapishwa

over 5 years ago

£10-20 GBP

Kulipwa wakati wa kufikishwa

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

Kitambulisho cha mradi: 17674309

Kuhusu mradi

4 mapendekezo

Mradi wa mbali

Inatumika 6 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@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 ndani ya siku 1

5.0

(23 hakiki)

5.5

4 wafanyakazi huru wana zabuni kwa wastani £28 GBP kwa kazi hii

@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 ndani ya siku 2