m_roberts · CEO · ✭✭✭✭✭

Comments

  • Review the Alert action logs to see if it provides more details: C:\ProgramData\Solarwinds\Logs\Orion\ActionsExecutionAlert.log C:\ProgramData\SolarWinds\Logs\Orion\Alerting.Service.V2.log You 'may' need to adjust the log level, which you can do with the Log Adjuster utility…
    in Webhook with teams Comment by m_roberts March 2022
  • Hi This is an example of our default Node Down template for Teams webhook, which we would then extend the content as applicable for the customer installation we are working on i.e. adding Custom property values, severity values, specific wording for the team etc. { "@type": "MessageCard", "@context":…
    in Webhook with teams Comment by m_roberts March 2022
  • I don't necessarily agree that this has to be SW officially delivered. It will be wrapped in to Thwack I would suggest, so has that official linkage, but there are people in the community that could lead training sessions on the use of API. Someone taking on the subject of how to (for example): * Available methods to…
    in SWQL Study Group for the complete novice - thoughts? Comment by m_roberts March 2022
  • The Orion NCM module performs a configuration backup of network devices such as Cisco switches. Within this backup is the definition of the local user accounts configured on the device. Therefore, with this data available in the Orion database, you can then create a report from that data. The report query will be a bit…
    in Is it possible to query Cisco switches using a report to show what users log in to them? Comment by m_roberts March 2022
  • Hi, This is related to the structure of the variable depending on Object you are alerting on. For example, you can see the different variables for the Node Caption (Name), between the different Object types here: Alert Object TypeVariable for…
    in Email HTML Alert issues Comment by m_roberts March 2022
  • Hi, The Orion SAM module provides support for MongoDB. The following link shows the 'default' out the box templates available, but these can be extended to collect further information if required: https://documentation.solarwinds.com/en/success_center/sam/content/sam-mongo-sw5644.htm If you need something more focused on…
    in how i can monitor mongoDB in solarwinds? Comment by m_roberts March 2022
  • I believe you are hitting an issue either with your Orion using a self signed SSL cert or you are using an address in PowerBi that does not match your SSL certificate. Either: 1. Update the address to match your SSL cert 2. Disable in PowerBI setting for 'Enable certificate revocation check', which is in the Options >…
    in Solarwinds and PowerBi Dashboard? Comment by m_roberts March 2022
  • Yes, here you go - the query to support my screenshots above: DECLARE @TopXX INT SET @TopXX = ( SELECT CurrentValue FROM Settings WHERE SettingID LIKE 'Web-MaximalNumberOfSeriesInChart' ) SELECT AHV.RelatedNodeId ,N.Caption ,cast(floor(cast(AHV.TIMESTAMP AS FLOAT)) AS DATETIME) AS RoundedTime ,count(AHV.RelatedNodeID) AS…
    in Alert Chart Comment by m_roberts March 2022
  • Something like this should be what you are after SELECT n.Caption, n.Lastboot, n.CustomProperties.Site, n.CustomProperties.DeviceType FROM Orion.Nodes n WHERE n.LastBoot < adddate('year',-1,getutcdate()) AND n.CustomProperties.Site = 'xxx' AND n.CustomProperties.DeviceType = 'Switch' If it is, please mark as answered, to…
    in System Up Time Comment by m_roberts March 2022
  • I do not have time immediately to deal with the query, but the Custom Chart widget has the ability to support column tables. For a function like this I would use the Stacked Column, so you can clearly see within the same time period the number of Alerts that have been triggered, with a visual breakdown of those by the…
    in Alert Chart Comment by m_roberts March 2022
  • You are right, the use of IP Groups will allow you to define IP addresses in use at each of your remote sites. This will then allow a report to be rgenerated where you can see traffic going to and from those IP ranges. 
    in Interface utilisation - Internet traffic only Comment by m_roberts March 2022
  • It sounds like it may be a good idea to use Custom Properties to enrich your data against each node. One of the solutions for your requirement may well be to use a Custom Property field to store who should receive an email alert related to that node. The following article details how to do this…
    in App owners Comment by m_roberts March 2022
  • Creating an Orion Report where your condition filters are: Custom Property name is empty The following post will help - thwack.solarwinds.com/.../nodes-with-empty-custom-properties
    in Report on objects without Owners Comment by m_roberts March 2022
  • The Application Connections feature of SAM, whereby using agent based monitoring can collect Netstat type data. This if enabled would provide a method to capture the inbound connections and the ports being used. https://documentation.solarwinds.com/en/success_center/sam/content/sam-application-dependencies-overview.htm If…
    in Server port monitoring Comment by m_roberts March 2022
  • The > is HTML character encoding, which you can use online resources to convert the text: https://www.web2generators.com/html-based-tools/online-html-entities-encoder-and-decoder If you are running this through some form of script, then most languages have an inbuilt decode method such as HtmlDecode in PowerShell
    in Is there an API with an example that I can use over REST that can basically pull a report in a CSV format Comment by m_roberts March 2022
  • What SMS solution are you working with. I have never worked with any that uses a mechanism of a DB insert being performed. Usually it is API, command line or script based. If that is the only method, then yes I would write a PowerShell script to perform the DB update. That then depends on what the DB app being used is.
    in Need alerts to trigger action to make entry into db table Comment by m_roberts March 2022
  • I am not sure what you mean by 'spooling report', but for NPM polling the latency is from the Orion polling engine assigned to the device to the device. NetPath latency would be from assigned agent to target IP SLA would be from configured source Cisco device to destination
    in Average response time Comment by m_roberts March 2022
  • Try this 
    in Dashboard of Different Custom Monitors Comment by m_roberts March 2022
  • This will be straightforward to implement. * Add to the page you wish to use for this user group the Custom Table widget * Click Edit Data Source * Change the I want to report on to 'Component' * Add two filters which will only display SQL services with the component type being 1 meaning 'process'* Name Contains SQL *…
    in Dashboard of Different Custom Monitors Comment by m_roberts March 2022
  • You should have a log file called ActionExecutionalert.log in the directory, but this will by default populate when there are issues with the action. Therefore, you need to adjust the logging level to get greater visibility, with the following KB explaining how…
    in What logs should I check for Alert Action troubleshooting? Comment by m_roberts March 2022
  • Hi You need to utilise the Comparison Criteria feature in NCM to ignore these lines. The following page in the guide explains in more detail, for which in this situation a simple Regex for 'starts with' ^option name class-identifier and a second entry for ^option name client-identifier Obviously other regex definitions…
    in Filter out Running Vs Startup conflicts: DHCP and LLDP move around Comment by m_roberts March 2022
  • Yes it is possible to utilise the SW Patch Manager application to deploy MS Edge. It is possible to create your own software distribution 'package' which any application which has an exe or MSI installation can be deployed. The following section of the Admin guide explains this in more detail…
    in Deploying MS Edge via Patch Manager Comment by m_roberts February 2022
  • There is no direct GUI method to select the Group object and then display the Member average availability value. Selecting the Node object does not also provide the ability to filter by Group name. Therefore two options; 1. Use the same filter method you used for the Group population (Dynamic Queries are the best method…
    in Node availability report for specific group Comment by m_roberts February 2022
  • Hi This is a report you do not need to use custom SQL for. * Duplicate the out the box Average and Peak Traffic report * Edit the Data source (says All Interfaces) * Add a filter that matches your needs e.g. Vendor = Cisco * Adjust any other settings you need * Save and display
    in Interface Peak Utilization for specific vendor? Comment by m_roberts February 2022
  • I am thinking it may be better for you to use the Search option in the Custom Resource widget. This will allow you to search by the machine name, so you only see software installed on that machine. The following queries can be used: SELECT s.Polling.Node.Caption as [Node Name], '/Orion/images/StatusIcons/small-' +…
    in Solarwinds Installed Software Query Comment by m_roberts February 2022
  • If you edit your Account profile in Orion, there is a setting to define what temperature measurement you wish to use. Set that to the 'other' Fahrenheit value and your alert variable should work
    in Hardware temperature values in alerts. Comment by m_roberts February 2022
  • @"KMSigma.SWI" is right with his suggestion. Create a group, define the Status Rollup setting to be 'Worst Status' and put both of the devices in the group. The default Group down alert will work straight away, but you may wish to create a specific alert action, which looks for this group name and a group status of down.
    in Alerting when a device with two IP addresses are BOTH down Comment by m_roberts January 2022
  • Much of the data in the top section is collected natively by Orion (assuming you have ticked the 'Asset Inventory' box for your servers. Therefore, you could put together a report or series of reports to extract this data in a form that you desire. The following resources will help in putting a report/s together:…
    in Is there a server inventory template? Comment by m_roberts January 2022
  • The process needs to remove carriage returns and line spaces (not spaces). In Notepad++ I: * Ctrl-H * Settings to * Wrap around is ticked * Search Mode set to Extended * Find * \r\n * Replace with nothing * Replace All * Select All > Copy and then paste in to SWQL Invoke field </code></strong><strong><code>Hope this helps.
    in Importing/Exporting Modern Dashboards Comment by m_roberts January 2022
  • I just wanted to add to this, as this is a great write up on navigating through the entity structure, in that you can continue down the path chain. SELECT n.Caption, n.Description, n.NCMLicenseStatus.LicensedByNCM, N.Volumes.Description as [Vol Description], N.Volumes.SRMTopologies.StorageArray.Caption from Orion.Nodes N…
    in Implicit Joins - how please in simple terms? Comment by m_roberts January 2022
Avatar