Category Archives: Computer

How To Update Windows 10

Windows 10 periodically checks for updates so you don’t have to. When an update is available, it’s automatically downloaded and installed, keeping your device up to date with the latest features.

Check Manually For Windows 10 Updates

To check for updates manually, select the Start button, and then go to Settings > Update & security > Windows Update, and select Check for updates. If Windows Update says your device is up to date, you have all the updates that are currently available.





Duncan is a technology professional with over 20 years experience of working in various IT roles. He also has a wide range of other skills in radio, electronics and telecommunications.

SharePoint Server 2016 – KB4018381 – May 2018

This security update (KB4018381) resolves vulnerabilities in Microsoft Office that could allow remote code execution if a user opens a specially crafted Office file. To learn more about these vulnerabilities, see the following Microsoft security advisories:

Note To apply this security update, you must have the release version of Microsoft Office SharePoint Server 2016 installed on the computer.

This public update delivers Feature Pack 2 for SharePoint Server 2016, which contains the following feature:

  • SharePoint Framework (SPFx)

This public update also delivers all the features that were included in Feature Pack 1 for SharePoint Server 2016, including:

  • Administrative Actions Logging
  • MinRole enhancements
  • SharePoint Custom Tiles
  • Hybrid Auditing (preview)
  • Hybrid Taxonomy
  • OneDrive API for SharePoint on-premises
  • OneDrive for Business modern experience (available to Software Assurance customers)

The OneDrive for Business modern user experience requires an active Software Assurance contract at the time that the experience is enabled, either by installation of the public update or by manual enablement. If you don’t have an active Software Assurance contract at the time of enablement, you must turn off the OneDrive for Business modern user experience.

For more information, see New features included in the November 2016 Public Update for SharePoint Server 2016 (Feature Pack 1) and New features included in the September 2017 Public Update for SharePoint Server 2016 (Feature Pack 2).

Improvements and fixes


This security update contains improvements and fixes for the following nonsecurity issues in Project Server 2016:

  • If the proxy for the Project Service Application services already exists when you create a new Project Service application by using Install-SPService –Verbose command, an additional proxy for the service is created.
  • Consider the following scenario:
    • As a team member, you open your timesheet and enter work for two adjacent days.
    • On the first day, you set the actual work value back to zero.
    • On the first day, you set 8 hours of non-working time on an administrator task (for example, vacation)
    • You send a status update for approval.
    • You open the previous week timesheet.
    • You enter actual work values.
    • You send the timesheet for approval, and the status manager approves it.

    In this case, the actual work that was entered on the second of the two days moves to the first day. The actual work should not move when the status update is applied to the project.

  • When you publish a project in which the process updates the Summary Resource Assignment to a later date, the publish fails if the server is configured to use a date format other than MM-DD-YY.

This security update contains improvements and fixes for the following nonsecurity issues in SharePoint Server 2016:

  • When an item is deleted from the usage analytics caches, the item is now also deleted from the analytics reporting database.
  • If you don’t have sufficient permission to mount a content database to a farm by using the Mount-SPContentDatabase cmdlet, the cmdlet fails and the database is dropped unexpectedly.
  • This update introduces the “My Site creation default to OneDrive in Office 365” hybrid feature in SharePoint Server 2016. After you install this update and enable this feature, hybrid-enabled users can have their OneDrive personal sites provisioned in the cloud instead of on-premises. On-premise only users can still have their OneDrive personal sites provisioned on-premises.
  • You cannot use the SharePoint Term Store Management UI in browsers other than Internet Explorer.
  • The WebPart.ZoneID property is unavailable in the Web Part information.
  • SharePoint emails that are longer than 1,000 characters could become corrupted at the 1,000-character position. Depending on what content happens to be at that position, the corruption could be minor (corrupted text) or severe (broken HTML markup).
  • This update fixes the following three issues with the SharePoint Properties Panel:
    • When you save a SharePoint properties panel with required properties for the first time, you cannot find the properties.
    • The DateTime format is assumed to MM/DD/YY.
    • Drop-down of lookup type is set to nil when the label is selected.

How to get and install the update


Method 1: Microsoft Update

This update is available from Microsoft Update. When you turn on automatic updating, this update will be downloaded and installed automatically. For more information about how to get security updates automatically, see Windows Update: FAQ.

Method 2: Microsoft Update Catalog

To get the stand-alone package for this update, go to the Microsoft Update Catalog website.




Method 3: Microsoft Download Center

You can get the stand-alone update package through the Microsoft Download Center. Follow the installation instructions on the download page to install the update.

More Information


Security update deployment information

For deployment information about this update, see security update deployment information: May 8, 2018.

Security update replacement information

This security update replaces previously released security update KB 4018336.

File hash information

