Creating a propertySource to populate a NOC widget in a dashboard... need ## in a string.

The NOC widget items have a field that requires me to have the string "##RESOURCEGROUP##" pushed through the JSON into the NOC Item… since I’m using a propertySource to run the script on a schedule (I have a larger VM with a collector with a longer script timeout just for doing deeper scripted work through the API or Full Domain sweep types of things that will take more time), The LM System is going to try to replace that at run time rather than returning the explicit string.

Who knows the correct escape sequence for turning that into a string literal on its way into the RestApi Patch?

Scripting questions through support is best effort, and I don’t usually come with easy questions.

Cole McDonald

Posted 2 years ago·Last reply 2 years ago

5 comments

Cole McDonald

OP2 years ago

… and warning! I use backticks as line continuations frequently to allow for a single “thing” per line in my scripts. I dev in Powershell ISE, so it’ll look best there with everything all lined up pretty. Style and spacing is closer to python than .net / C#

Cole McDonald

OP2 years ago

<#<br/>------------------------------<br/>LogicMonitor Subgroup NOC Item population<br/>for NOC Widget Dashboards<br/>------------------------------<br/>Created by Cole McDonald (Netgain Technologies, LLC)<br/>17 October 2023<br/>------------------------------<br/>Netgain and the Author are not responsible for any issues this may occur in your environment due<br/>to the use of this script in whole or part.  Please retain this comment block in your deployment.<br/>------------------------------<br/>This DS should have an appliesTo() that targets a single collector<br/>The collector should have its script timeouts increased to account for<br/>longer run times reaching out through the web to the API.<br/><br/>You can have this update multiple dashboards as it's grabbing all of the API data necessary,<br/>minimizing the # of times you have to grab that data will reduce resource consumption on the collector.<br/>------------------------------<br/>#><br/><br/># Add your logicmonitor portal company name for the URL<br/>$company   = ""<br/><br/>$URLBase   = "https://$company.logicmonitor.com/santaba/rest"<br/><br/># These properties are defined somewhere that can be picked up by the device targeted by the appliesTo()<br/>$accessID  = "##ApiAccessID.key##"<br/>$accessKey = "##ApiAccessKey.key##"<br/><br/># This is the ID (integer) of the group containing the subgroups you want displayed.<br/># This needs to be changed to target based on name/path<br/>$parentGroupID = 0<br/><br/># The "name" property is the name of the Dashboard being targeted.<br/>#!!! If you have more than one dashboard to update, duplicate this and<br/>#!!! change the $masterdash and name.  If you have questions on this,<br/>#!!! reach out on the LM Community and I can show you what I've done.<br/>$masterDash    = @{ id=0; widgetid=0; name="NOC - Master"   }<br/><br/>#region Initialization and Functions<br/>#-------- The Functions ----------<br/>function generateJSON {<br/>    param(<br/>        $dashInfo,<br/>        $clientnames,<br/>        $deviceDisplayName = "*",<br/>        $DSDisplayName     = "*"<br/>    )<br/><br/>    $itemArray          = @()<br/><br/>    foreach ($name in $clientnames) {<br/>        $itemArray += @{<br/>            "type"                  = "device"<br/>            "deviceGroupFullPath"   = "Clients/$name"<br/>            "deviceDisplayName"     = $deviceDisplayName<br/>            "dataSourceDisplayName" = $DSDisplayName<br/>            "instanceName"          = "*"<br/>            "dataPointName"         = "*"<br/>            "groupBy"               = "deviceGroup"<br/>            "name"                  = "`#`#RESOURCEGROUP`#`#"<br/>        }<br/>    }<br/><br/>    # Write JSON back to the API for that widget<br/>    $outputJSON = "`n`t{`n`t`t`"items`" : [`n"<br/><br/>    foreach ($item in $itemArray) {<br/>        $elementJSON = @"<br/>        {<br/>            `"type`"                  : `"$($item.type)`",<br/>            `"dataPointName`"         : `"$($item.dataPointName)`",<br/>            `"instanceName`"          : `"$($item.instanceName)`",<br/>            `"name`"                  : `"$($item.name)`",<br/>            `"dataSourceDisplayName`" : `"$($item.dataSourceDisplayName)`",<br/>            `"groupBy`"               : `"$($item.groupBy)`",<br/>            `"deviceGroupFullPath`"   : `"$($item.deviceGroupFullPath)`",<br/>            `"deviceDisplayName`"     : `"$($item.deviceDisplayName)`"<br/>        }<br/>"@<br/>        if ($item -ne $itemArray[-1]) {<br/>            $outputJSON += "$elementJSON,`n"<br/>        } else {<br/>            # Last Item<br/>            $outputJSON += "$elementJSON`n`t`t]`n`t}"<br/>        }<br/>    }<br/><br/>    write-output $outputJSON<br/>}<br/><br/>function Send-Request {<br/>    param (<br/>        $cred               ,<br/>        $URL                ,<br/>        $accessid    = $null,<br/>        $accesskey   = $null,<br/>        $data        = $null,<br/>        $version     = '3'  ,<br/>        $httpVerb    = "GET"<br/>    )<br/>    if ( $accessId -eq $null) { exit 1 }<br/><br/>    <# Use TLS 1.2 #><br/>    [Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12<br/>    <# Get current time in milliseconds #><br/>    $epoch           = [Math]::Round(<br/>        ( New-TimeSpan `<br/>            -start (Get-Date -Date "1/1/1970") `<br/>            -end (Get-Date).ToUniversalTime()).TotalMilliseconds<br/>        )<br/>    <# Concatenate Request Details #><br/>    $requestVars     = $httpVerb + $epoch + $data + $resourcePath<br/><br/>    <# Construct Signature #><br/>    $hmac            = New-Object System.Security.Cryptography.HMACSHA256<br/>    $hmac.Key        = [Text.Encoding]::UTF8.GetBytes( $accessKey )<br/>    $signatureBytes  = $hmac.ComputeHash( [Text.Encoding]::UTF8.GetBytes( $requestVars ) )<br/>    $signatureHex    = [System.BitConverter]::ToString( $signatureBytes ) -replace '-'<br/>    $signature       = [System.Convert]::ToBase64String( [System.Text.Encoding]::UTF8.GetBytes( $signatureHex.ToLower() ) )<br/>    <# Construct Headers #><br/>    $auth            = 'LMv1 ' + $accessId + ':' + $signature + ':' + $epoch<br/>    $headers         = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"<br/>    $headers.Add(      "Authorization", $auth              )<br/>    $headers.Add(      "Content-Type" , 'application/json' )<br/>    # uses version 2 of the API<br/>    $headers.Add(      "X-version"    , $version           )<br/><br/>    <# Make Request #><br/>    $response        = Invoke-RestMethod  `<br/>        -Uri             $URL             `<br/>        -Method          $httpVerb        `<br/>        -Body            $data            `<br/>        -Header          $headers         `<br/>        -erroraction     SilentlyContinue `<br/>        -warningaction   SilentlyContinue<br/><br/>    Return $response<br/>}<br/>function Get-LMRestAPIObjectListing {<br/>    param (<br/>        $URLBase          ,<br/>        $resourcePathRoot , # "/device/devices"<br/>        $size = 1000      ,<br/>        $accessKey        ,<br/>        $accessId         ,<br/>        $version = '2'<br/>    )<br/><br/>    $output  = @()<br/>    $looping = $true<br/>    $counter = 0<br/><br/>    while ($looping) {<br/>        #re-calc offset based on iteration<br/>        $offset = $counter * $size<br/>        $resourcePath    = $resourcePathRoot<br/>        $queryParam      = "?size=$size&offset=$offset"<br/>        $url             = $URLBase + $resourcePath + $queryParam<br/>        # Make Request<br/>        $response        = Send-Request `<br/>            -accesskey    $accessKey    `<br/>            -accessid     $accessId     `<br/>            -URL          $url          `<br/>            -version      $version<br/>        if ( $response.items.count -eq $size ) {<br/>            # Return set is full, more items to retrieve<br/>            $output     += $response.items<br/>            $counter++<br/>        } elseif ( $response.items.count -gt 0 ) {<br/>            # Return set is not full, store date, end loop<br/>            $output     += $response.items<br/>            $looping     = $false<br/>        } else {<br/>            # Return set is empty, no data to store, end loop<br/>            $looping     = $false<br/>        }<br/>    }<br/><br/>    write-output $output<br/>}<br/>#endregion<br/><br/># This could be more concise a grab with stronger filters,<br/># that's a future problem, this works and isn't terribly slow<br/><br/>#region Get Dashboards<br/>$resourcePath         = "/dashboard/dashboards"<br/>$dashboards           = Get-LMRestAPIObjectListing `<br/>    -resourcePathRoot $resourcePath                `<br/>    -accessKey        $accessKey                   `<br/>    -accessId         $accessID                    `<br/>    -URLBase          $URLBase<br/>#endregion<br/>#region Get Widgets<br/>$resourcePath         = "/dashboard/widgets"<br/>$widgets              = Get-LMRestAPIObjectListing `<br/>    -resourcePathRoot $resourcePath                `<br/>    -accessKey        $accessKey                   `<br/>    -accessId         $accessID                    `<br/>    -URLBase          $URLBase<br/>#endregion<br/>#region Get Groups<br/>$resourcePath         = "/device/groups"<br/>$Groups               = Get-LMRestAPIObjectListing `<br/>    -resourcePathRoot $resourcePath                `<br/>    -accessKey        $accessKey                   `<br/>    -accessId         $accessID                    `<br/>    -URLBase          $URLBase<br/>#endregion<br/><br/># Get Client Names from groups<br/>$clientnames = (<br/>    $groups                                        `<br/>    | where parentid -eq       $parentGroupID      `<br/>    | where name     -notmatch "^\."<br/>).name | sort<br/><br/>#!!! If you have more than one dashboard, duplicate this and change the $masterdash<br/>#!!! to other variables defined at the start of the script.<br/><br/># ID Master Dashboard<br/>$master = $dashboards   | ? name -eq $masterDash.name<br/>if (($master.name).count   -eq 1) {<br/><br/>    $masterDash.id        = $master.id<br/>    $masterDash.widgetid  = $master.widgetsConfig[0].psobject.Properties.name<br/><br/>    $outputJSON = generateJSON   `<br/>        -dashInfo    $masterDash `<br/>        -clientnames $clientnames<br/><br/>    $resourcePath = "/dashboard/widgets/$($masterDash.widgetid)"<br/>    $url          = $URLBase + $resourcePath<br/><br/>    $widget       = Send-Request      `<br/>        -accessKey        $accessKey  `<br/>        -accessId         $accessID   `<br/>        -data             $outputJSON `<br/>        -URL              $URL        `<br/>        -httpVerb         "PATCH"<br/>}

