NCM Query

Question

I am trying to get the total devices count on dashboard, which are currently not backedup using below query. 
 
 but still getting the wrong count, can you @ christopher.t.jones123 please suggest how i can get the notbackedup devices count. 
 
 SELECT COUNT (CASE LoginStatus WHEN '' THEN 1 else NULL end) AS [Count], 'Not Backed Up' as [Status] FROM NCM.Nodes

jm_sysadmin · Answer

This is what I use: SELECT 
 Count (Distinct N.Caption) as [Backups] 
FROM 
 NCM.NodeProperties as NP 
JOIN Orion.Nodes N ON N.NodeID = NP.CoreNodeID 
LEFT JOIN NCM.ConfigArchive CT ON NP.NodeID = CT.NodeID 
Where CT.NodeID IS Not NULL