Package Name Package Hash SHA 1 Package Hash SHA 2
sts2016-kb4018381-fullfile-x64-glb.exe 4C67ED06F36496229DAE007DC51F4398EE40AE47 A85BC9DAB848D1923B179EF11595404189C0712F2BB9214C56B6F6AB3776978E

File information

For a list of the files that are included in this cumulative update (KB 4018381), download the file information.





Duncan is a technology professional with over 20 years experience of working in various IT roles. He also has a wide range of other skills in radio, electronics and telecommunications.

How To Fix Windows Update Error 0x80070057

How to fix Windows update error code 0x80070057. 

This problem may occur if one or more of the following conditions are true:

  1. The Windows Update database is corrupted.
  2. Antivirus software is configured to scan the %Windir%\SoftwareDistribution folder.
  3. The Background Intelligent Transfer Service (BITS) service does not receive a content link header.
  4. A required system file is registered incorrectly.

Try the below methods and check if it helps.

Method 1

If I am not wrong you had tried the below Windows Update troubleshooter to fix your problem and if this is not the same link then try to run the troubleshooter.

Open the Windows Update troubleshooter

http://windows.microsoft.com/en-in/windows7/open-the-windows-update-troubleshooter

Method 2

Step 1

If issue still persists I would suggest you to reset Windows Update components and for that try to run the fixit provided in the following article. If you had already tried the same fixit before I would request you to run the fixit again.

How do I reset Windows Update components?

http://support.microsoft.com/kb/971058/en-us#LetMeFixItMyselfAlways

Step 2

Try to follow the steps provided in the following Microsoft Article and check if it helps.

Troubleshoot problems with installing updates

http://windows.microsoft.com/en-us/windows/troubleshoot-problems-installing-updates#1TC=windows-7




Method 3

If after performing both steps issue persists try to follow the different steps provided in different methods of following Microsoft article.

Unable to install updates in Windows Vista, Windows 7, Windows Server 2008 and Windows Server 2008 R2

http://support.microsoft.com/kb/2509997

Registry disclaimerThis section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

You can use the following link in order to back up and restore the registry in Windows: http://support.microsoft.com/kb/322756/




Duncan is a technology professional with over 20 years experience of working in various IT roles. He also has a wide range of other skills in radio, electronics and telecommunications.

PowerShell – How To Count Members In A Group

So you have an Active Directory group and you need to count how many users are in that group, but there is to many to count one by one, here is a script to do it for you :-

$users = Get-ADGroupMember -Identity 'Group Name'
$users.count

This will then return the total number of users in the group.




Image result for windows powershell logo

Duncan is a technology professional with over 20 years experience of working in various IT roles. He also has a wide range of other skills in radio, electronics and telecommunications.

Microsoft SQL Server 2017 Updates

Here is the release history for Microsoft SQL Server 2017.

Update     Release Date        Build
CU5           2018/03/20           14.0.3023.8 N/A
CU4           2018/02/21           14.0.3022.28 N/A
CU3           2018/01/04           14.0.3015.40 N/A
CU2           2017/11/29           14.0.3008.27 N/A
CU1           2017/10/25           14.0.3006.16 N/A
RTM           2017/10/02           14.0.1000.169 N/A




Duncan is a technology professional with over 20 years experience of working in various IT roles. He also has a wide range of other skills in radio, electronics and telecommunications.

Error 0x80070bc2 When Installing KB4074588

Are you getting error 0x80070bc2 during the installation of Windows uypdate KB4074588 ?

Resolution :

  1. In the search box on the taskbar, type cmd.
  2. Right-click Command Prompt in the search results and select Run as administrator.  (Select Yes, when prompted by the User Account Control.)
  3. In the Administrator: Command Prompt window, type the following command and press Enter:

    SC config trustedinstaller start=auto

  4. Restart the PC.

In some cases, a second restart may be required. If you look under Settings > Update & Security and you see the message Status: Awaiting restart, restart the PC a second time to complete the installation.




Duncan is a technology professional with over 20 years experience of working in various IT roles. He also has a wide range of other skills in radio, electronics and telecommunications.

Remove The Password From Windows 10 Startup

When you create a user account, you can choose between two types of accounts either a local account for that PC or a Microsoft account, which works on all the Windows 10 PCs you use. Microsoft recommend using a Microsoft account.

If you don’t want to use password each time you log-in, you can use local user account. To create new local account follow the below steps:

  1. Press Windows + R key and type netplwiz and hit enter.
  2.  When you create a user account, you can choose between two types of accounts: a local account for that PC or a Microsoft account, which works on all the Windows 8.1 and Windows RT 8.1 PCs you use. We recommend using a Microsoft account..
  3. Click or tap on Add.
  4. Click or tap on Sign in without Microsoft account.
  5. Click on Local account and enter the details (don’t give any password).

  6. Click OK and sign out from the current account and sign into new created account.





