Device/User Inventory

Question

Searching for a product or method to have an all encompassing Microsoft inventory for our user's and their devices with the information I have included under this question. We do use OKTA and AZURE if that helps. All devices are cloud-based and we have no on-prem SCCM.

User Information

First and Last Name
Department
Location
Job Title
Management Name

User's Device Information

Device ID
Device Name
OS version
Serial Number
Manufacturer

Answer 1

Cm can do this but you will need to write a custom report for this.

Answer 2

You may refer to reports in the Configuration Manager and you will find report which has such a data.
This is the list of reports:
https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/list-of-reports
As for the Intune, you have series of report, have a look at:
https://learn.microsoft.com/en-us/mem/intune/fundamentals/reports