Anyone wants to generate Count down report. below query may be useful.
SELECT COUNT(NodeID) 'Count Of Links Down', vendor FROM [dbo].[Nodes]
WHERE Status = '2' and ( vendor in ( 'X')
and ( CITY='X'
OR Location = 'X' ))
GROUP BY vendor
