ecmel

Thanks @"martian_monster" You can import them to your existing platform but the Proportional Widget ("Pie Chart") links will not work as that support was provided with SolarWinds Platform version 2022.3. You should still be able to see data on pie charts and all other widdgets should work.

in All in on Modern Dashboards Comment by ecmel April 2023

I think it is in roadmap (please see Schedule Approval section) but not supported on Patch Manager for now: thwack.solarwinds.com/.../wwwo

in Auto-Approve All updates for a specific 3rd party product using Patch Manager Comment by ecmel August 2024

If you are using client side PowerShell script execution option before or after the upgrade operation, it is only supported for WMI providers not for Agents. You can see details here: documentation.solarwinds.com/.../spmag_createpowershellscripts.htm

in Patch Manager Agent vs WMI Features Comment by ecmel March 2024

I understand that you receive the error when you try to assign the AppInsight for AD temlate to your server on ""Manage Templates" page. Have you tried adding this application monitor with discovery? You can run "List Resources" on your AD server node and then you should be able to see a checkbox for assigning AppInsight…

in Cannot Add AppInsight for Active Directory Template to a couple of domain controllers Comment by ecmel June 2023

I saw that message in SWQL Studio: If you haven't used SWQL Studio before, I would strongly recommend it as you can easily create and test your queries or other API actions. It is coming as part of Orion SDK. I'm sharing several links below:…

in For Powershell monitor, where is "Multiple Statistics Data" historical data in SWQL? Comment by ecmel May 2023

Hi, For the latest data, you can use "Orion.APM.MultipleStatisticData" to pull the string value with StringData column. For historical data, I guess there is a problem in the latest release. I can see string data in "Orion.APM.DynamicEvidence" table for the rows having ColumnType value set to "0" in an installation running…

in For Powershell monitor, where is "Multiple Statistics Data" historical data in SWQL? Comment by ecmel May 2023

This folder contains templates for remote sessions. I don't know the reason why it is deleted but you should be able to find the same folder on your Patch Manager server. Default location is: C:\Program Files (x86)\SolarWinds\Patch Manager\Server\Templates You can give a try by copying the content of the server folder…

in Could not find a part of the path Comment by ecmel May 2023

If you use "Component" as your alert object, you can choose "Browse All Objects" option in the trigger condition item and then select "Multiple Statistic Data" -> "Statistic Data Message" field as shown below:

in Provide message text from a SAM Component monitor to the alert Comment by ecmel May 2023

This can be resolved in the SWQL query. You can use ToLocal function to convert the event time to your local time. It should be something like this: SELECT ToLocal(EventTime) as [Event Time] ...

in Modern Dashboard Time Event showing GMT Comment by ecmel May 2023

Have you checked the out-of-the-box profiles? There are two profiles for Linux, these can be assigned to your servers or you can check the configuration of them to create your own custom profile definition based on your requirements.…

in Linux and SCM Profiles. Has Anyone Written a Linux Profile and are they willing to share? Comment by ecmel April 2023

I guess that you have the modern Dashboard content defined in your script statically. It would be better to define your content in a file and then use this file as input to your script. You can find a clear explanation of the process in this link:…

in I'm looking for help importing Modern Dashboard with PowerShell. SwissPower module is installed locally on the Orion server, func_ModernDashboards.ps1.ps1 is in the same folder, but..func_ModernDashboards.ps1 throws an error.The ' Comment by ecmel April 2023

I think there is no easy way to pull the account that scheduled the maintenance. As shared previously, this information can be gathered from Audit Events but I'm not sure about the performance of the query in a large environment. I updated the query as below and it worked as expected in our LAB environment: SELECT n.NodeID…

in Looking to create a Scheduled Unmanaged Node Report Comment by ecmel April 2023

Default configuration in SolarWinds disables alert actions on unmanaged objects. You can enable it by checking "Allow alert actions for unmanaged objects" checkbox in "Polling Settings" page as explained in this support article:…

in Force an alert action to trigger even when a device is unmanaged. Comment by ecmel April 2023

Hi, Patch Manager scheduled tasks can be configured for different reasons and each task type can be configured on a specific area on Patch Manager Console. I provided the list and related link of task types that can be configured below: Schedule updates:…

in Patch Manager | How to create a Scheduled Task Comment by ecmel April 2023

Hi @"mjonathan" Did you check your firewall logs for any access blocked message from you SolarWinds server? Or could it be related to the action configuration as it requires payload definition on "Send a Get or Post Request To a Web Server" action type? I guess you already checked but could you check your payload…

in Microsoft Teams Integration with Orion Alerts Comment by ecmel March 2023

I think it is not supported for cluster mode and you need to raise a feature request as mentioned in the support article: "Note: NetApp cannot be in cluster mode. It must be in 7 mode. If you are interested in monitoring Cluster mode, please create a feature request with SolarWinds Support or via the THWACK forum."

in Integrate NetApp or EMC SAN with SolarWinds SEM Comment by ecmel February 2023

