How to filter on DeviceManagement.WindowsAutopilotDeviceIdentities

[stephannn]

Hi,
i try to filter on the Serial Number:

var filter = $"contains(serialNumber, '{request.SerialNumber}')";
            _logger.LogInformation("SerialNumber filter value: {sn}", filter);
            var existingDevices = await _graphServiceClient.DeviceManagement.WindowsAutopilotDeviceIdentities
                .Request()
                .Filter(filter)
                .GetAsync();

but this just returns a bad request. I am afraid when I do:

var allDevices = await _graphServiceClient
                .DeviceManagement
                .WindowsAutopilotDeviceIdentities
                .Request()
                .GetAsync();

            var existingDevices = allDevices
                .FirstOrDefault(d =>
                    string.Equals(d.SerialNumber, request.SerialNumber,
                                StringComparison.OrdinalIgnoreCase));

it will fail when I start having thounds devices

[MartinM85]

Bad request usually means that the operator (contains) is not supported.
Have you tried to use eq?

var filter = $"serialNumber eq '{request.SerialNumber}'";
            _logger.LogInformation("SerialNumber filter value: {sn}", filter);
            var existingDevices = await _graphServiceClient.DeviceManagement.WindowsAutopilotDeviceIdentities
                .Request()
                .Filter(filter)
                .GetAsync();

[stephannn]

yes, and that is somehow the problem. The exception is:

Code: BadRequest
Message: {
  "_version": 3,
  "Message": "An error has occurred - Operation ID (for customer support): 00000000-0000-0000-0000-000000000000 - Activity ID: ce10ebd2-cfeb-42df-950b-bba33df4d547 - Url: https://proxy.msub04.manage.microsoft.com/DeviceEnrollmentFE/StatelessDeviceEnrollmentFEService/deviceManagement/windowsAutopilotDeviceIdentities?api-version=2024-03-21&$filter=serialNumber+eq+%SerialNumber%27&$top=1",
  "CustomApiErrorPhrase": "",
  "RetryAfter": null,
  "ErrorSourceService": "",
  "HttpHeaders": "{}"
}

Workaround:

var page = await graphServiceClient
                .DeviceManagement
                .WindowsAutopilotDeviceIdentities
                .Request()
                .Top(200)
                .GetAsync();

            while (page != null)
            {
                WindowsAutopilotDeviceIdentity? match;

                if (!string.IsNullOrEmpty(serialNumber))
                {
                    match = page.FirstOrDefault(d =>
                        string.Equals(d.SerialNumber, serialNumber, StringComparison.OrdinalIgnoreCase));
                }
                else
                {
                    match = page.FirstOrDefault(d =>
                        string.Equals(d.DisplayName, deviceName, StringComparison.OrdinalIgnoreCase));
                }

                if (match != null)
                {
                    return match;
                }

                if (page.NextPageRequest == null)
                {
                    break;
                }

                page = await page.NextPageRequest.GetAsync();
            }

[stephannn]

Using paging had another downsize. Timeout during the peek and slow. So I went for the web request:

string filterQuery = !string.IsNullOrEmpty(serialNumber) 
                ? $"contains(serialNumber,'{serialNumber}')" 
                : $"contains(displayName,'{deviceName}')";

var requestUrl = $"https://graph.microsoft.com/v1.0/deviceManagement/windowsAutopilotDeviceIdentities?$filter={filterQuery}&$select=id,serialNumber,displayName,managedDeviceId";
            
var httpRequest = new HttpRequestMessage(HttpMethod.Get, requestUrl);