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!

Retrieve Role Privileges and export into XL Sheet

Helpful resources

News and Announcements

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Community AMA December 12th

Leaderboard

Featured topics

Product updates

Retrieve Role Privileges and export into XL Sheet

Helpful resources

News and Announcements

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Community AMA December 12th

Subscribe to

Leaderboard

Featured topics

Product updates