How can I read the script contained in a report using Powershell?

Question

Hi,

In the SDK I find information on how to use Powershell to read and create scripts in custom commands and business rules, but I can not find the same for reports.

How can I access the report configuration objects to extract information like the embedded scripts for the report and custom columns?

-- Morten A. Steien

Comments

Hello Morten,

Sorry for the confusion, but we are not sure we understand what exactly you are trying to achieve. Please, describe the desired workflow in all the possible details with live examples.

---

For Custom Commands it is documented in the SDK here: https://www.adaxes.com/sdk/DefiningActionsAndConditions/ The Managing Reports section do not have similar information (that I can find ).

This is (the relevant part of) the script that I use for Custom Commands to save the script(s) to a file. I need to make a similar script for Reports

$ActionTypes = ("Conditions", "Actions", "ElseIfConditionedActions", "ElseActions")
foreach ($ActionType in $ActionTypes) {
  foreach ($Action in $ActionSet.$ActionType) {
    $NotFound = $true
    if ($Action.Class -eq "adm-ScriptCondition") {
      $ActionCommand = $Action.GetCondition()
      $NotFound = $false
    }
    if ($Action.Class -eq "adm-RunScriptAction") {
      $ActionCommand = $Action.GetAction()
      $NotFound = $false
    }
    if ($NotFound) { continue }
    $ScriptContent = $ActionCommand.Script
    $ScriptContent | Out-File -FilePath ($BaseDirectory + "$ScriptName`.ps1") -Encoding utf8
  }
}

Answer 1

Hello Morten,

Thank you for clarifying. You need to bind to the report and then use the corresponding properties to obtain the script used to generate the report. The script will look like below. You can check section API documentation\ADSI provider\Reports of our SDK for details.

[Reflection.Assembly]::LoadWithPartialName("Softerra.Adaxes.Adsi")

$reportDN = "CN=My Report,CN=Reports,CN=Reports Root,CN=Configuration Objects,CN=Adaxes Configuration,CN=Adaxes" # TODO: modify me

# Connect to Adaxes service
$ns = New-Object "Softerra.Adaxes.Adsi.AdmNamespace"
$service = $ns.GetServiceDirectly("localhost")

# Get report generator
$report = $service.OpenObject("Adaxes://$reportDN", $null, $null, 0)
$reportConfig = $report.GetConfiguration()

# Get report script
 $reportScript = $reportConfig.Generator.Script

Comments

Perfect! Thank you for your excellent help. :)