Mapping Certificate to an IP address and a Port

This blog shows you how to use Netsh tool to create mapping between address and a port to the certificate in the machine. For example, map localhost certificate to IP Address 0.0.0.0 Port 8888.

1. Use the instructions here to create MMC snap in to show certificates.

2. Open MMC (windows key > type MMC > Open myCertificates file your created earlier > under Console Root > Certificates (Local Computer) > Personal > Certificates > double click localhost > select Details tab > select Thumbprint > copy and paste it in a notepad you will need this later.

3. Right click ConsoleHost, select Properties, Click on Assembly information... button > Copy GUID > paste it in the notepad

4. Open Command prompt as administrator (Windows key > type cmd > right click on Command Prompt > Run as Administrator)

5. Type netsh http add sslcert ipport=0.0.0.0:8888 certhash=<type the thumbprint you copied from the cert here> appid={<copy the GUID you copied from the assembly information here>}

Comments

Excel PMT Function

PMT function is very useful for calculating monthly payment required to payback a loan or mortgage at a fixed rate. This function require a minimum of three inputs, periodic rate, number of periods, present value or the loan amount. Here is a simple example. Home Loan: 350,000.00 Interest rate: 4.5% Number of years to repay the loan: 25 Note: To calculate monthly payment, we need to find the monthly rate and number of months as shown above. Then it is simply a matter of substituting the values into the payment function, as shown in the formula view below.

CUMIPMT and CUMPRINC function

CUMIPMT Cumulative interest payment function allows you to calculate the interest paid for a loan or from an investment from period A to period B. When getting a loan, CUMIPMT function can be used to calculate the total amount of interest paid in the first five months or from period 12 to period 20. A period can be a month, a week or two week. Loan Amount : 350,000.00 APR: 4.5% Down payment: 0.00 Years: 25 Payment per year: 12 From the above data, we can calculate the following: No of Period: 25 × 12 = 300 Periodic Rate: 4.5/12 = 0.375% Here is how you will substitute these values into the function. = CUMIPMT (periodic rate, No of period, vehicle price, start period, end period, ) = CUMIPMT (0.375, 300, 350000, 1, 5, 0) In an excel worksheet, we use cell address instead of actual values as shown below: Here is the formula view of the worksheet: CUMPRINC Another related function is CUMPRINC. CUMPRINC function is used to calculate cumul

A Comprehensive Evaluation of the Internal Consulting Process: Steps and Considerations

Introduction Internal consulting has emerged as a critical function within organizations, offering in-house expertise to solve complex business problems and drive change. It closely mirrors external consulting in methodology but is differentiated by the consultant's intimate knowledge of the organization and a vested interest in its long-term success. This article aims to evaluate the key steps involved in the internal consulting process, offering insights into each phase's significance and challenges. Steps in the Internal Consulting Process The internal consulting process can generally be segmented into five distinct stages: Initial Assessment, Data Collection and Analysis, Solution Development, Implementation, and Evaluation. Below is an evaluation of each step: Step 1: Initial Assessment Objective: To understand the problem or opportunity area and define the scope of the project. Significance: A well-defined scope ensures that the consulting project stays focused and manage

EduSarva

Search This Blog