Odata query to exclude devices with STRING in the name from results still returns those devices

Products

• Network Observability
• CA Performance Management

Issue/Introduction

I'm querying odata to populate some Grafana dashboards but the filtering to exclude device names is not working.

I want to exclude devices with *STRING* in the name

/odata/api/interfaces? doe$expand=portmfs,device&$select=ID,Name,device/Name,portmfs/Timestamp,portmfs/im_Utilization&resolution=RATE&starttime=${__from:date:seconds}&endtime=${__to:date:seconds}&$filter=((groups/Name eq 'Routers') and (device/Name ne '*STRING*'))  and ((portmfs/im_Utilization gt 10))&$top=10&top=1470&$orderby=Name asc&$format=text/csv

Environment

DX NetOps 25.4.x

Resolution

Change this section from

and (device/Name ne '*STRING*')

To

and not substringof('STRING', device/Name)

in this techdoc STRING is just a wildcard, your actual string would be more specific