This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Node Reboot + Availability Report


iam trying to make report which shows Nodes Today's Reboot + Availability but SQL Query is not showing any result.

,COUNT(Nodes.LastBoot) AS [total boot count]
FROM dbo.ResponseTime
INNER JOIN dbo.Nodes
ON ResponseTime.NodeID = Nodes.NodeID
WHERE Nodes.ATM_Branches = ' atm branches'
GROUP BY Nodes.Caption

SQL Query Empty Output: