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