SQL query to retrieve information on user devices based on user activity

Question

hello,

I require an SQL query to retrieve information about user devices based on user activity. This query should provide details on how many devices each user has logged into and used.

Answer 1

First have you looked at the built-in reports for this?

Keep in mind that ConfigMgr is not the right place for this. You really should be querying AD for this.