microsoft / Intune-PowerShell-SDK

Native PowerShell support for invoking Microsoft Intune Graph API to enable IT Pro scenario automation.
MIT License
314 stars 77 forks source link

ICCID not available #32

Open bilginbaldji opened 5 years ago

bilginbaldji commented 5 years ago

Querying ICCID data is not available via Get-IntuneManagedDevice for SIM card auditing.

Firstly let me say I know it is not a field reported in Graph Explorer or something that is configured to be queried against in Intune GUI. But since the data is there I do not see why we should not be able to access it (which kind of makes it more of a "wish" rather than an "issue").

Secondly, why is the ICCID important? The switch -phoneNumber for Get-IntuneManagedDevice is the closest in functionality but nowadays the providers do not program the MSIN in the SIM card due to the portability of the numbers and phone number assignment on activation rather than pre-assigning phone numbers (business customers). Modern phones also lack the capability to write to the SIM card, to configure own number. With the lack of reported phone number, the ICCID is the only other SIM card identifier available.

davefalkus commented 5 years ago

Hi @bilginbaldji,

Could you try the following and see if it works:

Update-MSGraphEnvironment -SchemaVersion beta -Quiet

Get-IntuneManagedDevice -managedDeviceId 5f6c1ed9-8848-4aee-b583-2791c4e3c870 | select deviceName,iccid

Dave

bilginbaldji commented 5 years ago

Hi Dave,

Sorry for the late reply. I've tested it but my devices do not return the ICCID value. The parameter is there if I use "| select *", but has no value against. I've made sure the Schema has been updated to the Beta. Please see below:

Get-IntuneManagedDevice -managedDeviceId 252d3e14-7f56-4c04-874b-c3f1247a3ad9 | select "@odata.context", devicename, iccid | fl

@odata.context : https://graph.microsoft.com/beta/$metadata#deviceManagement/managedDevices/$entity deviceName : bilgin.baldji_Android_3/4/2019_5:51 PM iccid :

Get-IntuneManagedDevice -managedDeviceId 043dafac-a3a0-49ef-a411-e3439084577c | select "@odata.context", devicename, iccid | fl

@odata.context : https://graph.microsoft.com/beta/$metadata#deviceManagement/managedDevices/$entity deviceName : Bilgin’s iPad iccid :

Thanks for looking into it. Kind regards, Bilgin

jimmyeao commented 5 years ago

We too are struggling with this. Its a big blocker to a wider adoption (2000+ devices) of the platform if we cant report on ICCID

jlawatts commented 5 years ago

Can I please add to this. We are also in the early stages of trialling Intune, with a view to migrating our 8000+ devices from Airwatch. ICCID is essential for us to be able to track items within our CMDB and rationalise data with our carrier.

chrisvaile commented 5 years ago

+1 on this. This is preventing critical data from being imported into our CMDB. We had a previous workaround by requesting the value from each individual resource (devicemanagement/managedDevices/{id}/?$select=iccid) However, this no longer works.

nowiresmatt commented 5 years ago

So this is available through the graph API but there are issues... so specific device query works: https://graph.microsoft.com/beta/devicemanagement/manageddevices/{deviceid}/?select=devicename,iccid and you get.... { "@odata.context": "https://graph.microsoft.com/beta/$metadata#deviceManagement/managedDevices(deviceName,iccid)/$entity", "deviceName": "devicename", "iccid": "89xxxxxx56" }

however a general query across all devices returns iccid as all null: { "@odata.context": "https://graph.microsoft.com/beta/$metadata#deviceManagement/managedDevices(deviceName,iccid)", "@odata.count": 42, "value": [ { "deviceName": "devicename", "iccid": null },

Also using Microsoft.Graph.Intune module also returns null.

Get-IntuneManagedDevice -managedDeviceId "deviceid" | select deviceName,iccid

deviceName iccid


devicename

The info is there and accessible through the beta GraphAPI via a specific device query but is not returned for any wider device query or via the module.

It would be great if this could be included in the standard device export fields.

vincentvillerius commented 4 years ago

iccid is available in intune data warehouse.

jimmyeao commented 4 years ago

iccid is available in intune data warehouse.

Where exactly? Im not seeing ICCID under devices?

vincentvillerius commented 4 years ago

When i load the devices table in PowerBI its there. image

jimmyeao commented 4 years ago

Sadly not in my tenant :(

Jimmy White


From: vincentvillerius notifications@github.com Sent: Tuesday, November 12, 2019 9:08:00 PM To: microsoft/Intune-PowerShell-SDK Intune-PowerShell-SDK@noreply.github.com Cc: Jimmy White jimmy@deviousweb.com; Comment comment@noreply.github.com Subject: Re: [microsoft/Intune-PowerShell-SDK] ICCID not available (#32)

When i load the devices table in PowerBI its there. [image]https://user-images.githubusercontent.com/57673271/68710942-dbdbbb80-0598-11ea-8334-476d07162d29.png

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/microsoft/Intune-PowerShell-SDK/issues/32?email_source=notifications&email_token=ABHVAB7ZHEITEV473SPWRUDQTMLLBA5CNFSM4G447KFKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOED352DA#issuecomment-553114892, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ABHVAB4I25CGRQFCBNTCGVTQTMLLBANCNFSM4G447KFA.

jimmyeao commented 4 years ago

this was working in the beta datawarehouse, but has since stopped being populated. this is CRITICAL to many organisations, I wish a little more attention was given to this. We may move our several thousand devices back to another MDM if this isnt resolved soon

jbh999 commented 1 year ago

Is there any plan to fix the API that lists all devices (https://graph.microsoft.us/beta/deviceManagement/managedDevices?$select=deviceName,iccid) ?

vargabp commented 3 months ago

Struggling with this too. Failing to understand why they don't support this for Fully Managed Android devices. If you don't have access to all the things on the device, it's not really fully managed, is it? Would be nice for this to get some traction.