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

SAM Template Windows Script Monitor

Hi ,

We have a few SAM templates defined where we are running Windows Script Monitor. Can someone guide me to the DB table which I can query and find out the exact contents of the Windows Script Monitor?

Thanks,

Arnab

Find more posts tagged with

Accepted answers

All comments

KMSigma.SWI

Are you looking for the results or the definition of the Script Monitor? Because they are in two different places.

arnabmk

Hi,

I am looking for the actual script which we are running. Not the results.

Thanks

KMSigma.SWI

You can run this to get the scripts:

SELECT [Template].Name AS [Script Type]
,[Setting].[ComponentTemplateID]
,[Setting].[Key]
,[Setting].[Value]
,[Setting].[ValueType]
,[ScriptBody].Setting
FROM [APM_ComponentTemplateSetting] AS [Setting]
INNER JOIN [APM_ComponentTemplate] AS [Template]
ON [Setting].ComponentTemplateID = [Template].ID
INNER JOIN [APM_ExternalSetting] AS [ScriptBody]
ON [Setting].Value = [ScriptBody].ID
AND [Setting].ValueType = 4
WHERE [Setting].[Key] in ( 'ScriptArguments', 'ScriptBody', 'CommandLineToPass' )

And this to get the other values (parameters and such)

SELECT [Template].Name AS [Script Type]
,[Setting].[ComponentTemplateID]
,[Setting].[Key]
,[Setting].[Value]
,[Setting].[ValueType]
-- ,[ScriptBody].Setting
FROM [APM_ComponentTemplateSetting] AS [Setting]
INNER JOIN [APM_ComponentTemplate] AS [Template]
ON [Setting].ComponentTemplateID = [Template].ID
--INNER JOIN [APM_ExternalSetting] AS [ScriptBody]
-- ON [Setting].Value = [ScriptBody].ID
-- AND [Setting].ValueType = 4
WHERE [Setting].[Key] in ( 'ScriptArguments', 'ScriptBody', 'CommandLineToPass' )

There's probably a more elegant way to get this, but this is rough and tumble and should provide most of what you need.

frak

I think this answers what you need.

However, if you can find more from a different angle if you look at an additional audit table I made - to log script changes for security purposes. Trigger based.

If you need it but can't find it, just drop me a line.