Category Archives: Computer

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

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




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.




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.





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




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.





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

Windows 10 Update KB4041676 [10th October 2017]

This update applies to Windows 10 Version 1703

October 10, 2017—KB4041676 (OS Build 15063.674)

This update should apply via Windows Update – If it does not, or you need to install this manually here is the direct download link.

Improvements and fixes

This update includes quality improvements. No new operating system features are being introduced in this update. Key changes include:

  • Addressed issue where some UWP and Centennial apps show a gray icon and display the error message “This app can’t open” on launch.
  • Addressed reliability issue that causes the AppReadiness service to stop working.
  • Addressed issue where applications that use the Silverlight map stack stop working.
  • Addressed issue where VSync prevents devices from entering Panel Self Refresh mode, which can lead to reduced battery life.
  • Addressed issue where user customizations (like pinned tiles) made to an enforced partial Start layout are lost when upgrading to Windows 10 1703.
  • Addressed issue where the Universal CRT caused the linker (link.exe) to stop working for large projects.
  • Addressed issue that prevents Windows Error Reporting from saving error reports in a temporary folder that is recreated with incorrect permissions. Instead, the temporary folder is inadvertently deleted.
  • Addressed issue where the MSMQ performance counter (MSMQ Queue) may not populate queue instances when the server hosts a clustered MSMQ role.
  • Addressed issue with the token broker where it was leaking a token that caused sessions to remain allocated after logoff.
  • Addressed issue where Personal Identity Verification (PIV) smart card PINs are not cached on a per-application basis. This caused users to see the PIN prompt multiple times in a short time period; normally, the PIN prompt only displays once.
  • Addressed issue where using the Cipher.exe /u tool to update Data Recovery Agent (DRA) encryption keys fails unless user certification encryption already exists on the machine.
  • Addressed issue where using AppLocker to block a Modern app fails. This issue occurs only with Modern apps that come pre-installed with Windows.
  • Addressed issue with form submissions in Internet Explorer.
  • Addressed issue with the rendering of a graphics element in Internet Explorer.
  • Addressed issue that prevents an element from receiving focus in Internet Explorer.
  • Addressed issue with the docking and undocking of Internet Explorer windows.
  • Addressed issue caused by a pop-up window in Internet Explorer.
  • Addressed issue where a Vendor API deleted data unexpectedly.
  • Addressed issue where using the Robocopy utility to copy a SharePoint document library, which is mounted as a drive letter, fails to copy files. However, in this scenario, Robocopy will copy folders successfully.
  • Addressed issue where MDM USB restrictions did not disable the USB port as expected.
  • Addressed issue where creating an iSCSI session on a new OS installation may result in the “Initiator instance does not exist” error when attempting to connect to a target.
  • Addressed issue where connecting to RDS applications published using Azure App Proxy fails. The error message is, “Your computer can’t connect to the Remote Desktop Gateway server. Contact your network administrator for assistance”. The error can occur when the RDP cookie size limit is exceeded. This update increased the size of the RDP cookie limit.
  • Addressed issue where USBHUB.SYS randomly causes memory corruption that results in random system crashes that are extremely difficult to diagnose.
  • Addressed issue that affects the download of some games from the Windows Store during the pre-order phase. Download fails with the error code 0x80070005, and the device attempts to restart the download from the beginning.
  • Addressed issue where the ServerSecurityDescriptor registry value does not migrate when you upgrade to Windows 10 1703. As a result, users might not be able to add a printer using the Citrix Print Manager service. Additionally, they might not be able to print to a client redirected printer, a Citrix universal print driver, or a network printer driver using the Citrix universal print driver.
  • Security updates to Microsoft Windows Search Component, Windows kernel-mode drivers, Microsoft Graphics Component, Internet Explorer, Windows kernel, Microsoft Edge, Windows Authentication, Windows TPM, Device Guard, Windows Wireless Networking, Windows Storage and Filesystems, Microsoft Windows DNS, Microsoft Scripting Engine, Windows Server, Windows Subsystem for Linux, Microsoft JET Database Engine, and the Windows SMB Server.

If you installed earlier updates, only the new fixes contained in this package will be downloaded and installed on your device.

