Tech Community Live: Endpoint Manager edition
Jul 21 2022, 08:00 AM - 12:00 PM (PDT)

what Intune Data Warehouse (IDW) table provides the device WiFi IP address?

%3CLINGO-SUB%20id%3D%22lingo-sub-2705294%22%20slang%3D%22en-US%22%3Ewhat%20Intune%20Data%20Warehouse%20(IDW)%20table%20provides%20the%20device%20WiFi%20IP%20address%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2705294%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20Power%20BI%20to%20retrieve%20device%20information%20from%20the%20Intune%20Data%20Warehouse%20(IDW).%20The%20%22devices%22%20table%20provides%20useful%20information%2C%20such%20as%20the%20WiFi%20MAC%20address%2C%20and%20last%20time%20synced%2C%20but%20it%20does%20not%20provide%20the%20WiFi%20IP%20address%20it%20connected%20with.%20This%20is%20a%20screenshot%20of%20the%20IDW%20Device%20table%20fields.%20If%20not%20in%20this%20table%2C%20which%20table%20then%20would%20provide%20the%20WiFi%20IP%20address%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mobilismexico_0-1630460390461.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F307139iA8B2B232C3F1B574%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mobilismexico_0-1630460390461.png%22%20alt%3D%22mobilismexico_0-1630460390461.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20in%20advance%20for%20your%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlejandro%20C.%3C%2FP%3E%3CP%3EMexico%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2705294%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EIntune%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi,

 

I'm using Power BI to retrieve device information from the Intune Data Warehouse (IDW). The "devices" table provides useful information, such as the WiFi MAC address, and last time synced, but it does not provide the WiFi IP address it connected with. This is a screenshot of the IDW Device table fields. If not in this table, which table then would provide the WiFi IP address?

 

mobilismexico_0-1630460390461.png

 

thanks in advance for your help!

 

Alejandro C.

Mexico

0 Replies