Lengkap

Powershell Script to Query Exchange and add data to SQL Server

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

Kemahiran: Pelayan Microsoft SQL, Powershell, Skrip Kekerang

Lihat lagi: powershell bulk insert into sql, powershell insert into sql, powershell insert array into sql table, powershell insert variable into sql table, powershell results to sql table, powershell insert dataset into sql table, sql server powershell examples, powershell connect to sql server, write code transfer data sql server excel, save image data sql server 2005, front end collecting data sql server, import csv data sql server table, synchronize data sql server aspnet, sample code import data sql server, data sql server 2005 database console application, quickbooks import data sql server, dump xml data sql server, simple vbscript display table data sql server, insert data sql server using visual basic net, spatial data sql server example

Tentang Majikan:
( 2 ulasan ) Leamington Spa, United Kingdom

ID Projek: #17674309

Dianugerahkan kepada:

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 dalam sehari
(23 Ulasan)
5.5

4 pekerja bebas membida secara purata £28 untuk pekerjaan ini

ygenchik

Dear Employer, I am an owner of a boutique software engineering company. We specialize in the Microsoft development and use powershell as a standard scripting language, both in Azure orchestration and as an ETL t Lagi

£25 GBP dalam sehari
(1 Ulasan)
1.0
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 f Lagi

£55 GBP dalam 2 hari
(0 Ulasan)
0.0
donchogeorgiev

- I use SQL and powershell daily - If awarded, I can complete, test and send the script in a few hours

£18 GBP dalam sehari
(0 Ulasan)
0.0