Here’s the code I’m using to populate these Dashboards. The new UI (v4) displays this better if you expand/maximize the widget to fill the page (although filtering out SDT’d alerts doesn’t work currently). Dashboard is just a single widget dashboard with a NOC widget that fills the page. The only two non-dynamic parts are the name of the dashboard, which goes in $masterDash.name and the ID of the group you want as your source for the subgroups… in our case it’s the “/Clients” group… so the ID number from that goes in $parentGroupID

This is built off of my old API exploration / report generation powershell functions, which is, in turn, built from the API + Powershell documentation from LM. This doesn't require any external modules to be added to use the API, so can be deployed against a collector with no prior software installs needed beyond what you’ll already have done.

I recommend targeting your dataSource to a single collector, then increasing the timeout for the scripts. At some point, I’m going to add pre-filtering to the initial API requests for groups and dashboards to speed those parts a little bit, but it’s not too bad currently while grabbing everything.

DS runs 1/day to populate the widget, feel free to have it hit more frequently if needed. Only two datapoints currently, exitCode and executionTime. I’m probably going to add groupCount at some point.

Enjoy.

Cole McDonald

OP2 years ago

Changed it to a dataSource with datapoints of execution time and exitCode… I may add a count of the client folders added.

LM User

·2 years ago

Yeah, PS escape character is backtick.

Cole McDonald

OP2 years ago

Some testing shows that backticks are the winners:

“testoutput=`#`#RESOURCEGROUP`#`#”

shows ##RESOURCEGROUP## in the output window.

1	SUYASH GAIKWAD
2	FF Fujitsu Fazeer
3	EN Ernest Nganza
4	AM Abhishek M
5	NA Nazmeen Ali
6	DK Deepak Kumar