I have written a report to show the Interface Error/discards for the day for specific nodes. However, some nodes may have 20 interfaces and I need only one or two. The query is below, I have removed the nodes names. I cannot use AND because I am selecting several nodes and all interfaces are listed under each node. How do I exclude interfaces.
SELECT
Nodes.Caption AS NodeName, Interfaces.InterfaceName AS Interface_Name, Interfaces.InDiscardsToday AS InDiscardsToday, Interfaces.InErrorsToday AS InErrorsToday, Interfaces.OutDiscardsToday AS OutDiscardsToday, Interfaces.OutErrorsToday AS OutErrorsToday, Interfaces.Status AS Status
FROM
Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID)
WHERE
(
(Nodes.Caption LIKE 'R-xxxxx%') OR
(Nodes.Caption LIKE 'R-xxxxxx%') OR
(Nodes.Caption LIKE 'R-xxxxxxxx%') OR
(Nodes.Caption LIKE 'Cxxxxxxxxxx%') OR
)
ORDER BY 1 ASC