Powershell Script to Query Exchange and add data to SQL Server


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.




USERNAME varchar(100) default '',

EMAIL_ADDRESS varchar(300) default '',

E_TYPE varchar(20) default '')

Beceriler: Microsoft SQL Server, Powershell, Kabuk Betiği

Daha fazlasını gör: 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

İşveren Hakkında:
( 2 değerlendirme ) Leamington Spa, United Kingdom

Proje NO: #17674309



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.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% GBP
(23 Değerlendirme)

Bu iş için 4 freelancer ortalamada £28 teklif veriyor


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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(1 Yorum)

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 Daha Fazla

£55 GBP in 2 gün içinde
(0 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)