The most recent content from our members.
Hello Thwack Team, For the below working query - which works in custom swql dashboard resources and in swql studio, SELECT TOP 1 ARRAYVALUEAT(SPLITSTRINGTOARRAY(Replace('Part1-Part2-Part3-Part4','-','|§|§|')),0) as Field1, ARRAYVALUEAT(SPLITSTRINGTOARRAY(Replace('Part1-Part2-Part3-Part4','-','|§|§|')),1) as Field2, CONCAT(…
I am trying to get the hardware information in my nodes report. How do I get that? Any suggestions or ideas please? Here's the below screenshot which displays hardware information of any node on the node details page. Whether it is virtually hosted or a physical one. I was working on SWQL which gets the list of all the VMs…
I would love to see some more filter options when it comes to CSAT as we have internal tickets that are requested and assigned to the same person we should be able to filter these out either by adding a Tag or something.
I am working on a report to get the Avg and Peak CPU load, Memory for my monitored servers. The requirement is that I want to see the following information: Hostname (Managed Node), IP Address, MachineType, Vendor, Site (Custom Property), Avg CPU Load (In Percentage), Peak CPU Load (In Percentage), Avg Memory (In…
Ability to build and save custom reports based similar to standard SQL queries. Giving the ability to pull data from a module outside of reports built into SWSD. In order to build these, allow customers to submit a request to SolarWinds with the information they are wanting to pull and the SWSD support team can provide the…
I am building a SWQL query to grab MAC address and SerialNumber from MikroTik devices. We have it mostly working, but I am struggling getting the query to properly pull the SerialNumber from the Universal Device Poller we have set up. Normally, I would simply grab the ServiceTag from the database, but these devices do not…
I'm trying to make a report that excludes 1 or 2 specific categories / subcategories, and right now the only way for me to do that is to select every category except the ones I want to exclude. The bigger problem with this is that if we later add categories, I have to remember to add the new categories to this report. It…
Please create a report to see which technicians (Service Desk Agents) are available the most per day/week/month. This is for round robin ticket assignment. I would like to see how often techs are available or not available in Service Desk.
Hello Everyone - I have not done any reporting for awhile in Solarwinds so the gears are a bit rusty. I am hoping someone can point me in the right direction. I setup a SAM monitor for TCP Port Usage Count for nodes because we have a few that keep running into Port Exhaustion issues. I used the 'out of the box' Power Shell…
Morning. Trying to get my head around this one, but its proving to be a nightmare. I want a report of all nodes, which alerts that can trigger on said node, and related ServiceNow actions on the alert(s) that can trigger For example: HOSTNAMEIPAlert NameService now dataTEST-HOST10.10.10.1Device down in AWSFull details…
It looks like you're new here. Sign in or register to get started.