How to merge worksheets / workbooks into one worksheet?

1. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window. 2. Click Insert > Module, and paste the following code in the Module Window. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).Select Worksheets.Add Sheets(1).Name = "Combined" Sheets(2).Activate Range("A1").EntireRow.Select Selection.Copy Destination:=Sheets(1).Range("A1") For...

Read More

Share LUN giữa các host

Từ bước 1 -> 5 các bước này thực hiện trên tất cả các host 1. Cài đặt yum install pcs pacemaker fence-agents-all -y2. allow firewall# firewall-cmd --permanent --add-service=high-availability# firewall-cmd --add-service=high-availability3. Đặt passwork cho user hacluster# passwd hacluster4. Start pcsd# systemctl start pcsd.service# systemctl enable pcsd.service5. Add authentication trên mỗi hosts[root@ubqlvnn-app01-48 ...

Read More

Using Powershell list of websites IIS using get-website

C:\Users\Administrator>powershell -ExecutionPolicy BypassWindows PowerShellCopyright (C) 2012 Microsoft Corporation. All rights reserved.PS C:\Users\Administrator> import-module WebAdministrationPS C:\Users\Administrator> get-website | select name,id,state,physicalpath, @{n="Bindings"; e= { ($_.bindings | select -expa collection) -join ';' }} ,@{n="LogFile";e={ $_.logfile | select -expa directory}}, @{n="attributes";...

Read More

How To Reset Root Password CentOS 7

1 – In the boot grub menu select option to edit. 2 – Select Option to edit (e). 3 – Go to the line of Linux 16 and change ro with rw init=/sysroot/bin/sh. 4 – Now press Control+x to start on single user mode. 5 – Now access the system with this command. chroot /sysroot 6 – Reset the password. passwd root 7 – Update selinux...

Read More