got a html report on pki certificates expiring in 30 days .Trying to update the html code of a custom report via API but I get an error =: ( There are no key property mappings to locate a data provider.

egberto.zanon

So I  am trying to create a report on my PKI Certs about to expire.

so I managed to create a html  using the code bellow:

<#
.Synopsis
    This Tool will query the Enterprise PKI and search for Certificates that matches a specific template  that are expiring within a passed threshold and email a html report to a passed email
.Autor
    Egberto Zanon
#>

# Check if the PSPKI 3.7.2 module is installed
$Module = Get-Module -ListAvailable -Name PSPKI -RequiredVersion 3.7.2

# If not, install it from the PowerShell Gallery for the current user only
if ( -not $Module ) {
    Write-Host "Installing PSPKI 3.7.2 module..."
    Install-Module -Name PSPKI -RequiredVersion 3.7.2 -Scope CurrentUser -Confirm:$false -Force
}

# Import the module
Import-Module -Name PSPKI

# Define days to alert

$Threshold = "30"

# Define the template name ( below is a invalida sample , add yours)
$TemplateName = "1.1.1.1.1.1.123.12.1.12345678.12345678.1234567.12345678.1234567.123.1234567.1234567"


# Get the current date
$Today = Get-Date

# Get the certificates from the enterprise PKI that match the template name
$Certificates = Get-CertificationAuthority | Get-IssuedRequest -Property CertificateTemplate, NotAfter | Where-Object { $_.CertificateTemplate -eq $TemplateName }

# Filter the certificates that are expiring within the threshold
#$ExpiringCertificates = $Certificates | Where-Object {$_.NotAfter -lt $Today.AddDays($Threshold)}

# Filter the certificates that are expiring within the threshold but haven't expired yet
$ExpiringCertificates = $Certificates | Where-Object { $_.NotAfter -gt $Today -and $_.NotAfter -lt $Today.AddDays($Threshold) }

Write-Output "Found $($ExpiringCertificates.count)"
# Check if there are any expiring certificates
if ($ExpiringCertificates) {
    Write-Output "Emailing Report"
    # Create a report object with the certificate details
    $Report = $ExpiringCertificates | Select-Object RequestID, RequesterName, CommonName, NotAfter

    # Convert the report object to HTML format
    $HTMLReport = $Report | ConvertTo-Html -Title "Expiring Certificates Report" -PreContent "These are the certificates from the template that are expiring within $Threshold days on our enterprise PKI:"
}

and now I am trying  import this information to a Solarwinds report page.

so I came up with the code bellow:

$moduleName = "SwisPowerShell"
# Check if the module is available, if not, install it
if (!(Get-Module -Name $moduleName -ListAvailable)) {
    Install-Module -Name $moduleName -Force -AcceptLicense -Scope CurrentUser
}

$Securedcredential = get-credential


# Connect to the SolarWinds Information Service (SWIS) using the hostname, and  $Securedcredential 
$swis = Connect-Swis -Hostname "localhost" -Credential $Securedcredential

# Clean credentials from memory
Remove-Variable -Name Securedcredential

# Get the report ID of the report named "My Report" from the Orion.Report table
$report = Get-SwisData $swis "SELECT ReportID, Uri, Name FROM Orion.Report WHERE Name='COS PKI - Expiring Certs'"
# Assign the report ID to a variable
$ReportID = $report.ReportID
$reportUri = $report.Uri

$reportObject = Get-SwisObject $swis -Uri $reportUri

$reportObject.Type

# Define a hashtable of properties to update the report
$reportProperties = @{
    CustomHtml = "$($HTMLReport)"
}
# Update the report object with the new properties
# $swis -Uri $reportUri -Properties $reportProperties -Debug

but I am getting the error on the Set-SwisObject: There are no key property mappings to locate a data provider.

Does anyone know what should I put here to update the custom html code on the report? or this is a no no and I will have to figure out another way?
 thanks!

KMSigma.SWI

The "proper" way to do this would be to add a component monitor for the certificate expiration to the Server & Application Monitor portion and then report on the results.

---

That said - you've posed an interesting question.

Here's what I have...

Regular vanilla report, but with two HTML elements (because I was curious).

If we look at the data in Orion.Report for this report we get this:

The important thing here is the Definition field, which you can see is in an XML format.

This is what mine looks like:

	THWACK Assistance


			Subtitle for first
			Custom HTML - Part 1
			f0163394-a144-4876-9b79-8eec3314399d

			/Orion/NetPerfMon/Resources/Misc/UserHTML.ascx


					HTML
					with synchronous loading


					IsDynamicLoading
					True



			Custom HTML


			This is the second one
			Custom HTML
			11d68f21-da47-4e8e-9f52-12fd1940542b

			/Orion/NetPerfMon/Resources/Misc/UserHTML.ascx


					HTML
					It doesn't have the fun loading


					IsDynamicLoading
					False



			Custom HTML



	Just a man, looking at a script, asking it to ❤️ me.

		© SolarWinds Worldwide, LLC. All Rights Reserved.
		true
		true
		true
		true


		standard
		Just a man, looking at a script, asking it to ❤️ me.
		My HTML Special Report
		true


	Default Folder

	My HTML Special Report


		0

		web


		1800

	eec2b980-9caf-4f0d-9a01-5260eb59e06f





















							f0163394-a144-4876-9b79-8eec3314399d
							00000000-0000-0000-0000-000000000000
							Custom HTML
							5c638396-98d7-4a34-a879-72f003379cf4
							SolarWinds.Orion.Web.Reporting,WebResource
							ffffffff-ffff-ffff-ffff-ffffffffffff



							11d68f21-da47-4e8e-9f52-12fd1940542b
							00000000-0000-0000-0000-000000000000
							Custom HTML
							f6e03da6-58ef-4afd-8b30-59a333d8d9dd
							SolarWinds.Orion.Web.Reporting,WebResource
							ffffffff-ffff-ffff-ffff-ffffffffffff



					100

					e76f597d-3fd9-4567-a2ab-706a5dedc26f




			db2306de-49bc-4aea-80c1-7803e4a4914e

It's pretty ugly.  If I wanted to change out the value of one of the HTML body elements, then we'd need to:

• Extract the Definition XML and store in a variable
• Find the element to replace in that variable
• Update the element with my new HTML in that variable
• Use the UpdateReport verb with the content from the variable (I'm not sure if the Set-SwisObject function will work for this)

Is this possible? % it's possible.  Is it easy and prone to breakage?  Yes.  Will it be covered by SolarWinds support? Nope, it's a customization.  That's why we recommend doing this as an Application Component monitor and reporting from the results of that component monitor.

But because I like a challenge, I got this to work...

# Note: Update with your own information for the connection
$SwisConnection = Connect-Swis -Hostname 'solarwinds.domain.local' -Username 'MyUsername' -Password 'MyC0mp13xP@ssw0rd'
$Swql = @"
SELECT ReportID
     , Name
     , Description
     , LimitationCategory
     , Title
     , Category
     , Subtitle
     , Definition
     , Uri
FROM Orion.Report
WHERE Name = 'My HTML Special Report'

# Get the report that we want to edit into a variable - this will only work if a SINGLE report is returned
$ReportToEdit = Get-SwisData -SwisConnection $SwisConnection -Query $Swql

# Did we get back a report definition?  Cool.  Let's make the edits.
if ( $ReportToEdit ) {
    # Pull out the definition and put it into a XML object so we can move around using the navigation
    $ReportDefinition = [xml]( $ReportToEdit.Definition )

    # !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    # Note: This is grossly undersimplifying how traversing XML is done.
    # !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    # Let's see if the first element in ConfigurationData is of type "HTML"
    # Note: This may not be the ideal check for this, but it's simple and it works for my testing.
    if ( $ReportDefinition.Report.Configs.ConfigurationData[0].Settings.ContextValue[0].Name -eq "HTML" ) {
        # If it is, then update the value matching that name to whatever you want
        $ReportDefinition.Report.Configs.ConfigurationData[0].Settings.ContextValue[0].Value = "This is now a header" # <-- this is where you'd put whatever HTML you want
    }

    <#
    # Try to set the report definition with 'Set-SwisObject'
    Set-SwisObject -SwisConnection $SwisConnection -Uri $ReportToEdit.Uri -Properties @{ 'Definition' = $ReportDefinition.OuterXml }
    #!!! ERROR: Set-SwisObject: Property Definition mapped to a storage defined by query cannot be modified. !!!
    #>

    # We'll need to use the verb instead
    # Arguments:
    #   reportID,
    #   name,
    #   description,
    #   limitationCategory,
    #   category,
    #   title,
    #   subtitle,
    #   definition,
    #   IsFavorite,
    #   userName

    $Arguments = @(                                                  # Since we don't want to change most of the report, we just put the report information back.
        $ReportToEdit.ReportID,                                      # - Like here
        $ReportToEdit.Name,                                          # - and here
        $ReportToEdit.Description,                                   # - and here
        $ReportToEdit.LimitationCategory,                            # - still more
        $ReportToEdit.Category,                                      # - lather
        $ReportToEdit.Title,                                         # - rinse
        $ReportToEdit.Subtitle,                                      # - repeat
        $ReportDefinition.OuterXML,                                  # <-- this is updated definition XML
        '',                                                          # <-- send an empty string about the favorite
        $SwisConnection.ChannelFactory.Credentials.UserName.UserName # <-- we'll just pull the username from your SWIS Connection.  If you connect with Certificates, you'll need to provide a username here
    )
    # Update the report
    Invoke-SwisVerb -SwisConnection $SwisConnection -EntityName 'Orion.Report' -Verb 'UpdateReport' -Arguments $Arguments
    # if you get no errors, then it should have updated cleanly

    # This *may* unfavorite reports for user accounts.  My gut says that if it was already a Favorite it will not change that, but there is a chance.
}</pre>This is what it yields: