The most recent content from our members.
I have the following query successfully working in a custom SWQL resource on a view: SELECT MultiValueMessages FROM Orion.APM.ComponentAlert WHERE ComponentID = '90224' The output is a string containing 4 custom message results fron a component monitor, and it looks like this: ITSecurityOnCall:user1@mail.org,…
I recently added a custom SWQL resource to our group page that other might find useful: SELECT EventTime, '' as Type, Message , Concat('/Orion/ImageHandler.ashx?Server=1&Image=%2FNetPerfMon%2Fimages%2FEvent-', EventType, '.gif') as [_IconFor_Type]FROM Orion.Eventsinner joinOrion.ContainerMemberSnapshots CMS on CMS.EntityID…
Hello Thwack Community, Looking to automate the creation of custom query / swql resources. Here is what I have from the Metadata.VerbArgument table in SWQL Studio filtering on the 'AddResourceToView' activity - **REQUIRED - Name: viewID = ViewID to add resource to - I’m good on this. **REQUIRED - Name: config = This is…
This is a super simple, single file, single line, edit. ESTIMATED TIME TO INSTALL/PERFORM MODIFICATION: <1 Minute DIFFICULTY LEVEL:1-Youngling * Youngling (Easiest/Most Basic; no coding experience required, no config wizard required, no system restart required, no system downtime.) * Padawan (Easy/Basic; no coding…
I think we can all agree that leveraging SWQL with the "Custom Query" NPM Resource has HUGE value - only it would be easier to automate and mass edit resources for views with an Import/Export option to .xml or other format. (Provided that the custom query would be shown somewhere within the file) Instead of having to edit…
Hi, When I run this query on SWQL, validated, however when I try to add this same swql query as a custom resource, it's showing an invalid query. I believe it may have to do with LEFT OUTER JOIN Orion.NodesCustomProperties AS cp ON AlertSup.id = cp.nodeid SELECT DISTINCT EntityUri, SuppressFrom, SuppressUntil,…
Trying to display data gathered from a custom script monitor within a custom query resource on our dashboard view - however I can't seem to get the query to actually display grouped data - instead I just end up with a list of data as if I didn't group anything in the first place. select n.Caption as Node, ac.Name,…
I'm probably missing something... WPM -> transaction alert trigger sends "email a web page" but doesn't seem to execute the custom SWQL... this is the email I get: this is the section I want (circled): This is the custom SWQL table on the web page for the trx that alerts: Here is the code for custom SWQL resource: SELECT…
I am attempting to build out custom "dashboards" for our SAM users who focus on certain applications or services to the org. For one particular service owner group, I have built out a Group folder using a dynamic query. When you click on the Group, you see the following (roughly, I apologize for my MsPaint skillz... took…
Can we use OID in SWQL query to poll data directly from Node. OR can we create undp resource than table, Table format is not proper.
It looks like you're new here. Sign in or register to get started.