Users,Devices and Security Permissions - SM Energy - Requested by Nate Zeigler

From Nate,

Per our conversations with Nate Zeigler he would like us build a report that will have all Users, Devices and all security permissions per user and device? This is something Nate would like to see in the new Interface.

 Description below from Nate:

We would like a way to export all user permissions so that we can answer either of these questions…

Based on a user – what is every device a user has permissions on and what are those permissions
Based on a device – List all the users that have permissions on this device and what are those permissions

I believe the same export can answer both questions through filtering/pivoting, I understand that because of the relationship of devices to groups, groups to roles and roles to people and security that this export could be huge, especially in our environment where a device could be associated with 50 groups.

Please See Zendesk Ticket Number: 141000