Dynamics Community Forum Thread Details

Hi Krishna,

1) Create one console application.

2) Download SDK and take dll reference

3) Add following dll reference

Microsoft.Xrm.Sdk;
Microsoft.Xrm.Sdk.Client;

Add System.Configuration; from .NET assembly

3 )Copy the the code in your class file

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.ServiceModel.Description;
using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Client;
using Microsoft.Xrm.Sdk.Query;

namespace CRMConnectionTestProject
{
    class UpdateTitleFiedOldCase
    {
        static void Main(string[] args)
        {
            OrganizationServiceProxy service = GetCRMService();
            //Write your logic here 
            string FetchXML = @"<fetch version='1.0' output-format='xml - platform' mapping='logical' distinct='false'>" +
                                "<entity name = 'incident'>" +
                                   "<attribute name = 'title'  />" +
                                    "<attribute name = 'incidentid'  />" +
                                    "<order attribute = 'title' descending = 'false' />" +
                                    "<filter type = 'and' >" +
                                    "<condition attribute = 'createdon' operator= 'olderthan-x-years' value='{0}'  />" +
                                  "</filter>" +
                                "</entity>" +
                        "</fetch>";

            FetchXML = string.Format(FetchXML, "1");
            EntityCollection data = null;
            data = service.RetrieveMultiple(new FetchExpression(FetchXML));

            foreach (Entity ent in data.Entities)
            {
                ent.Attributes["title"] = "Updated Title";
                service.Update(ent);
            }
            //----
        }




        public static OrganizationServiceProxy GetCRMService()
        {

            String _organizationUniqueName = ConfigurationManager.AppSettings["OrganizationName"];
            String _userName = ConfigurationManager.AppSettings["Username"];
            String _password = ConfigurationManager.AppSettings["Password"];
            String _organizationUri = ConfigurationManager.AppSettings["OrganizationUri"];
            Guid _userId = new Guid(ConfigurationManager.AppSettings["UserId"]);
            String _domain = ConfigurationManager.AppSettings["Domain"];


            OrganizationServiceProxy serviceProxy = null;
            try
            {

                string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MSCRM_Connection"].ConnectionString;
                if (!string.IsNullOrEmpty(connectionString))
                {


                    Dictionary<string, string> settingsKeyValues = new Dictionary<string, string>();
                    var list = connectionString.Split(';').Select(keyValue => keyValue.Split('=')).ToList();

                    foreach (var item in list)
                    {
                        if (item.Length > 1)
                            settingsKeyValues.Add(item[0].Trim(), item[1].Trim());

                    }


                    string configserverurl = _organizationUri;
                    string userId = _userName;
                    string passWord = _password;
                    string domain = _domain;
                    if (!String.IsNullOrEmpty(configserverurl) && !String.IsNullOrEmpty(userId) &&
                        !String.IsNullOrEmpty(passWord) && !String.IsNullOrEmpty(domain))
                    {
                        Uri uri = new Uri(configserverurl);
                        IServiceConfiguration<IOrganizationService> config = ServiceConfigurationFactory.CreateConfiguration<IOrganizationService>(uri);
                        if (config.AuthenticationType == AuthenticationProviderType.Federation)
                        {
                            ClientCredentials clientCredential = new ClientCredentials();
                            clientCredential.UserName.UserName = userId;
                            clientCredential.UserName.Password = passWord;
                            serviceProxy = new OrganizationServiceProxy(config, clientCredential);
                        }
                        else
                        {
                            ClientCredentials clientCredential = new ClientCredentials();
                            clientCredential.Windows.ClientCredential = new System.Net.NetworkCredential() { Domain = domain, Password = passWord, UserName = userId };
                            serviceProxy = new OrganizationServiceProxy(uri, null, clientCredential, null);

                        }

                    }
                }
            }
            catch (Exception Ex)
            {
                throw Ex;
            }

            return serviceProxy;
        }
    }
}

4 ) Copy App.Config and replace the CRM connection details , replace all the related and userid GUID with system user.

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
	<appSettings>
		<add key="aspnet:UseTaskFriendlySynchronizationContext" value="true" />	
		<add key="OrganizationName" value="DEV" />
		<add key="OrganizationUri" value="184.47.86.75/.../Organization.svc" />
		<add key="Username" value="ServiceUser" />
		<add key="Password" value="XXXXXXX" />
		<add key="Domain" value="domainname" />
		<add key="UserId" value="64675A4F-5983-E611-80E3-0050560111FF" /> <!--UserID of systemuser-->
	</appSettings>
	<connectionStrings>
		<!--On-premises with provided user credentials-->
		<add name="MSCRM_Connection" connectionString="Url=http://164.48.86.15/DEV; Username=domain/username; Password=*******" />
	</connectionStrings>
  <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2" />
    </startup>
</configuration>

5) Build your console you will get the application exe.

6)Scheduled it in windows task scheduler

http://www.thewindowsclub.com/how-to-schedule-batch-file-run-automatically-windows-7

Hope this helps.

Community site session details

Create batch job for on premise 2016

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