Please find the documentation in below link.

http://azure.microsoft.com/en-gb/documentation/articles/app-insights-code-sample-export-telemetry-sql-database/

Configurations:

<Setting name="Container" value="container" />
<Setting name="Eventtype" value="PageViewPerformance" />
<Setting name="Date" value="2015-03-18" />
<Setting name="Runtype" value="DeltaBetween" />
<Setting name="RunonStart" value="true" />
<Setting name="PullfromDate" value="2015-04-13" />
<Setting name="PulltoDate" value="2015-04-13" />

<!-- Delta / Full / Date / Eventtype / Auto-Delta / Auto-DeltaEvent / AutoHourly-DeltaEvent / DeltaBetween / FullBetween -->

 

First time:

Choice 1: ParseEventtypewise (All Date & Specific Event type)

<Setting name="Eventtype" value="PageViewPerformance" />
<Setting name="Runtype" value="Eventtype" />
<Setting name="RunonStart" value="false" />

Choice 2: ParseFull (All Date & All Event type)

<Setting name="Runtype" value="Full" />
<Setting name="RunonStart" value="false" />

Note: Once published - Restart service from Azure after setting RunonStart=true, publish from VS will hung otherwise. Monitor it & switch to below Auto-Delta options (once first-time pull is done)

Delta:

Choice 1: ParseDelta (Specific Date & Specific Event type)

<Setting name="Date" value="2015-03-18" />
<Setting name="Eventtype" value="PageViewPerformance" />
<Setting name="Runtype" value="Delta" />
<Setting name="RunonStart" value="true" />

Choice 2: ParseDatewise (Specific Date & All Event type)

<Setting name="Date" value="2015-03-18" />
<Setting name="Runtype" value="Date" />
<Setting name="RunonStart" value="true" />

Choice 3: ParseDeltaBetween (Multiple Dates & Specific Event type)

<Setting name="Eventtype" value="PageViewPerformance" />
<Setting name="Runtype" value="DeltaBetween" />
<Setting name="RunonStart" value="false" />
<Setting name="PullfromDate" value="2015-04-13" />
<Setting name="PulltoDate" value="2015-04-13" />

Auto-Delta:

Choice 1: ParseDelta (Specific Event type & yesterday Date)

<Setting name="Eventtype" value="PageViewPerformance" />
<Setting name="Runtype" value="Auto-DeltaEvent" />
<Setting name="RunonStart" value="false" />

Choice 2: ParseDatewise (All Event type & yesterday Date)

<Setting name="Runtype" value="Auto-Delta" />
<Setting name="RunonStart" value="true" /> 

Choice 3: ParseHourlyDelta (Specific Event type & Last hour)

<Setting name="Eventtype" value="PageViewPerformance" />
<Setting name="Runtype" value="AutoHourly-DeltaEvent" />
<Setting name="RunonStart" value="false" />

Choice 4: ParseHourwise (All Event type & Last hour)

<Setting name="Runtype" value="AutoHourly-Delta" />
<Setting name="RunonStart" value="false" />

Last edited May 22, 2015 at 8:13 PM by arunvinoth, version 7