Change the last line in the script containing EmailTemplateId to match the template id you created from step 1.

$config = Get-MSExtensionConfigData -ExtInstanceId $scriptArgs.CallerInput
$VarCount = ($config.misc.UserVars.count - 1)
$i = 0

Do{
$VarName = $config.misc.UserVars.variable[$i]
$VarValue = $config.misc.UserVars.Value[$i]
$i++
New-Variable -Name $Varname -Value $VarValue
Write-MSDebug -LogText "Variable $($VarName) = $($VarValue)`r`n"
}While ($i -le $VarCount)


$CustomKeyWords = @()
$CustomKeyWords += @{ Keyword = "[CustomEmailSubject]"; Value = $CustomEmailSubject}
$CustomKeyWords += @{ Keyword = "[CustomEmailText1]"; Value = $CustomEmailText1}
$CustomKeyWords += @{ Keyword = "[CustomEmailText2]"; Value = $CustomEmailText2}


## Get the Existing DMR Schema
$schema = (Get-MSDataminingReportSchema -ReportId $DMReportID).DataSource

## Create a new DataSource and reuse the Adv. Filter from the existing DMR
$DS = New-MSDataminingDataSource -Ids $scriptArgs.Items -FilterExpression $schema.FilterExpression -SortExpression $schema.SortExpression

## Run the DMR
$RptInfo = Get-MSDataminingReportById -ReportId $DMReportID -HeaderFormat DisplayName -DataSource $DS

## Convert the DMR results to Excel File on the Server
$DataPage1 = New-MSExcelReportEntry -data $RptInfo.Data -SheetName $InjectToTabName -IncludeColumnHeaders -ExcelTemplateResourceName $ExcelTemplateName



If($SaveLocation -ne $null){
    $OutputFile = New-MSExcelReport -Reports @($DataPage1) -SaveTo $SaveLocation
}



If($EmailTo -ne $null){
    $OutputFile = New-MSExcelReport -Reports @($DataPage1)
    Send-MSEmails -Module ManagementStudio -ToIds 1 -EmailTemplateId 1190 -CustomKeyWords $CustomKeyWords -SpreadOverHours 0 -FileAttachments $OutputFile.Reports -OverrideSendTo $EmailTo
}

Step 4 - Prepare the Excel Template

---

We need to add an Excel template that the data can be injected. Create an Excel file. Format it as you wish with headers or any static data. There should be a Excel Tab that the data will be injected in to. If that Tab does not exist in the template ManagementStudio will create the Tab as it merges the data with the template. Having the Tab already in place means that you can preformat the cells that the data will land in. The template must then be uploaded to ManagementStudio as a project resource.

• Switch to Administration->Project Resources (1)
• Click Add Resource (2) and upload the file
• Template attached (3)

Step 5 - Set up the ESM Plan

---

Finally we need an ESM Plan to select the data for the report.

• Switch to Administration->Extensions->Service Plans->[The Report Module Plans] (1). The Screenshot is an Applications plan
• Click Service Plans (2)
• Select New Service Plan (3)
• Enter the name of the Plan and click OK

• Specify the data source for the plan (1).
• Enter the evaluation rule plan (2).
• Ensure the Publisher rule (3) is set to:
• Event - On Publish
• Action - Run PowerShell
• Target - DataminingToExcel

• Scroll down to the bottom of the screen to the Service Plan Misc panel
• Ensure the variable fields are populated as required
• Specify when the Plan is to run
• Click Save at the top to commit the changes

A user can either save or email the report.

 

Variable Name	Variable Value	Description
DMReportID	23	The datamining report id created earlier.
ExcelTemplateName	ReportTemplate.xlsx	The name of the excel template saved to project resources.
InjectToTabName	Data	The name of the tab created within the template.
CustomEmailSubject	Datamining Report - All App Status	A custom email subject.
CustomEmailText1	This is the custom Email Text Relating to this report	Custom Email text 1
CustomEmailText2	This is additional custom Email text	Custom Email text 2
SaveLocation	\\ServerName\Reports	Optional. Save location where you need the report saved on a share. Not needed if you are only emailing the report.
EmailTo	Dave@Migrationstudio.com;ServiceDesk@Migrationstudio.com	; delimiter to send to multiple email addresses.

Please note, if you require another report to be emailed or saved, you'll only have to repeat Steps 1,3, 4 & 5.