SQL Queries against Workspace ONE DB

[cpridmore]

Hi everyone,

We would like to run a sql select statement against the Workspace ONE database to pull user numbers and device numbers.

Does anybody know what query you would need to run against the database to gather this information?

Thanks

[JosueNegron]

Are you an on-premises customer? If not you won't have access to the DB, but you can leverage the Workspace ONE APIs to easily pull this info. We also support webhooks to notify you of various actions like enrollment, unenrollment if you want to create some automation with APIs. Pretty good blog here on how to get started: https://blog.eucse.com/workspace-one-uem-api-list-all-devices/

[Samarjeet1]

give me exact requirement. i will provide the query

thnks,

samarjeet patil