Updating Net Service Name with PowerShell

Good Afternoon All,

I am trying to use a PowerShell script to update component monitor values within a template but am having a hard time finding certain fields in the OrionSDK Schema.(https://solarwinds.github.io/OrionSDK/)

I have already figured out how to rename templates with PowerShell but am having a hard time configuring them, for example I am trying to set the highlighted value in the image below but am unable to find which table it is located in. Can all values within a component monitor be edited via scripting?

Any help is much appreciated,

thanks!

Find more posts tagged with

templates

components

PowerShell

Accepted answers

mesverrum

Not all of the values are listed as being fully crud enabled directly with SWQL, but there is a trick where you can leverage SWQL to make edits to the DB directly if you are feeling brave.

The verb is under orion.reporting, you have to be an admin to use it, executeSQL.

Keep in mind that the table structure of SWQL is not really a mirror of the underlying SQL, depending on how exactly you are editing things I think what you are looking for is the name column under apm_componenttemplate

All comments

mesverrum

Not all of the values are listed as being fully crud enabled directly with SWQL, but there is a trick where you can leverage SWQL to make edits to the DB directly if you are feeling brave.

The verb is under orion.reporting, you have to be an admin to use it, executeSQL.

StavvyB

Thank you for taking the time to answer my question! Very helpful