I want a SWQL command to know the up status of 5 specific nodes. Recently I have upgraded my environment to 2020.2 and implementing a modern dashboard. But the problem is I'm new to this SWQL structure, so bit difficult me to figure out the correct command and seems like all the widgets are following the same structure. Can any one please help me out.
This should get you started. Just replace the display names with the names of your servers and add whatever additional fields of information you're wanting to display.
SELECT [data].[DisplayName] AS [DisplayName],[data].[InstanceSiteId] AS [InstanceSiteId]
FROM orion.nodes AS data
((([data].[Caption]) = ('Tex-3750.aus.lab')) OR (([data].[Caption]) = ('tex-esx-01.lab.na')) OR (([data].[Caption]) = ('tex-esx-02.lab.na')) OR (([data].[Caption]) = ('tok-1131AP-A')) OR (([data].[Caption]) = ('tok-bro200e-01')))
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.