jm_sysadmin · Sr System Engineer · ✭✭✭✭✭

So I think that you are used to something like the output of PowerShell's get-printer, like: Get-Printer | Select Name, PrinterStatus The template you mentioned is designed to handle the entire server. For instance, 1 of my print server has 350 queues, I want the template to summarize it. And, SolarWinds does not know you…

From the product forums, select the product you want to make a feature request on. Then you should see 'Feature Requests in the list like below (bottom right of the image)

Definitely use Orion insights: https://customerportal.solarwinds.com/Support/orion-insights It might give you some ideas of what bottle necks you might have. its not specific to your runbook, but could give you ideas what to check. 

NPM and SAM will monitor anything that lets them get information. It starts with ICMP ping, and SNMP. If you can ping it and the device has SNMP to send traps or read communities, then it can be tracked in Orion (Orion is the common platform that NPM and SAM use, included when you purchase it). Other data can be pull from…

You should be good. And maybe this link will help you: SAM API Poller Template Guide (solarwinds.com) These are the most current monitors for M365 (and other stuff)

They haven't updates the links everywhere yet, but I think this is what you want NPM 2020.2.6 Release Notes (solarwinds.com)

Oh, and the best network latency (since you are thinking about that) come from IPSLA tests that Cisco can do, and VNMQ can monitor. They obviously are specific to a path between 2 cisco devices and I think typically a TCP port. But they will also give you jitter and other metrics. 

So generally in Orion shows Average Response time (from the Orion server) as Network Latency. Latency means a bunch of things when you monitor, so its always specific to what you are thinking about. A VMware admin or a storage admin, or a windows admin will likely all pick different metrics. Now if you have a specific…

BTW, I am guessing that you are alerting on the 'failed' from the call manager stats. If you go to the 'VoIP CallManager View' for the CM that alerted you should have a perfstack widget for failed calls. If you go to the 18th, and show all day, what does that graph look like? Does it go above 30? I still want to get the…

in the yellow bar can you drop down the down arrow on the right side? There should be an option to 'Show SWQL' so you can copy and paste that here. I want to use that to build a query that pulls the same stuff, but shows the details for the 18th. 

Yah, I can confirm it works for me like it works for you. And you definitely pinpointed the issue. I don't know why it accepts 0 in 1 query and not another. WEEKDIFF(0, GETDATE())Can you replace the 0 with the start date? I think that will iron it out. 

Yah, in a perfect world you have groups not users added to Orion from AD or SAML and then something that maintains those groups (could be you looking on a regular schedule, could be scripts, or products that manage idenity based on HR information, etc) so the correct people have the correct access. 

I like to see this type of value over time as line chart, so I add the value to Perfstack. Then I can add that chart to a dashboard. 

So don't think to much about supported devices. If you have a device, it likely uses the common MIBs that nearly everything does, and if not you can use a custom poller to remap 'standard' things like CPU and ram, or a UnDP to gather non-standard information. You can see the aggregate of all the MIBs at:…

Is this a question, request, observation? How can we help you? 

I am not a DBA. I am not a Developer. I do however spend my life fixing slow things. Lets talk about what happens when you add an index, first, the information that you index is added to another table that is optimized for a specific search. Indexes aren't free, and the more that you have the more work needs to get done…

I actually use a property for environment. Production must be set for the alerts to fire (some include nodes without anything set). Use the under strict values you can set up a drop down list and set your desired values. We have production, test, dev, staging, pre-prod, and decommissioning. 

I didn't answer all the things you asked, I run some of me things from the Orion server as a scheduled task today, but we are centralizing all of our schedule scripts for a bunch of things in an automation server. (We use RunDeck) 

In the config, use the Widget Link URL, and point it to anything. I often send them to a report or a classic dash. 

I basically feed the IPs that aren't in Orion already into a discovery job, which is mostly what @"mesverrum" put together, and some from the Samples SDK. (+) Powershell script to use the API to discover interfaces on nodes - Orion SDK - The Orion Platform - THWACK (solarwinds.com) More from him at his git: GitHub -…

I think I have a typo! Sorry about that. N.NodesCustomProperties.App_Function should be N.CustomProperties.App_Function SELECT COUNT(N.NodeID) as value, N.Status as status, N.CustomProperties.App_Function FROM Orion.Nodes N Where N.CustomProperties.App_Function LIKE '%Domain Controller%' GROUP BY N.status Order By…

What type of certificate? What do you need it to do? Certificates are kind of a broad topic. Is this for moving the site to HTTPS? 

I would use something like this: SELECT Count(N.NodeID) as [Total Devices] FROM Orion.Nodes N where N.CustomProperties.Support_Group like '%Value%' In the example, 'Support_group' is the name of the custom property and its looking nodes with a string that contains 'Value' If you have issues, give me the name of the…

I don't, but maybe one of these relationships point you in the right direction? My voice team has enough coded into the CM name to figure out what they need. Select top 100 VCD.CCMMonitoring.DisplayName , VCD.CCMMonitoring.ClusterName , VCD.CCMMonitoring.MonitoringType.Code , VCD.CCMMonitoring.MonitoringType.Description ,…

So generally they do start up automatically by default. After the install, in the service properties they should be set to autostart. This article says it might help to use the delayed start: Orion Services do not start after a reboot when SQL is installed on the Orion server (solarwinds.com) I would give it another…

Also, check out: SWQL Functions · solarwinds/OrionSDK Wiki · GitHub if you haven't already. And take a look at a post from not long ago: https://thwack.solarwinds.com/product-forums/network-performance-monitor-npm/f/forum/91154/dashboard-swql-question/290462#290462 It uses a case statement that takes the status values and…

Does this work? I didn't test with the custom properties, but without it seemed ok. SELECT COUNT(N.NodeID) as value, N.Status as status, N.NodesCustomProperties.App_Function FROM Orion.Nodes N Where N.NodesCustomProperties.App_Function LIKE '%Domain Controller%' GROUP BY N.status Order By COUNT(N.NodeID) desc

SELECT Count(DisplayName) as [Call Count] , Sum(Duration) as [Call Duration in Seconds] , CallManagerName , Case When Month(DateTimeOrigination) = 1 Then 'January' When Month(DateTimeOrigination) = 2 Then 'February' When Month(DateTimeOrigination) = 3 Then 'March' When Month(DateTimeOrigination) = 4 Then 'April' When…

And don't hesitate to open a ticket if you can't get it going. 

Yup, I have a similar thing, let me dig it up.