Seashore · Solutions Architect · ✭✭✭✭✭

Comments

  • When you create a SQL or Oracle query in orion, the result has to be once single value, and that value has to be an integer. In your case, I suggest the query is changed so that it counts how many blocking sessions there is. Then you have a critical-threshold on the component in SAM, maybe when nr of blocking is more than…
    in How to create a custom SQL blocking alert for Oracle Comment by Seashore September 2020
  • Have you tried with a local orion account? Can also work when using a domain account to add "-Trusted" on the "Connect-SWIS"-command. Not sure if that is due to a certificate issue of different domains issue.
    in Getting Error - PowerShell Query Comment by Seashore September 2020
  • As you might know, in SAM you can use SQL queries against the SQL databases to collect information. The only thing you have to consider is that the output of the script have to be on single numeric value (and an optional string). The query also have to give you a 0 if there is no result, null is not allowed. So when…
    in monitor Database job Comment by Seashore October 2020
  • As Footprint service desk seem to have an API already I suggest you use a power shell action in an alert to call their API and open a case. That's how I do it with other service desk solutions.
    in FEATURE REQUEST-Integration with FootPrints Service Desk-Case # - 00608493 Comment by Seashore September 2020
  • Try this: https://support.solarwinds.com/SuccessCenter/s/article/Restore-password-for-an-Orion-Web-Console-user?language=en_US /Thomas
    in SAM Admin permission Comment by Seashore September 2020
  • SELECT VirtualMachines.Uri, VirtualMachines.DisplayName FROM Orion.VIM.VirtualMachines AS VirtualMachines INNER JOIN Orion.VIM.Hosts H ON VirtualMachines.Hostid=H.HostID INNER JOIN Orion.VIM.Clusters C ON H.ClusterID=C.ClusterID where DayDiff(virtualmachines.OldestSnapshotDate,getdate())>14 AND C.Name…
    in Need help with SWQL to limit Out of Box alert regarding snapshots Comment by Seashore October 2020
  • The checkboxes are booleans. So field=1 should work or somthing like that.
    in DB query with a checkbox Comment by Seashore October 2020
  • Hi Can this be a way forward: Create your component in a test-template or whatever you call it. Then with this view (sam settings / manage component monitors within templates) you can copy a component to another template or application.
    in Create Custom Components Comment by Seashore September 2020
  • If you are a customer with maintenance you can download it from your customer portal. Look at "offload installation". There you can find older version. Installing that one on your test server without license will give you a test-environment.
    in Need a setup file for NPM12.2 or 12.4 Comment by Seashore August 2020
  • Hi I probably would have tried the same way as you did first. Found out another way of solving this though. Haven't tested it enought but it runs... SELECT aa.AlertObjectID ,ah1.AlertObjectID ,ah1.Message ,ah1.TimeStamp From Orion.AlertActive aa join Orion.AlertObjects o on aa.alertobjectid=o.alertobjectid LEFT join…
    in Alert Table Including Latest alert notes Comment by Seashore October 2020
  • Hi and welcome to IPAM! No, IPAM Custom Properties can either be set on Group or Single IP address level. All three, Groups, Subnets and supernets are groups but of different types. Looking at the database level you can see they are all in the same table, [dbo].[IPAM_Group], but with different [GroupType]. Some built in…
    in IPAM custom fields Comment by Seashore October 2020
  • Thats right, with that query you only get one set of numbers, how many nodes that have that status right now. What you want is the historical data also. How many nodes that was critical yesterday etc. I dug around but I could not find that info. I think it should be there but right now i didn't find it.
    in NODES count grath with SWQL Comment by Seashore August 2020
  • Hi I would say that you can do most of the things you and your dba wants with SAM. For example you can run queries against SQL to get almost any information, you just have to form the answer into a single integer. ex. how many databases has NOT been backed up last 24 hours, or how many SQL jobs with the name "Important *"…
    in Microsoft SQL Server Monitoring Options Comment by Seashore August 2020
  • Is it working if you use a browser on the orion server? Can you reach the websites then? Or powershell "test-netconnection [hostname/ip-address] -port 443"
    in SSL Cert Expiration Monitor Faling Comment by Seashore November 2020
  • Hi Maybe something like this: Create a "Custom SWQL Alert" based on Node. Add the following to the editable frame: INNER JOIN ( SELECT n.caption, N.NodeID ,va.score FROM Orion.Nodes AS N INNER JOIN NCM.VulnerabilitiesAnnouncementsNodes AS VAN ON N.Nodeid=VAN.CoreNodeid INNER JOIN NCM.VulnerabilitiesAnnouncements AS VA ON…
    in Create Alert based on Vulnerability Count and CVSS Score Comment by Seashore November 2020
  • There is already a report prebuilt for group availability. You can copy that and change the time. BUT, if you need the SWQL here is an example: SELECT C.Name AS [GroupName], AVG(CS.PercentAvailability) AS [Availability] FROM Orion.ContainerStatus CS INNER JOIN Orion.Container C ON CS.ContainerID=C.ContainerID WHERE…
    in NPM Group availability report in swql Comment by Seashore November 2020
  • The monitored value of CPU is just when orion polls the CPU info from the node. Realtime is... real time. It shows the value all the time. Sometimes it is the polling that spiked the CPU on the node. Try restart om WMI service to see if that helps. 
    in How do I pin point which processes using high CPU? Comment by Seashore November 2020
  • Two things to now about the time of reboot: * The timezone of all orion-servers, incl SQL, must be the same * The reboot time is that of the snmp-service and not the node, if polling with snmp
    in Last Reboot Time Updated Incorrectly Comment by Seashore October 2020
  • See https://thwack.solarwinds.com/t5/Report-Lab-Discussions/SQL-Query-Add-Interface-Configured-Bandwidth/td-p/606726, same question right?
    in SQL Configured Speed Entry - Add to report Comment by Seashore October 2020
  • If you have configured a custom bandwith [dbo].[Interfaces].[CustomBandwidth] will be =1 and [InBandwidth] and [OutBandwidth] will have the values you configured. So I would just have a column that states if the bandwith was customized or not, and maybe also the bandwidth on all interfaces.
    in SQL Query - Add Interface Configured Bandwidth Comment by Seashore October 2020
  • Monitor the cluster-object as well, and the cluster disks are monitored on the cluster-object. IE, If you have SQL clustered. Monitor the SQL instance as a separate node and the disks that belong to SQL are monitored on the clustered SQL node and NOT on the hosts. So you monitoring a cluster with 2 nodes and one service…
    in Shared Drive monitoring for a Clustered Server Node Comment by Seashore November 2020
  • Strange! Installed a new 2020.2.1 and I got it under: C:\Program Files (x86)\SolarWinds\Orion\NPM\UniversalDevicePoller.exe You did install NPM and not just any other orion module? It's a part of NPM.
    in NPM UnDP is not available Comment by Seashore November 2020
  • Sorry, not possible right now. Hope they fix it 'til next version...
    in restrict user to access Manage Dashboards Comment by Seashore November 2020
  • Many things on the report page is not configurable, but if it's a scheduled report you are after there is another way.... You can create a view that has the reportcontent you like. use the Custom table widget and custom html to create headers. In the report scheduler send a view instead of a report, send the view in…
    in Report sections and sub-title Comment by Seashore November 2020
  • Updated code as I found some issues.
    in How to get DPA "overview table" in Orion Comment by Seashore August 2020
  • Change the path to the page a bit, add "?Printable=true", that will remove all header and footer info. So changed line will be: var path = urlPath + "/ui/netpath/routeinspector/" + pathID + "/" + pollingEngineID + "/" + nd.getFullYear() + "/" + ( nd.getMonth() + 1 ) + "/" + nd.getDate() + "/" + nd.getHours() + "/" +…
    in NetPath in a Widget Comment by Seashore November 2020
  • A script that parse that file, taking one of the values as output into the orion sam component. Then you can add thresholds to that. Seems possible. But I don't have the skills to write the code but it seems possible.
    in Monitor a csv status file Comment by Seashore October 2020
  • The response time is how long the component script took to execute. Statistics is the value the component/script gave back to orion.
    in Download Speed Monitor Comment by Seashore October 2020
  • Hi Interesting question! One idéa. If you get all the historical values for last 12 hours, do an average on that. If the average is equal to your threshold then show the value. Or do a MIN, to show the minimum value. Can that work?
    in SWQL query: custom poller (status or currentValue) != x for last 12 hours Comment by Seashore October 2020
  • I Don't think you can. Maybe you can change some property on an entity that triggers you alert.
    in Can we send an event or alert to orion solarwinds using rest api? Comment by Seashore November 2020
Avatar