Dynamics Community Forum Thread Details

You can refer below code to export the security privileges for the provided security role.

using System;
using System.Linq;
using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Query;
using Microsoft.Xrm.Sdk.Client;
using Microsoft.Crm.Sdk.Messages;
using System.Configuration;
using CrmEarlyBound;
using Microsoft.Xrm.Tooling.Connector;
using System.IO;
using System.Data;

namespace RetreieveRoles
{
    public class Roles
    {
        #region How To Sample Code
        /// <summary>
        /// gets the organisation roles and stores it into DataTable
        /// </summary>
        public void GetOrgRoles() //ServerConnection.Configuration serverConfig, bool promptforDelete
        {
            try
            {
                #region CRMConnection
                //connecting to CRm environment
                CrmServiceClient service = new CrmServiceClient(ConfigurationManager.ConnectionStrings["XrmName"].ConnectionString);
                OrganizationServiceContext context = new OrganizationServiceContext(service);
                #endregion

                DataTable dtrecords = new DataTable();
                //getting roles entity
                QueryExpression query = new QueryExpression
                {
                    EntityName = "role"
                };

                Guid roleId = new Guid();
                //secuirty id to get privileges for
                string securityId = "E0796DC8-C897-E511-80D9-D89D676440FC";
                roleId = new Guid(securityId);

                //Get all Security Roles
                EntityCollection Securityroles = service.RetrieveMultiple(query);

                //Get all Privileges
                RetrievePrivilegeSetRequest requestp = new RetrievePrivilegeSetRequest();
                RetrievePrivilegeSetResponse responsep = (RetrievePrivilegeSetResponse)service.Execute(requestp);

                //Get record from RolePrivilege Mapping
                RetrieveRolePrivilegesRoleRequest req = new RetrieveRolePrivilegesRoleRequest();
                req.RoleId = roleId;
                RetrieveRolePrivilegesRoleResponse response = (RetrieveRolePrivilegesRoleResponse)service.Execute(req);

                //writing into Datatable
                //Column Name to be added into dataTable
                string colName = "privilege Name";
                if (!dtrecords.Columns.Contains(colName))
                {
                    dtrecords.Columns.Add(colName);
                }
                foreach (RolePrivilege priv in response.RolePrivileges)
                {
                    //Add columns to datatable                    
                    var privile = responsep.EntityCollection.Entities.Where(a => a.Id == priv.PrivilegeId).ToArray();
                    try
                    {
                        foreach (Entity ent in privile)
                        {
                            //getting the privileges name only
                            Privilege privilege = ent.ToEntity<Privilege>();
                            dtrecords.Rows.Add(privilege.Name.ToString());
                        }
                    }
                    catch (Exception ex)
                    {
                        throw ex;
                    }
                }
                string strFilePath = ConfigurationManager.AppSettings["PathToStoreCSV"];
                //converting to csv
                CreateCSVFile(dtrecords, strFilePath);
            }
            // Catch any service fault exceptions that Microsoft Dynamics CRM throws.
            catch (Exception ex)
            {
                // You can handle an exception here or pass it back to the calling method.
                throw ex;
            }
        }

        #endregion How To Sample Code


        #region Datatable To CSV File
        /// <summary>
        /// function to convert datatable to CSV
        /// </summary>
        /// <param name="dt"> Datatable to convert into csv</param>
        /// <param name="strFilePath"> file path where csv would be saved mentioned in apconfig file</param>
        public void CreateCSVFile(DataTable dt, string strFilePath)
        {
            #region Export Grid to CSV
            // Create the CSV file to which grid data will be exported.
            StreamWriter sw = new StreamWriter(strFilePath, false);
            // First we will write the headers.
            //DataTable dt = m_dsProducts.Tables[0];
            int iColCount = dt.Columns.Count;

            for (int i = 0; i < iColCount; i++)
            {
                sw.Write(dt.Columns[i]);
                if (i < iColCount - 1)
                {
                    sw.Write(",");
                }
            }
            sw.Write(sw.NewLine);
            // Now write all the rows.
            foreach (DataRow dr in dt.Rows)
            {
                for (int i = 0; i < iColCount; i++)
                {
                    if (!Convert.IsDBNull(dr[i]))
                    {
                        sw.Write(dr[i].ToString());
                    }
                    if (i < iColCount - 1)
                    {
                        sw.Write(",");
                    }
                }
                sw.Write(sw.NewLine);
            }
            sw.Close();
            #endregion

        }
        #endregion
    }
}

Thanks!

Community site session details

Retrieve Role Privileges and export into XL Sheet

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

Retrieve Role Privileges and export into XL Sheet

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates