Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

SWQL Code HELP!!!!!!!!!

Looking to create a report on a set of nodes, unsure if these would be 4 separate reports/codes or could be written into the same set.

If any one has any insight it would be greatly appreciated.

(1)Total Number of All Nodes (based on a custom property)

(2)Total Number of Nodes (based on a custom property) Up or Down

(3)Percentage(%) of Nodes Up

(4)Percentage(%) of Nodes Down

Find more posts tagged with

Accepted answers

All comments

rmullal

These can all be created with out of the box reports.

Just filter that "All Nodes" resource

You could use something like this:

amjannah

You may have made my life super easy!

1 question though: how can I pull more than 1 custom property in this section?

rmullal

I haven't tried it myself, but I think you could use an OR like this:

City = 'Atlanta' OR City = 'New York City'

Let me know if that helps.

wluther

amjannah Just use "AND"/"OR" then the next thing you want to filter.

City = 'Atlanta' AND Department = 'NOC' AND (Priority = 'High' OR Priority = 'Critical')

amjannah

The report works but its a ton of information. The node names and IP aren't terribly important for this particular report.

I need it to look like this if possible by way of OTB reports or SWQL

Number of Nodes at (Custom property location) | Number of Nodes Down at (Custom property location) | Percentage of Nodes Down at (Custom property location)

500 100 20%

d09h

You might consider creating groups that are dynamically defined by these same custom properties. Then a summary page limited to that group would show only those group members. Future efforts could be based on the group and not require remembering exactly how the defining logic looked.

https://support.solarwinds.com/SuccessCenter/s/article/How-to-create-a-separate-group-details-view

For populating your groups, refer to this link (particularly step 5):

https://documentation.solarwinds.com/en/Success_Center/orionplatform/Content/Core-Creating-Groups-sw2591.htm

amjannah

I have the Nodes grouped properly by location, however, I was looking to get back a numerical count of the criteria rather than the criteria itself.

for example: Here's how the report returns now vs how I need it to return

New Jersey Nodes | New Jersey Nodes Down | Percentage of New Jersey Nodes Down

Node Name	A	Node Name	C
Node Name	B	Node Name	H
Node Name	C	Node Name	K
Node Name	D	Node Name	L
Node Name	E	Node Name	O
Node Name	F	Node Name	P
Node Name	G	Node Name	S
Node Name	H	Node Name	T
Node Name	I	Node Name	W
Node Name	J	Node Name	Z
Node Name	K
Node Name	L
Node Name	M
Node Name	N
Node Name	O
Node Name	P
Node Name	Q

-------------------------------------------------------------------------------------------------------------------------------------------------------------

New Jersey Nodes | New Jersey Nodes Down | Percentage of New Jersey Nodes Down

500 100 20%

mesverrum

Find and replace City with your property

select n.customproperties.City, count(n.nodeid) as Total, isnull(down.total,0) as Down, round((isnull(down.total,0)*1.0/count(n.nodeid)),2) as DownPercent

from orion.nodes n

left join (

select count(n.nodeid) as Total, n.customproperties.City

from orion.nodes n

where n.status=2

group by n.customproperties.City) down on down.city=n.customproperties.City

group by n.customproperties.City, down.total

d09h

This solution seems to meet some of the requirements. Dynamically populated groups as shown in my earlier post are used for this solution: https://thwack.solarwinds.com/docs/DOC-191677

amjannah

With the Group Member Aggregate script, what do i need to change in order to produce the same graph but 1 for current stats, 1 for 7 days , and 1 for 30 days?

d09h

I would suggest creating a group populated by custom properties. Then copy a group summary page and add the resources you want. Note the URLs which reference the group with netobject=C (some integer) where that is the group number for a particular group.

Example: https://oriondemo.solarwinds.com/orion/netperfmon/containerdetails.aspx?netobject=c:7&ismobileview=false

d09h

Check out native functionality of groups:

d09h

https://support.solarwinds.com/SuccessCenter/s/article/Filter-the-group-for-web-based-report_