The most recent content from our members.
Hi, We have setup groups with multiple level like the following exemple Email service - Exchange server - Production - node 1 - node 2 - UAT - node 4 - node 5 - Mailrelay - node 3 We need to list all node per Group root ie i like to query the Group Root and have a list of the nodes node 1, node 2, node 3, node 4, node 5. I…
Please help me query SQL filter report summary node down in last month. SELECT * FROM ( SELECT IP_Address, Nodes.Caption, Nodes.StatusLED, Nodes.NodeID, StartTime.Message, StartTime.EventTime AS DownEventTime, ( SELECT TOP 1 EventTime FROM Events AS EndTimeTable where EndTimeTable.EventTime >= StartTime.EventTime AND…
It looks like you're new here. Sign in or register to get started.