Getting the max value of the day from the datapoint in table widget for capacity planning

Locked

Discussion interactions are currently paused.

Hi, I am trying the display max value of the day (last 24 hours) from the datapoints in a table widget in the dashboard, but its showing current datapoint value. Is there any method to achieve this? Like to understand any other widget display max value of the day in dashboard.

Jnana

Posted 6 years ago·Last reply 6 years ago

6 comments

Mike Moniz

·6 years ago

While not in a table but if it helps you can use the Gauge widget to show the current value and also show a Peak value for a particular period, including 24 hours.

https://www.logicmonitor.com/support/dashboards-and-widgets/widgets/which-widget-should-i-use/gauge-widget/#id:peak-time-range-selection

Cole McDonald

·6 years ago

So... I'm on windows, your response came in as I was getting all of that code in there :)/emoticons/smile@2x.png 2x" title=":)" width="20"> It'll be functionally similar for Linux. Not sure if it will work, but you may be able to install the Powershell core on your Linux collector to see if that will work there. (Free from Microsoft: https://docs.microsoft.com/en-us/powershell/scripting/install/installing-powershell-core-on-linux?view=powershell-6 )

(I don't know Groovy Script yet :)/emoticons/smile@2x.png 2x" title=":)" width="20"> )

Cole McDonald

·6 years ago


<span class="com">#!!! Requires Credential Manager 2.0 from the repository !!!#</span><span class="pln">

</span><span class="typ">Import</span><span class="pun">-</span><span class="typ">Module</span><span class="pln">     </span><span class="typ">CredentialManager</span><span class="pln">

function          </span><span class="typ">Send</span><span class="pun">-</span><span class="typ">Request</span><span class="pln">               </span><span class="pun">{</span><span class="pln">
    param </span><span class="pun">(</span><span class="pln">
        $cred</span><span class="pun">,</span><span class="pln">
        $accessid    </span><span class="pun">=</span><span class="pln"> $null</span><span class="pun">,</span><span class="pln">
        $accesskey   </span><span class="pun">=</span><span class="pln"> $null</span><span class="pun">,</span><span class="pln">
        $URL                </span><span class="pun">,</span><span class="pln">
        $data        </span><span class="pun">=</span><span class="pln"> $null</span><span class="pun">,</span><span class="pln">
        $version     </span><span class="pun">=</span><span class="pln"> </span><span class="str">'2'</span><span class="pln">  </span><span class="pun">,</span><span class="pln">
        $httpVerb    </span><span class="pun">=</span><span class="pln"> </span><span class="str">"GET"</span><span class="pln">
    </span><span class="pun">)</span><span class="pln">

    </span><span class="kwd">if</span><span class="pln"> </span><span class="pun">(</span><span class="pln"> $accessId </span><span class="pun">-</span><span class="pln">eq $null</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln">
        $accessId    </span><span class="pun">=</span><span class="pln"> $cred</span><span class="pun">.</span><span class="typ">UserName</span><span class="pln">
        $accessKey   </span><span class="pun">=</span><span class="pln"> $cred</span><span class="pun">.</span><span class="typ">GetNetworkCredential</span><span class="pun">().</span><span class="typ">Password</span><span class="pln">
    </span><span class="pun">}</span><span class="pln">

    </span><span class="pun"><#</span><span class="pln"> </span><span class="typ">Use</span><span class="pln"> TLS </span><span class="lit">1.2</span><span class="pln"> </span><span class="com">#></span><span class="pln">
    </span><span class="pun">[</span><span class="typ">Net</span><span class="pun">.</span><span class="typ">ServicePointManager</span><span class="pun">]::</span><span class="typ">SecurityProtocol</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="pun">[</span><span class="typ">Net</span><span class="pun">.</span><span class="typ">SecurityProtocolType</span><span class="pun">]::</span><span class="typ">Tls12</span><span class="pln">

    </span><span class="pun"><#</span><span class="pln"> </span><span class="typ">Get</span><span class="pln"> current time in milliseconds </span><span class="com">#></span><span class="pln">
    $epoch           </span><span class="pun">=</span><span class="pln"> </span><span class="pun">[</span><span class="typ">Math</span><span class="pun">]::</span><span class="typ">Round</span><span class="pun">(</span><span class="pln">
        </span><span class="pun">(</span><span class="pln"> </span><span class="typ">New</span><span class="pun">-</span><span class="typ">TimeSpan</span><span class="pln"> </span><span class="pun">`</span><span class="pln">
            </span><span class="pun">-</span><span class="pln">start </span><span class="pun">(</span><span class="typ">Get</span><span class="pun">-</span><span class="typ">Date</span><span class="pln"> </span><span class="pun">-</span><span class="typ">Date</span><span class="pln"> </span><span class="str">"1/1/1970"</span><span class="pun">)</span><span class="pln"> </span><span class="pun">`</span><span class="pln">
            </span><span class="pun">-</span><span class="pln">end </span><span class="pun">(</span><span class="typ">Get</span><span class="pun">-</span><span class="typ">Date</span><span class="pun">).</span><span class="typ">ToUniversalTime</span><span class="pun">()).</span><span class="typ">TotalMilliseconds</span><span class="pln">
        </span><span class="pun">)</span><span class="pln">

    </span><span class="pun"><#</span><span class="pln"> </span><span class="typ">Concatenate</span><span class="pln"> </span><span class="typ">Request</span><span class="pln"> </span><span class="typ">Details</span><span class="pln"> </span><span class="com">#></span><span class="pln">
    $requestVars     </span><span class="pun">=</span><span class="pln"> $httpVerb </span><span class="pun">+</span><span class="pln"> $epoch </span><span class="pun">+</span><span class="pln"> $data </span><span class="pun">+</span><span class="pln"> $resourcePath

    </span><span class="pun"><#</span><span class="pln"> </span><span class="typ">Construct</span><span class="pln"> </span><span class="typ">Signature</span><span class="pln"> </span><span class="com">#></span><span class="pln">
    $hmac            </span><span class="pun">=</span><span class="pln"> </span><span class="typ">New</span><span class="pun">-</span><span class="typ">Object</span><span class="pln"> </span><span class="typ">System</span><span class="pun">.</span><span class="typ">Security</span><span class="pun">.</span><span class="typ">Cryptography</span><span class="pun">.</span><span class="pln">HMACSHA256
    $hmac</span><span class="pun">.</span><span class="typ">Key</span><span class="pln">        </span><span class="pun">=</span><span class="pln"> </span><span class="pun">[</span><span class="typ">Text</span><span class="pun">.</span><span class="typ">Encoding</span><span class="pun">]::</span><span class="pln">UTF8</span><span class="pun">.</span><span class="typ">GetBytes</span><span class="pun">(</span><span class="pln"> $accessKey </span><span class="pun">)</span><span class="pln">
    $signatureBytes  </span><span class="pun">=</span><span class="pln"> $hmac</span><span class="pun">.</span><span class="typ">ComputeHash</span><span class="pun">(</span><span class="pln"> </span><span class="pun">[</span><span class="typ">Text</span><span class="pun">.</span><span class="typ">Encoding</span><span class="pun">]::</span><span class="pln">UTF8</span><span class="pun">.</span><span class="typ">GetBytes</span><span class="pun">(</span><span class="pln"> $requestVars </span><span class="pun">)</span><span class="pln"> </span><span class="pun">)</span><span class="pln">
    $signatureHex    </span><span class="pun">=</span><span class="pln"> </span><span class="pun">[</span><span class="typ">System</span><span class="pun">.</span><span class="typ">BitConverter</span><span class="pun">]::</span><span class="typ">ToString</span><span class="pun">(</span><span class="pln"> $signatureBytes </span><span class="pun">)</span><span class="pln"> </span><span class="pun">-</span><span class="pln">replace </span><span class="str">'-'</span><span class="pln">
    $signature       </span><span class="pun">=</span><span class="pln"> </span><span class="pun">[</span><span class="typ">System</span><span class="pun">.</span><span class="typ">Convert</span><span class="pun">]::</span><span class="typ">ToBase64String</span><span class="pun">(</span><span class="pln"> </span><span class="pun">[</span><span class="typ">System</span><span class="pun">.</span><span class="typ">Text</span><span class="pun">.</span><span class="typ">Encoding</span><span class="pun">]::</span><span class="pln">UTF8</span><span class="pun">.</span><span class="typ">GetBytes</span><span class="pun">(</span><span class="pln"> $signatureHex</span><span class="pun">.</span><span class="typ">ToLower</span><span class="pun">()</span><span class="pln"> </span><span class="pun">)</span><span class="pln"> </span><span class="pun">)</span><span class="pln">

    </span><span class="pun"><#</span><span class="pln"> </span><span class="typ">Construct</span><span class="pln"> </span><span class="typ">Headers</span><span class="pln"> </span><span class="com">#></span><span class="pln">
    $auth            </span><span class="pun">=</span><span class="pln"> </span><span class="str">'LMv1 '</span><span class="pln"> </span><span class="pun">+</span><span class="pln"> $accessId </span><span class="pun">+</span><span class="pln"> </span><span class="str">':'</span><span class="pln"> </span><span class="pun">+</span><span class="pln"> $signature </span><span class="pun">+</span><span class="pln"> </span><span class="str">':'</span><span class="pln"> </span><span class="pun">+</span><span class="pln"> $epoch
    $headers         </span><span class="pun">=</span><span class="pln"> </span><span class="typ">New</span><span class="pun">-</span><span class="typ">Object</span><span class="pln"> </span><span class="str">"System.Collections.Generic.Dictionary[[String],[String]]"</span><span class="pln">
    $headers</span><span class="pun">.</span><span class="typ">Add</span><span class="pun">(</span><span class="pln">      </span><span class="str">"Authorization"</span><span class="pun">,</span><span class="pln"> $auth              </span><span class="pun">)</span><span class="pln">
    $headers</span><span class="pun">.</span><span class="typ">Add</span><span class="pun">(</span><span class="pln">      </span><span class="str">"Content-Type"</span><span class="pln"> </span><span class="pun">,</span><span class="pln"> </span><span class="str">'application/json'</span><span class="pln"> </span><span class="pun">)</span><span class="pln">

    </span><span class="com"># uses version 2 of the API</span><span class="pln">
    $headers</span><span class="pun">.</span><span class="typ">Add</span><span class="pun">(</span><span class="pln">      </span><span class="str">"X-version"</span><span class="pln">    </span><span class="pun">,</span><span class="pln"> $version           </span><span class="pun">)</span><span class="pln">

    </span><span class="pun"><#</span><span class="pln"> </span><span class="typ">Make</span><span class="pln"> </span><span class="typ">Request</span><span class="pln"> </span><span class="com">#></span><span class="pln">
    $response        </span><span class="pun">=</span><span class="pln"> </span><span class="typ">Invoke</span><span class="pun">-</span><span class="typ">RestMethod</span><span class="pln"> </span><span class="pun">`</span><span class="pln">
        </span><span class="pun">-</span><span class="typ">Uri</span><span class="pln">           $URL      </span><span class="pun">`</span><span class="pln">
        </span><span class="pun">-</span><span class="typ">Method</span><span class="pln">        $httpVerb </span><span class="pun">`</span><span class="pln">
        </span><span class="pun">-</span><span class="typ">Body</span><span class="pln">          $data     </span><span class="pun">`</span><span class="pln">
        </span><span class="pun">-</span><span class="typ">Header</span><span class="pln">        $headers

    $result          </span><span class="pun">=</span><span class="pln"> $response

    </span><span class="typ">Return</span><span class="pln"> $result
</span><span class="pun">}</span><span class="pln">
function          </span><span class="typ">Get</span><span class="pun">-</span><span class="typ">LMRestAPIObjectListing</span><span class="pln"> </span><span class="pun">{</span><span class="pln">
    param </span><span class="pun">(</span><span class="pln">
        $URLBase          </span><span class="pun">,</span><span class="pln">
        $resourcePathRoot </span><span class="pun">,</span><span class="pln"> </span><span class="com"># "/device/devices"</span><span class="pln">
        $size </span><span class="pun">=</span><span class="pln"> </span><span class="lit">1000</span><span class="pln">      </span><span class="pun">,</span><span class="pln">
        $accessKey        </span><span class="pun">,</span><span class="pln">
        $accessId
    </span><span class="pun">)</span><span class="pln">

    $output  </span><span class="pun">=</span><span class="pln"> </span><span class="pun">@()</span><span class="pln">
    $looping </span><span class="pun">=</span><span class="pln"> $true
    $counter </span><span class="pun">=</span><span class="pln"> </span><span class="lit">0</span><span class="pln">

    </span><span class="kwd">while</span><span class="pln"> </span><span class="pun">(</span><span class="pln">$looping</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln">
        </span><span class="com">#re-calc offset based on iteration</span><span class="pln">
        $offset </span><span class="pun">=</span><span class="pln"> </span><span class="pun">(</span><span class="pln">$counter </span><span class="pun">*</span><span class="pln"> $size</span><span class="pun">)</span><span class="pln"> </span><span class="pun">+</span><span class="pln"> </span><span class="lit">1</span><span class="pln">

        $resourcePath    </span><span class="pun">=</span><span class="pln"> $resourcePathRoot
        $queryParam      </span><span class="pun">=</span><span class="pln"> </span><span class="str">"?size=$size&offset=$offset"</span><span class="pln">
        $url             </span><span class="pun">=</span><span class="pln"> $URLBase </span><span class="pun">+</span><span class="pln"> $resourcePath </span><span class="pun">+</span><span class="pln"> $queryParam

        </span><span class="com"># Make Request</span><span class="pln">
        $response        </span><span class="pun">=</span><span class="pln"> </span><span class="typ">Send</span><span class="pun">-</span><span class="typ">Request</span><span class="pln"> </span><span class="pun">`</span><span class="pln">
            </span><span class="pun">-</span><span class="pln">accesskey    $accessKey    </span><span class="pun">`</span><span class="pln">
            </span><span class="pun">-</span><span class="pln">accessid     $accessId     </span><span class="pun">`</span><span class="pln">
            </span><span class="pun">-</span><span class="pln">URL          $url

        </span><span class="kwd">if</span><span class="pln"> </span><span class="pun">(</span><span class="pln"> $response</span><span class="pun">.</span><span class="pln">items</span><span class="pun">.</span><span class="pln">count </span><span class="pun">-</span><span class="pln">eq $size </span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln">
            </span><span class="com"># Return set is full, more items to retrieve</span><span class="pln">
            $output     </span><span class="pun">+=</span><span class="pln"> $response</span><span class="pun">.</span><span class="pln">items
            $counter</span><span class="pun">++</span><span class="pln">

        </span><span class="pun">}</span><span class="pln"> elseif </span><span class="pun">(</span><span class="pln"> $response</span><span class="pun">.</span><span class="pln">items</span><span class="pun">.</span><span class="pln">count </span><span class="pun">-</span><span class="pln">gt </span><span class="lit">0</span><span class="pln"> </span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln">
            </span><span class="com"># Return set is not full, store date, end loop</span><span class="pln">
            $output     </span><span class="pun">+=</span><span class="pln"> $response</span><span class="pun">.</span><span class="pln">items
            $looping     </span><span class="pun">=</span><span class="pln"> $false

        </span><span class="pun">}</span><span class="pln"> </span><span class="kwd">else</span><span class="pln"> </span><span class="pun">{</span><span class="pln">
            </span><span class="com"># Return set is empty, no data to store, end loop</span><span class="pln">
            $looping     </span><span class="pun">=</span><span class="pln"> $false

        </span><span class="pun">}</span><span class="pln">
    </span><span class="pun">}</span><span class="pln">

    write</span><span class="pun">-</span><span class="pln">output $output
</span><span class="pun">}</span><span class="pln">

</span><span class="com">#!!! Change to your company name !!!#</span><span class="pln">
$company        </span><span class="pun">=</span><span class="pln"> </span><span class="str">"yourCompanyHere"</span><span class="pln">
$URLBase        </span><span class="pun">=</span><span class="pln"> </span><span class="str">"https://$company.logicmonitor.com/santaba/rest"</span><span class="pln">

</span><span class="com"># This will resolve to proper values if it's being run from inside LM</span><span class="pln">
$accessID       </span><span class="pun">=</span><span class="pln"> </span><span class="str">"##Logicmonitor.AccessID.key##"</span><span class="pln">
$accessKey      </span><span class="pun">=</span><span class="pln"> </span><span class="str">"##Logicmonitor.AccessKey.key##"</span><span class="pln">

</span><span class="kwd">if</span><span class="pln"> </span><span class="pun">(</span><span class="pln"> $accessID </span><span class="pun">-</span><span class="pln">like </span><span class="str">"##*"</span><span class="pln"> </span><span class="pun">)</span><span class="pln">       </span><span class="pun">{</span><span class="pln">
    </span><span class="com"># Not being run from inside LM - populate manually for testing</span><span class="pln">
    </span><span class="typ">Import</span><span class="pun">-</span><span class="typ">Module</span><span class="pln">     </span><span class="typ">CredentialManager</span><span class="pln">

    $Cred       </span><span class="pun">=</span><span class="pln"> </span><span class="typ">Get</span><span class="pun">-</span><span class="typ">StoredCredential</span><span class="pln"> </span><span class="pun">-</span><span class="typ">Target</span><span class="pln"> </span><span class="typ">LogicMonitor</span><span class="pln">
    $accessID   </span><span class="pun">=</span><span class="pln"> $cred</span><span class="pun">.</span><span class="typ">UserName</span><span class="pln">
    $accessKey  </span><span class="pun">=</span><span class="pln"> $Cred</span><span class="pun">.</span><span class="typ">GetNetworkCredential</span><span class="pun">().</span><span class="typ">Password</span><span class="pln">
</span><span class="pun">}</span><span class="pln">

</span><span class="com">#!!! Populate the pertinent ID numbers from the "Info" section of the LM objects</span><span class="pln">
$deviceNumber     </span><span class="pun">=</span><span class="pln"> </span><span class="lit">123</span><span class="pln">
$dataSourceNumber </span><span class="pun">=</span><span class="pln"> </span><span class="lit">456</span><span class="pln">
$instanceNumber   </span><span class="pun">=</span><span class="pln"> </span><span class="lit">789</span><span class="pln">

</span><span class="com">#region Get collectors</span><span class="pln">
$resourcePath   </span><span class="pun">=</span><span class="pln"> </span><span class="str">"/device/devices/$deviceNumber/devicedatasources/$datasourceNumber/instances/$instanceNumber/data"</span><span class="pln">

$response       </span><span class="pun">=</span><span class="pln"> </span><span class="typ">Get</span><span class="pun">-</span><span class="typ">LMRestAPIObjectListing</span><span class="pln"> </span><span class="pun">`</span><span class="pln">
    </span><span class="pun">-</span><span class="pln">resourcePathRoot $resourcePath          </span><span class="pun">`</span><span class="pln">
    </span><span class="pun">-</span><span class="pln">accessKey        $accessKey             </span><span class="pun">`</span><span class="pln">
    </span><span class="pun">-</span><span class="pln">accessId         $accessID              </span><span class="pun">`</span><span class="pln">
    </span><span class="pun">-</span><span class="typ">URLBase</span><span class="pln">          $URLBase</span>

To find the ID Numbers, you can build out the $resourcePath for the last few bits until you come across the pieces you need. I develop in PowerShell ISE to allow me to explore the date more easily once I've populated it.

Jnana

OP6 years ago

Thanks Cole, I am trying to collect these max values of datapoints from linux host, could you please share groovy script or any alternative method if you have any to achieve this.

Cole McDonald

·6 years ago

You can grab historical data for an dataSource instance using the REST API. Once you've got the time range you want to evaluate, finding the Max should be relatively simple. Let me fish up a thread with how to grab those counters for you...

I found my thread for tokenizing the return using powershell, but apparently, didn't include the data grab portion of the code in the thread

/topic/2281-rest-api-raw-data-processing-using-powershell/