MS Graph API: contains filters does not work on property serialNumber of deviceManagement/managedDevices

Question

MS Graph API: contains filters does not work on property serialNumber of deviceManagement/managedDevices

Gabriel Guillem Barceló Soteras 25

The following query fails on 1.0 and beta endpoints, it returns 200 OK with empty data if serial number is partial.

GET https://graph.microsoft.com/beta/deviceManagement/managedDevices?$filter=contains(serialNumber,'ABC')

If full serial number is provided, it returns a single device successfully (it behaves like eq operator).

Tried with other properties like deviceName and it works flawlessly: https://graph.microsoft.com/beta/deviceManagement/managedDevices?$filter=contains(deviceName,'a')

Renan Pedro 5 Reputation points

2025-01-21T02:05:17.6+00:00

I just spent hours trying to find out what I was doing wrong, until I noticed the same.

1 answer

Your answer

Renan Pedro 5 Reputation points

2025-01-21T02:05:17.6+00:00

I just spent hours trying to find out what I was doing wrong, until I noticed the same.

Answer 1

Crystal-MSFT 53,991 Microsoft External Staff

@Gabriel Guillem Barceló Soteras, Thanks for posting in Q&A. Based on my testing, I find it can work in my environment. I can get the device information with the serial number. Here is the screenshot for your reference

User's image

You can change to other serial number to see if it can query. Or open a new Graph Explorer to see if the result will be different.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Gabriel Guillem Barceló Soteras 25 Reputation points

2023-11-17T08:41:41.29+00:00

I worked with a full serial, but should it work with a partial serial number too, right?

If serial number is AAABBBCCC, then AAA should match. And that's what doesn't work...
Crystal-MSFT 53,991 Reputation points Microsoft External Staff

2023-11-20T05:33:28.5533333+00:00

@Gabriel Guillem Barceló Soteras, Thanks for the reply. Based on my researching and testing, I find contains not support partial value. It only supports full value. I think it can be the issue.
Gabriel Guillem Barceló Soteras 25 Reputation points

2023-11-20T07:13:33.81+00:00
Ok, but if contains does not support partial value, is it a bug then? It works for other properties like deviceName with partial values. We already have eq for full value match i.e.:

https://graph.microsoft.com/v1.0/deviceManagement/managedDevices?$select=id,deviceName,serialNumber&$filter=serialNumber eq 'AABBCCDD'
Crystal-MSFT 53,991 Reputation points Microsoft External Staff

2023-11-21T01:48:32.5833333+00:00

@Gabriel Guillem Barceló Soteras, Thanks for the reply. Not sure if this is a by design or bug. You can open premier case to confirm on this.

https://learn.microsoft.com/en-us/mem/get-support
Renan Pedro 5 Reputation points

2025-01-21T02:03:44.2066667+00:00

@Crystal-MSFT , Gabriel is correct.

"contains" should work for partial enters, like it does if you use it with "deviceName".
The issue seems to happen only for serialNumber.

I am surprise even after more than a year it is still like this.

Share via

MS Graph API: contains filters does not work on property serialNumber of deviceManagement/managedDevices

1 answer

Your answer