For more information about the resolved security vulnerabilities, please refer to the Security Update Guide.




Known issues in this update

Symptom
Installing KB4034674 may change Czech and Arabic languages to English for Microsoft Edge and other applications.
Workaround
Microsoft is working on a resolution and will provide an update in an upcoming release.
Symptom
Systems with support enabled for USB Type-C Connector System Software Interface (UCSI) may experience a blue screen or stop responding with a black screen when a system shutdown is initiated.

Workaround

If available, disable UCSI in the computer system’s BIOS. This will also disable UCSI features in the Windows operating system.

Microsoft is working on a resolution and will provide an update in an upcoming release.

Symptom

Microsoft is aware of a publishing issue with the October 10th, 2017 monthly security update for Windows 10 version 1703 (KB4041676) for WSUS\SCCM managed devices where Windows devices may fail to boot after installing this update

Workaround

Customers that download updates directly from Windows Update (Home and consumer devices) or Windows Update for Business are not impacted.

We have corrected this publishing issue. For users who encountered issues please refer to the following article:

Windows devices may fail to boot after installing October 10 version of KB 4041676 or 4041691 that contained a publishing issue

The cumulative security updates have been validated. We recommend all customers take these cumulative security updates.




How To Fix Windows Update Error 0x80200056

You may get 0x80200056 error during Windows update.  This is a common upgrade error on Windows.

Suggested Fix

Method 1:

Close down the computer and re-try the updates again.

Method 2:

Run the System File Checker(SFC) scan, then re try the updates again.

The System File Checker tool (SFC.exe) scans for missing or corrupted system files and repairs them.

Use the System File Checker tool to repair missing or corrupted system files

http://support.microsoft.com/kb/929833/en-us

Method 3:

Try manually reset the Windows Updates Components and check the issue status, the try again:

a) Press Windows Key + X on the keyboard and then select “Command Prompt (Admin)” from the menu.

b) Stop the BITS, Cryptographic, MSI Installer and the Windows Update Services. To do this, type the following commands at a command prompt. Press the “ENTER” key after you type each command.

net stop wuauserv

net stop cryptSvc

net stop bits

net stop msiserver

c) Now rename the SoftwareDistribution and Catroot2 folder. You can do this by typing the following commands in the Command Prompt. Press the “ENTER” key after you type each command.

ren C:\Windows\SoftwareDistribution SoftwareDistribution.old

ren C:\Windows\System32\catroot2 Catroot2.old

d) Now, let’s restart the BITS, Cryptographic, MSI Installer and the Windows Update Services. Type the following commands in the Command Prompt for this. Press the ENTER key after you type each command.

net start wuauserv

net start cryptSvc

net start bits

net start msiserver

e) Type Exit in the Command Prompt to close it.

Error 0x80200056



What Is s0.2mdn.net Does This Site Host Malware ?

The domain 2mdn.net and s0.2mdn.net are owned and used by Google.  It is used for Google Ads – Lookup of domain owner here 

When you do a Google search for this domain a lot of stuff that shows up that seems to relate to malware (see image below) With topics like “How to delete S0.2mdn.net pop-up completely from your system” and “How to delete S0.2mdn.net pop-up completely from your system” and “s0.2mdn.net Removal Technique” and “How to Remove s0.2mdn.net (Chrome/Edge/Firefox)” the list goes on…

The above examples take you to websites that want you to download (fake) software that will remove this, or ask you to run a tool to scan your PC for this, and any other random stuff you search for, they seem to have a fix for it !  Do not visit such sites or click any links on them, they will probably infect your PC with malware or a virus.

This site is NOT malware, it is just used to show adverts.  It is highly unlikely that you have been infected by malware from a Google Adsense advert.

You may also find lots of reference to this in your proxy server or firewall logs.  This is because most website host Google Ads and therefore there is a lot of requests to this domain.  It will probably appear in your top sites lists, alongside other ad and tracking code used by Google.

The site used to be owned by DoubleClick ad network, but Google now owns this.

If you suspect you have a virus or malware on your computer, do not click and links on random websites when searching for information, contact a computer repair specialist (like ourselves) to check and remove any issues.