How to find out which report recipe is used by report

Hi Michael,

thank you for the reply.

I already came up with a solution myself, using the same approach.

I wrote a Powershell skript taht reads up all "recipeParams" for all reports and counts the appearance of each recipe.

The finall result is stored in a csv file.

Unfortunately I cannot the script as a file , so here's the CODE

[String]$IMCmd =$env:Integrity+"\bin\im.exe";

[String]$ApiViewerCmd =$env:Integrity+"\bin\mksAPIViewer.exe";

[String]$AACmd = $env:Integrity+"\bin\aa.exe";

[String]$SICmd = $env:Integrity+"\bin\si.exe";

$AArgHost = "--hostname=<myServer>"

$AArgPort = "--port=7001"

$AArgLocal = "--iplocal"

$AArgXml = "--xml"

$AArg_params = "--fields=id,recipeParams"

$CSVoutFile = "c:\temp\export.csv"

cls

&$IMCmd "diag" $AArgHost $AArgPort "--diag=viewallobjectsforsession" "on"

Write-Host "enabled visibility for all objects"

# get list of all reports

$reports = &$IMCmd "reports" $AArgHost $AArgPort

# use a dictionary to store the findings

$dict = New-Object 'system.collections.generic.dictionary[string,int]'

Write-Host "found " $reports.Count "reports , starting analysis"

foreach($report in $reports ){

  # get the reports details per report (a specific report name must be used)

  [string]$reportinfo = &$ApiViewerCmd $AArgLocal $AArgXml "im" "reports" $AArgHost $AArgPort $AArg_params "$report"

  # workaround for Powershell's inability to handle xml-version 1.1

  $newXml = $reportinfo.replace('xml version="1.1"','xml version="1.0"')

  # convert to XML document

  [xml]$xml = [xml]$newXml

  #use xpath to find the used recipe in the xml file

  Select-Xml -XPath '//Field[@name="ReportType"]/Value' $xml|

  foreach{

  $count = 1;

  if ($dict.ContainsKey($_)){

  $count = [int]$dict.get_Item($_) + 1;

  $dict.set_Item($_,$count)

  }

  else{

  $dict.Add($_,$count)

  }

  Write-Host $_ " --> " $count

  }

}

#exprt dict as csv file

$dict.GetEnumerator() | sort-object Key | export-csv $CSVoutFile

Write-Host "done - CSV exported"

&$IMCmd "diag" $AArgHost $AArgPort "--diag=viewallobjectsforsession" "off"

Write-Host "disabled visibility for all objects"