how to use Notepad++ to MASk the IC number at Log file

Under Search mode select : Regular expression

under replace tab : S+[0-9]+[0-9]+[0-9]+[0-9]+[0-9]+[0-9]+[0-9]+[A-Z]

above search is for singapore ic format which is :  S1234567A

How to track the progress of SharePoint CU installation ?

 windows > Run > %temp%

inside this temp folder will see the windows installer log file which is referring to the SharePoint CU patching .

can use it to compare with other SharePoint server already completed install , then you will know how soon the installation will complete

Change DocAve Agent service Account Password

After change the service account at AD , we need to change on DocAve manger platform only can continue to use it.

Change at DocAve Manager Server

1. Log in to the server hosting DocAve Manager

2. Open the Manager Configuration Tool

3. Key in the new password at section:

• Control Service Configuration
• Control Database Settings
• Report Database Settings
• Auditor Database Settings

4. Click Apply to save the settings

if the DocAve windows services is running on the Service account , we also need to reenter the password and restart the service for docave 6 Media service , Report Service , Timer Service.

Re-type the new password at DocAve Manager Manage Account Profile

1.      Login to the DocAve Manger, control panel > Managed Account Profile and check on the service account

2.      After selected the account click on Edit and retype the new password and click Save

3.      Password change is complete and just close the control panel.

How to read the SharePoint Security Audit Report

User request to check who's remove the permission !!!   As a SharePoint Admin we can get the information from the audit report ( anyway need to enable it before else will not have data available)

Site Settings > Audit log Reports : Select the Security settings

Once you get the report , we can get the information from the report .

Information below from the column good enough to find out who change the permission


User ID : Person done the change

Event Data : what permission is change (but is in number , so the number is represent the role showed as following )


Full Control 1073741829
Contribute 1073741827
Read 1073741826


This id is given by SharePoint , you can get it by do some programming or script.

1. Go to the sites with /_layouts/15/people.aspx?MembershipGroupId=0
2. You will see all the user over here, mouse over the id then you can see the left hand side bottom have the full URL detail showed . you can see the id here.

This information is showed what change is going on

SharePoint Performance : After SQL upgrade

Issues : Performance problems

Root Cause :  SQL compatibility level  of 130 or 140 which caused decreased query performance and increased CPU usage on the database server.

Resolution : Changing the compatibility level to 110 resolved the performance problems

How to fix :

We strongly recommend that you set the database compatibility level to 110 for SharePoint Server 2016 content databases. To change the compatibility level, run the following TSQL command:

ALTER DATABASE database_name SET COMPATIBILITY_LEVEL = 110

You can view the compatibility level of all the databases in an instance of SQL Server by using the following TSQL query:

SELECT name, compatibility_level FROM sys.databases

 Detail URL :
https://blogs.technet.microsoft.com/stefan_gossner/2018/12/02/sp2016-performance-problems-caused-by-sql-database-compatibility-level-130-or-140/


This also applied to SharePoint2013 ( when you upgrade to SQL server and new content database version will created under compatibility level 120 )