I have a report that works but have now been requested to exclude certain nodes from it.
The easiest approach that I can see, is that all the nodes bar one have DS0 in their name so my WHERE statement looks like:
n.Interfaces.PhysicalInterface = 'Y'
and ClientPrefix = '123ABC'
AND NodeCaption LIKE '%DS0%'
But I now need to add an extra one device that has a specific set of characters in its name. So how can I do the equivalent of:
ALSO INCLUDE NodeCaption LIKE '%XXX%'