The most recent content from our members.
Hi all, Hope someone can help. I have no idea about SQL/WSQL. I've copied and altered as best I can to get the info needed. I had started work a couple of years ago on modern dashboards. I've got a basic high level overview of all devices (up/down/critical etc) which is fine for now. I then started to build dashboards for…
Hi guys. Know about the old problem, when you can't just gather multiple rows and put it in alert body in easy way, but dunno how to solve it. So I have this simple query: SELECT TOP 10 * FROM APM_WindowsEvent_Detail INNER JOIN (SELECT ID as CID FROM APM_Component WHERE ComponentOrder=1 and ApplicationID = 728) CID ON…
Hi! Could you help me with a simple query to gather some components' statistic data with it's timestamp? Just not sure about exact tables which I need to query. I have a component with id = 500, which is a child of application id = 322. As a result I want to get a table like this:…
Where I see a major problem with WSQL is returning properties for a node, where you don't know what is available. You can use a query like: SELECT Name FROM Metadata.Property where EntityName = 'Orion.Nodes' to return all possible properties for nodes, but the problem is that the list that is returned appears to contain…
brief: i have "custom chart" in web reporting with many series.. It works fine, and i can define swql query as i need. But i want users to be able to interact more with graph. I want them to see only what they will select. in reporting services in MSSQL i was used to to add pulldown menu with own dataset. Selected items…
Hi, I have a group of groups for which I would like to show only event and alerts that are down and not unmangaged using the custom query can anyone point me in the right direction or help? I found the Filter Syntax document but the examples do not work. Can anyone help please?
It looks like you're new here. Sign in or register to get started.