Solarwinds query custom properties. Edit a custom property definition.

• Solarwinds query custom properties Nodes WHERE Nodes. Once you have assigned these values, they can be displayed on the map and in reports. . query ('SELECT NodeID, Caption FROM Orion. Prosperon - UK SolarWinds Partners. CustomProperties. Edit a custom property definition. custom properties in your SELECT field but missed it your WHERE command. Rob Kavanagh. See below for both options. I am not familiar with SolarWinds REST api, and I have never used it. [custom property name] to use the property in your query. DeviceType=@DeviceType', DeviceType=deviceType)['results'] SolarWinds SDK Adding Custom Properties to a SWQL query. To return to the Custom properties page, click Back . See this video: A Step-by-Step Guide to Building Modern Dashboards on the Orion Platform ‚ SolarWinds Lab #93. Provide an appropriate SQL query in the Filter Nodes (SQL) field, and click Submit. 2) I am searching a query to find out which custom property is being used. NPM. these are Group properties, different than Node ones. Click Save to save your updates. I would like to retrieve this via SWQL API, but the following query does not work: SELECT Serial_Number From Orion. Feb 5, 2024 · When you put the SWQL into the table and click on Show Records is it showing all of the columns that you expect to see? Have you puit the code in to a Classic Dashboard on a Custom Query to see if it works on there? I guess the final thing to check is what version of SolarWinds are you running? I am running 2023. 1 here. 4. The documentation isn't really helping clear it up. Also you can go with the <> ' ' option or you can go with IS NOT NULL option. In the modern Manage custom properties view, you can go directly to the Manage account limitations view to create account limitations based on custom properties. Custom properties must use the Latin1 character set. Simply type [alias]. Custom Properties can be set up for any of these different entities. Things to consider before the import. CustomProperty WHERE TargetEntity IN ('Orion. CustomProperties" and all will be right with this query. I'd like to set it per Node instead. Please note this query does not directly identify the Custom Property Type, Name, or Value. (You do not need to know where the information is I have created a Custom Property "Serial_Number" for Nodes in NCM 7. Feb 4, 2020 · I need a query on custom properties based on the following: 1) Need a query for custom property to find out which is not being used or assigned on any node / Groups / Alerts / Views etc. NPM Note that the time_from and time_to properties are custom properties that you created using the Orion Web Console in the previous KB article. So using your example that line for you, would be something like: Sep 24, 2020 · I can use a swis. On the Custom properties page, select a custom property and click Edit custom property. This custom query widget detects any Dynamic Queries for each group that rely upon Custom Properties. So the way I've set this up, you can search the name of the the node, the name of the volume, or a defined custom property. Nov 1, 2024 · You fixed the node. It also appeared to matter the specific nature in which the SWQL query was created. Filters are optional SQL queries that are used to limit node list displays for easier navigation in widgets. You'll have to investigate the details yourself. The one I listed above is for the Nodes entity. Click Edit in any node list widget. I cannot seem to be able to add both a node and an application query to the same group query. VolumesCustomProperties' THEN 'Volume' END AS [Custom Property Type] FROM Orion. You can click the Show Records or Validate Query button to validate the data returned. If you have a spreadsheet listing custom property values, such as asset tags of all your network nodes, you can make this information available for reporting and publication in the SolarWinds Platform Web Console. Feb 6, 2025 · I am looking for how to call the SW API to pull nodes of a specific custom property. For example, you may want to indicate if nodes are leased or owned. Node. Use custom properties. Take the SWQL I have provided, modified with your custom property requirements of course, and paste into the SWQL Query field. Just middle-click on each of the below links to open them in a new tab and vote them up. Or, in the Details pane for that property, click Commands > Edit custom You can add Description to get the custom property description. Similar to SQL, you can use SWQL to query your SolarWinds database for specific network information. Your data must be formatted as a table. | Read the THWACK Post Starting with Orion Platform 2020. " operator to specify custom properties. I would assume that the syntax you provided is for one node only with a known NodeID. SQL queries can be made on any predefined or custom properties. This topic introduces custom properties Jan 25, 2024 · It can't leverage custom properties with underscores in them due to the underscore being used as a special character in the syntax. Use the ". 1. SolarWinds does listen to Feature Requests. node. I had to use the following query to successfully find all of the alerts using a custom property: SELECT * FROM [AlertConfigurations] WHERE [Trigger] LIKE '%custom property%' will then search the results of the above query and filter accordingly. Dynamic Custom Properties; Additional Dynamic Query functionality; NPM - Custom Properties - Dynamic (calculated) value; Dynamic Group Creation based on rules; Custom Property Automated Rules Feb 6, 2020 · Inspired by a comment thread from Unmanaged Muted - Report Lab - The Orion Platform - THWACK (solarwinds. Nodes Mar 23, 2021 · I've been evaluating the possibility to get de metadata of custom properties and getting that way all the names of the properties and creating a query from that list of names and then generating that query, seems pretty awful, does anyone have a better idea about how to implement this? Thanks in advance! Fran. May 19, 2016 · Actually, I need to query all the nodes from SolarWinds including built-in and custom properties. query to find nodes who have a custom property equal to a given value with something like this: nodes = swis. The problem is, the URI & other properties are not set when I query "uri/custom" >>> swis. Which ends up being this variable for Oct 6, 2021 · So, for our setup, we have a custom property called 'ClientPrefix' and in the "Insert_Text_Here" but I have just put in the appropriate prefix we need. Custom properties help you add custom labels to monitored objects, group objects based on the property or alert on objects with a certain value for the property. One of the UnDP's is collated to a custom property that is attached on a Node. Raw Results: As rendered on a Summary Page: Custom Properties Required: It would be good to be able to populate based on the assigned node's custom properties, rather than using other methods (manually changing the dynamic query clause in the database, or duplicating node custom properties on the application). Now if you already are exporting the data into CSV / Excel and making updates there you could just re-import within the GUI too if it's a one-off. Custom properties allow you to assign custom values to nodes. Simply fix the WHERE command to "o. I want to state again the node has the custom property but one of the UnDP's has the same value as the custom property. For example if you use this SWQL query -- per the documentation this is exactly what the web UI is doing when attempting this. read(uri) This topic introduces custom properties, what you can use them for and what are the most frequently used custom properties. So if node "XYZ" is in Group "ABC" then a Node Custom Property "123" should be set automatically. Each node in our environment includes a custom property: SolarWinds solutions are rooted in our Hey guys, I'm not able to update custom properties on IP. Custom properties are user-defined fields, such as country, building, asset tag, or serial number, that you can associate with monitored network objects. An Application based alert may need to use an Application based custom property, just my guess. SELECT Field AS [Custom Property Name], CASE WHEN TargetEntity = 'Orion. InterfacesCustomProperties' THEN 'Interface' WHEN TargetEntity = 'Orion. Sep 20, 2017 · Thanks for the response. The following guide provides examples of SWQL syntax and valid SWQL queries. Installation | Consultancy | Training | Licenses I can add two querys but that just seems to AND the results. Mar 8, 2022 · Here's a basic example of how to modify custom properties of nodes already in SolarWinds from within PowerShell. Node using SWIS API. I need this information to true up the SolarWinds inventory for my company. Jul 21, 2021 · For Data and Calculations select Hand-edit a SWQL Query and click the Edit button. com) This is a custom query that can be put on a global summary page to show all devices which have been unmanaged or muted based AND match a specific filter. The import will overwrite existing custom properties. In our case, in the AlertDefinitionsView table the "TriggerQuery" field is null for all of our alerts. I'm trying to write a swql query that combines 4 universal Device pollers with a custom property on a node. Nov 20, 2023 · thank you for addressing the question, as mentioned, when Group based alerts are in place, only group based custom properties can be set. SolarWinds Query Language (SWQL) is a proprietary, read-only subset of SQL. Apr 19, 2022 · I suspect the issue you are running into is with the variable use for the Custom Properties. The easiest place to work this out is in SWQL Studio in the SDK. 2, you can use SWQL to define what you want to see in your widgets on modern dashboards. Here's how it looks: So if I search XHG or Exchange, C: or D:, it will filter accordingly. commented out the special custom properties, fixed a typo Your changes are shown on the Select custom properties page. I would think I would be able to overcome this if I could add a custom property to the application side of things but that does not seem possible either. jsco kdlr dgmxx xdamuh pqfiohy pxqkpt nko dej cimbf sbgzkpk zautfr cjyfz anwtosfp wnkth rqjzpr