In this case, you can use AddDate function in SWQL to adjust the datetime for your requirement. The example below shows filter for yesterday between 10:50 and 11:05: i.DateTime >= AddDate('hour', 10, AddDate('minute', 50, DATETRUNC('day', GETUTCDATE()-1))) AND i.DateTime < AddDate('hour', 11, AddDate('minute', 05,…

in SWQL for pulling yesterdays data between specific timestamps Comment by ecmel February 2023

You can convert the last part of your query to the following statement, it should return the data for yesterday only: i.DateTime >= DATETRUNC('day', GETUTCDATE()-1) AND i.DateTime < DATETRUNC('day', GETUTCDATE())

in SWQL for pulling yesterdays data between specific timestamps Comment by ecmel February 2023

The minimum requirement that SolarWinds supports for WMI access to a server is a local administrator user on the target machine. If you would like to use a non-admin user, then you can find the configuration details in the link below but the setup of this account is not supported by SolarWinds:…

in The minimum privilege or least amount of privilege for Solarwinds SAM monitoring service account? Comment by ecmel February 2023

This information comes from "Asset Inventory" polling so firstly you need to make sure that "Asset Inventory" polling is enabled on your servers that you would like to generate the report. Then you can use "Custom Table" or "Custom Query" widget in your report and define "SWQL Query" to pull data from Asset Inventory and…

in How to get a report on Logical Volumes with file system type Comment by ecmel February 2023

I didn't notice this issue before but it could be related to a Windows update (KB5019964) released on 8th November: https://support.microsoft.com/en-us/topic/november-8-2022-kb5019964-os-build-14393-5501-5c195bd1-91d5-402e-a973-813373ba4357 On this page I see that the memory leak issue is resolved with another update…

in Lsass.exe memory leak on primary poller Comment by ecmel February 2023

As far as I know, there isn't a CLI credential management page for this purpose but if you would like to assign the same credential to multiple nodes, then you can use "Manage Nodes" page. You can select the nodes that you want to assign the same CLI credential and then click on "Edit Properties" to enable CLI polling and…

in Can I assign multiply Nexus deviecs with CLI polling credentials? Comment by ecmel February 2023

You can join your original query with another table that always contain a single row. Then you can use ISNULL check for your column. You can try the example below: SELECT ISNULL(StatusStep, 'All is well') as StatusString FROM Orion.Engines E LEFT JOIN ( SELECT CONCAT ('StepId:', TransactionStepId, ' -…

in SWQL Query to Return a String if No Row Matches Are Found Comment by ecmel February 2023

I can list the tables related to your requirement below: AlertActive: list of active alerts AlertObjects: list of alert objects (containing related node information) AlertConfigurations: list of configured alert definitions Nodes: list of nodes This is an example SQL query to pull the data using join statement: SELECT…

in Active Node alerts with associated IP address? Comment by ecmel February 2023

In your SWQL query, you need to reference your Custom Property using link from Orion.Nodes object alias as shown below: SELECT count(1) as countnodes FROM Orion.Nodes N WHERE N.CustomProperties.NODES_TYPES = 'server'

in Using Custom properties field name as variable for Modern Dashboard SWQL query Comment by ecmel February 2023

You can achieve this using SolarWinds PowerShell module. This is an example code to disable an alert definition: $hostname = "SW_HOSTNAME" $username = "SW_USER" $password = "SW_PASSWORD" $swis = Connect-Swis -host $hostname -UserName $username -Password $password $AlertID = 22 $alert_uri = Get-SwisData $swis "SELECT top 1…

in Enable and disable alerting rule Comment by ecmel February 2023

The text below should display data in your format: NET - Region:${N=SWQL;M=SELECT TOP 1 g.Name FROM Orion.Groups g INNER JOIN Orion.ContainerMembers m ON m.ContainerID=g.ContainerID WHERE g.Owner='Core' AND m.MemberEntityType='Orion.Groups' AND m.MemberPrimaryID=${N=SwisEntity;M=ContainerID} ORDER BY g.ContainerID}…

in How can I Incorporate the parent group of a "Group Down" in an automated Alert Message? Comment by ecmel February 2023

This information can be gathered using Windows PowerShell script monitor component type in SAM. You can use "Get-FileShare" PowerShell cmdlet to get list of file shares on your target servers. You can find the usage of this cmdlet in this…

in Need help obtaining File Shares hosted on a Windows Server Comment by ecmel February 2023

Having agent on one of the servers should be sufficient to display dependencies but you need to ensure that both servers are monitored as "nodes" in your SolarWinds platform. Additionally, your Linux server must support GNU C Library (glibc) 2.18 or later. This link provides further details on how this feature works:…

in Application Dependency Mapping Comment by ecmel February 2023

The following SWQL query should provide the list of all components that are not in "Up" state: You can change "where" clause in the query to filter them based on a specific status or any other attribute. SELECT c.Name as [Component Name] , c.Application.Name as [App Name] , c.Application.Node.Caption as [Host Name] ,…

in SWQL to get down application components? Comment by ecmel February 2023

ecmel · Senior SolarWinds Engineer · ✭✭✭✭✭

Comments