Showing posts from 2018

Operation Type for [MSCRM_CONFIG].[dbo].[ScaleGroupOrganizationMaintenanceJobs] - Dynamics CRM 2016 Asynchronous Service task (Maintenance)


Asynchronous Service regularly executes multiple internal maintenece jobs.

Maintenance related tasks are defined in [MSCRM_CONFIG].[dbo].[ScaleGroupOrganizationMaintenanceJobs].

You can retrieve some useful information for maintenance executions such as;
Last Execution Duration
Last Run Time
Next Run Time
Recurrence Detail for each jobs

But there is a mystery in "Operation Type" column. Here is the Code description that i find as much as i can;

Please send me new codes , i will add them to my post by adding big thank to you beside citation



"catalog full index for Organization"









publishing a package to Nuget.Server


I would like to describe how to publish an existing dll to Nuget.Server through Command Prompt.

Download NuGet.exe if you do not have (google it)Open Command Prompt with "Run As Administrator"We need to generate specification of the package so
nuget.exe spec (Microsoft.Crm.Sdk.Proxy)you will see .nuspec in the path (path can be where nuget.exe exists)pack it with specification
nuget pack " (Microsoft.Crm.Sdk.Proxy.nuspec)
Tip : there should have lib directory where .nuspec file exists. We should put our dll under the lib directorynuget package will be created under the same path of nuspec if we use default.You will see new directory.finally publish it as seen below;
nuget push (Microsoft.Crm.Sdk.Proxy.1.0.0.nupkg) -source http://localhost:9999/nuget -ApiKey
Please have a look at my previous article for ApiKey that's all, Good Luck!

Installation and Configuration guide of Nuget Server


If you want to create own Nuget Server, You should install Nuget.Serger package via Empty Web Site type of project in Visual Studio then publish it without typing any code.

Open Visual StudioFile > New > ProjectSelect "ASP.NET Web Application (.NET Framework)" under Web node.Give a Project Name, Location if default loc. does not satisfy you.
(you may select .NET Framework 4.6 instead of .Net framework 4.6.1, if exists. I faced an error while publishing Nuget.Server to local IIS. You may not see the issue in your try :) )Visual Studio is going to generate all necessary files for us (thanks :) ) Right Click to Project name from Solution ExplorerFind Manage NuGet Packagesonce you click it, you will see a form. Type Nuget.Server (Visual Studio must connect to Internet)Select "Nuget Server by .NET Foundation" You will see Install button in the right side (for Visual Studio 2017 - other version may have differences so my message is install it )You will get c…

export configuration of Internet Information Server


You can use following commands for export configuration, just open command prompt and type;

%windir%\system32\inetsrv\appcmd list apppool /config /xml > c:\apppools.xml
in order to export all Application pools under IIS to the apppools.xml in C drive

%windir%\system32\inetsrv\appcmd list site /config /xml > c:\sites.xml
in order to export all Application sites under IIS to the sites.xml in C drive

%windir%\system32\inetsrv\appcmd list config -section:system.webServer/rewrite/globalRules  /xml > c:\rewrite.xml
in order to export all global rules of IIS to the rewrite.xml in C drive.

good luck,

how to paste text with CR into one row

Sometimes you may suffer from copy from word (html table or any other text resource) and paste to the excel which results distribute single rows into consecutive sheet sequence.

Use Microsoft Word 2010 or never version in order to replace unprinted character like carriage return etc.

Here is the instruction;

copy all texts from sourcepaste to empty word documentclick ctrl+hreplace menu will be displayedclick "Find what:"find "Manual Line Break" through "Special" button bottom of the windowtype one space to the "Replace with:" click "Replace All"It is now ready to copy and paste to the excel.
good luck...

upgrade RHEL from 7.2 to 7.4 - offline


I would like to share my RHEL offline upgrade adventure  after realising that no internet connection in the server.

First of all, I was lucky to have RHEL 7.4 iso file which was compressed with .zip in the RHEL 7.2 server.

Logic is simple;

- unzip RHEL 7.4 file to reveal .iso
- mount it to the server
- configure YUM for upgrade
- upgrade server.

I could not be succeed at my first attempt due to "command not found" message while unpackaging archieve file ;


then I found unzip-6.0-1.el6.x86_64.rpm in internet and copied to server

after that I run following command in order to install unzip RPM

yum install unzip-6.0-1.el6.x86_64.rpm

System is now ready to execute;  unzip

I eventually handle ISO file.

It was good time to mount ISO file to start upgrade process:

1- make directory which will host ISO file as a new drive

mkdir /media/rhel74

2- mount iso file to the newly created directory

 mount -o loop rhe…