Here are a few reasons a customer may need this Sedona-X information.
- If a customer’s technician is not getting the functionality on their Sedona -X, they can verify what permissions their technician is assigned in a summarized document instead of scrolling down many screenshots of permissions.
- If a customer wants to create a new role group, they can verify permissions settings using the script in his KB.
- Ease of use for role/permissions viewing.
SELECT HostCompany.Companyname, ASPNetGroup.GroupId, ASPNetGroup.GroupName, AspNetRoleGroup.RoleGroupId,
AspNetRoleGroup.GroupId AS Group_ID, AspNetRoleGroup.RoleId, AspNetRoles.Name,
AspNetRoles.Description FROM AspNetRoles
INNER JOIN AspNetRoleGroup ON AspNetRoles.Id = AspNetRoleGroup.RoleId
INNER JOIN ASPNetGroup ON AspNetRoleGroup.GroupId = ASPNetGroup.GroupId
INNER JOIN HostCompany ON ASPNetGroup.BaseCompanyId = HostCompany.Id
WHERE (ASPNetGroup.BaseCompanyId IS NOT NULL)ORDER BY ASPNetGroup.GroupName
Sample date from this query can be found here.
