Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Orion database windows script monitor script body location

I have spent a bit of time perusing the Orion database trying to find where the component monitor (namely the windows script monitor) script body is stored. I see the apm_componentsetting table has a "key" column and a "value" column. Some of the "key" column values include "scriptbody" and I would assume that the "value" column contains the id for the scriptbody in some other table. Maybe I'm way off, so please feel free to redirect me. Any have any idea where the script body is stored?

Thanks

Find more posts tagged with

Accepted answers

martin.susil

Why do you need this?

The script body is saved in APM_ExternalSetting table, but please note, that you should not alter or update database manually as it could result in data consistency problems we don't support.

All comments

martin.susil

Why do you need this?

The script body is saved in APM_ExternalSetting table, but please note, that you should not alter or update database manually as it could result in data consistency problems we don't support.

nnielsen

I appreciate the response. The reason for looking into this is due to an error that is generated when attempting to edit a particular APM template. Once the template has been assigned to the required nodes (around 500 in total), it can no longer be edited because of this error. Unfortunately, this leaves no way to modify the template once assigned.

The work around has been to:

Copy the template
Delete the original template
Make needed changes to the copy
Assign the template to the nodes.

Obviously, this is unacceptable. Currently the system is running NPM v9.5.1 and APM v3.1. Both are due to be upgraded this week (not just because of this issue). Perhaps with some luck, this issue will be resolved with the upgrade.

martin.susil

The problem with editing applications, which are assigned to lot of nodes, is fixed in later APM version.

As workaround, you could edit the web.config file (c:\Inetpub\SolarWinds\Orion\APM\web.config) and increase the following value (if the maxRequestLength is not present in web.config file, you will need to add it):

<?xml version="1.0"?>
<configuration>
<system.web>
<httpRuntime maxRequestLength="10486" />
</system.web>
</configuration>