Duncan is a technology professional with over 20 years experience of working in various IT roles. He also has a wide range of other skills in radio, electronics and telecommunications.

SharePoint 2010 – Usage Files Are Not Deleted And may Cause Timer Service Problems

The .usage logs are never deleted. There should typically be no more than 6 .usage files at any given time, but when you have this problem, you may find hundreds or thousands of usage logs in the logging directory.

You’ll see errors like this in the SharePoint ULS logs when the Usage Import timer job runs:

OWSTIMER.EXE (0x51A0) 0x59E4 SharePoint Foundation Usage Infrastructure a5rv High Failed to delete usage log file‘E:\Logs\ServerName-20130701-2117.usage’ after data import. Exception: System.IO.IOException: The process cannot access the file because it is being used by another process. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileInfo.MoveTo(String destFileName) at Microsoft.SharePoint.Administration.SPProvisioningAssistant.MoveFileOrDirectory(FileSystemInfo fi, String newPath) at Microsoft.SharePoint.Administration.SPProvisioningAssistant.DeleteFileOrDirectory(FileSystemInfo fi) at Microsoft.SharePoint.Administration.SPUsageLogImporter.ImportUsageLogFiles(List`1 usageLogFileList)

Other symptoms include:
• Missing or incomplete Web Analytics data
• The “Microsoft SharePoint Foundation Usage Data Import” timer job never completes.
• The “Timer Service Recycle” timer job is never able to actually restart the timer service. It tries to pause the Usage Data Import job and cannot, so after ten minutes it skips the recycle.
• Memory bloat (leak) within owstimer.exe. You may see the timer service consume much more memory than normal. Restarting the timer service will bring it back to normal, but it will build up again over time.
• The “Diagnostic Data Provider: Trace Log” timer job intermittently does not import the ULS log data into the Logging database.

Cause

This happens when Windows updates KB2775511 or KB2682011 or KB2882822 are applied to the SharePoint servers.

Resolution

The fix is in the December 2013 Cumulative Update for SharePoint 2010.  

If you look at the description for the Foundation package (which is included in the SharePoint server package) here: http://support.microsoft.com/kb/2849981, you will see this description for one of the issues that are fixed:

“After you install hotfix 2775511 or hotfix 2682011 on a SharePoint Server 2010 server, the Usage Provider (.usage) files are not deleted from the file system. Additionally, the .usage files keep growing.”

This is a somewhat generic summarization of the problem that does not include all the known symptoms, but it does fix the issues described in this KB.

Here is the link to the KB and download:
http://support.microsoft.com/kb/2849971




Duncan is a technology professional with over 20 years experience of working in various IT roles. He also has a wide range of other skills in radio, electronics and telecommunications.

What Is ccmsetup.exe

ccmsetup.exe is used by Microsoft System Centre Configuration Manager.

You might find this as a service running on a client computer.

It is usually found in a corporate environment where the client PC’s talk back to a Microsoft System Centre Configuration Manager server.





Duncan is a technology professional with over 20 years experience of working in various IT roles. He also has a wide range of other skills in radio, electronics and telecommunications.

Overview Of Sophos Email Appliance Version 4.2.2

The rollout of the Sophos Email Appliance version 4.2.2 has started, this marks first phase in the goal of a single anti-spam engine for all Sophos email solutions. Sophos Email Appliance version 4.2.2 incorporates the latest Sophos Anti-Spam engine as well as improvements to Sophos Delay Queue scanning to improve protection against snowshoe spam.

Full release notes available here

Remarks:

  • The release will be staged with the completion of all upgrades expected to take between 2-3 weeks
  • User experience and any custom settings will be unaffected by the change
  • Systems will not require a reboot following the appliance update
  • As well as improvements to Anti-Spam techniques, this release will also include a change to the Email Appliance update process (HTTPS as opposed to HTTP). To ensure the update functionality of the Sophos Email Appliance, please configure your network to allow access on the new ports highlighted below in red:
Port Function Service Protocol Connection
80, 443 Software downloads HTTP, HTTPS TCP [Required] Outbound from appliance to internet

If you are using a third party web proxy with HTTPS scanning enabled, please exempt the following Sophos URLs from HTTPS scanning. This will prevent any errors when updating the Sophos Email Appliance:

https://sea-dynamic.sophosupd.com
https://sea-dynamic.sophosupd.net
https://swa-dynamic.sophosupd.com
https://swa-dynamic.sophosupd.net

The official Sophos article is available here: https://community.sophos.com/kb/en-us/127433

Duncan is a technology professional with over 20 years experience of working in various IT roles. He also has a wide range of other skills in radio, electronics and telecommunications.

%d bloggers like this: