You can find tools for this in the Microsoft Power Platform CoE starter kit, https://video2.skills-academy.com/en-us/power-platform/guidance/coe/starter-kit
If you install that in a dedicated environment then you can let Power Automate gather this information and store it in Dataverse. When the flows have collected all the information and saved it you can open the Power BI report to get this info.
This is the Power BI report you get with the CoE starter kit