Does anyone happen to have a SQL query or API script to pull the Users and what sites and asset groups they have access to? I can’t imagine I am the only one needing this information for auditing purposes.
Thanks!
Does anyone happen to have a SQL query or API script to pull the Users and what sites and asset groups they have access to? I can’t imagine I am the only one needing this information for auditing purposes.
Thanks!
Hey @lora_fulton, I don’t see anything immediately in the reporting data model for SQL reports for this - perhaps I’m missing something - however, it is certainly possible to use the API.
There are a couple requests you would need to use:
Hopefully someone out in the community has a script already put together for this but at the very least these endpoints should get you heading in the right direction!