Microsoft Intune report

[Anonymous]

Hello,

I have been trying to create a Microsoft Intune report with following item.

deviceName, model, dispalyName, osVersion, lastsyncDateTime

However there are three issues to create the report.

1, osVersion is almost empty.

2, When select lastSynicDateTime, it shows 'visiual date is not available'

Is there other row to get data?

[v-xuding-msft]

Hi @Anonymous ,

I can't reproduce the issue. Can  you please share more details?

1. Did you connect data with OData feed?
2. How many tables are the columns from? And what the relationship among the tables?
3. Can you please post the expected output? Then we can try our best to help you solving it.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Xue,

Thank you for your support.

1, Yes, I have connected to OData.

2, Four tables

    - users(dispalyName)

    - policyDeviceActivites(filed,succeeded)

   - devicePropertyHistories(osVersion)

    -devices(osVersion,dispalyName)

3, Please see the attached picture.

Thank you,

Yuki Fukuda