Office 365 – Email Usages Reports in the Admin Portal

November 24, 2017

When running Email usage reports in the Office 365  Admin Portal.

Gives you the names of the users in a disguised format by default.

image

You can change this : Settings –> Services & Add-Ins –> Reports

Read the rest of this entry »

Advertisements

SharePoint – Enable Special Characters for OneDrive4Business Sync

November 14, 2017

When you have users that have Errors syncing file using the latest OD4B client.

It might be that there are some special characters like # and %.

That are in the file name, and are not supported by default.

image

SOLUTION :

Connect to the SharePoint Online Management Shell Using PowerShell.

These commands require version 16.0.6323.1200 of the SharePoint Online Management Shell or greater.

Run this command to see the current status

Get-SPOTenant

image

When you see NoPreference, you need to run this command.

Set-SPOTenant -SpecialCharactersStateInFileFolderNames Allowed

image

Keep in mind that it will about 2 hours or more before it gets active ….

If it still does not work you can run this procedure to force it :

If OneDrive sync seems to be stuck for a long time and nothing else is working, try a reset.

Be aware that resetting OneDrive re-syncs all your OneDrive files, which could take some time depending on how many files you’re syncing.
Press  WinKey + R

In the Run window, enter: %localappdata%\Microsoft\OneDrive\onedrive.exe /reset

After reset the OneDrive, files with special characters (# %) were synced properly.

  image

PS : See here for more info

https://techcommunity.microsoft.com/t5/SharePoint-Blog/New-support-for-and-in-SharePoint-Online-and-OneDrive-for/ba-p/60357

Enjoy !


MS SQL – Query & Reporting Tools

November 11, 2017

Getting data out of a Database hasn’t been easier these days. Giving all the tools you have at your disposal…

Giving the fact that all the fuss about BI and Cloud Storage, Big Data etc. We seem to loose feeling with all the o

image

Here are a few examples we can use for simple and complex query and reporting purposes.

1. Query using the MS SQL SSMS

It’s obvious that SQL SSMS offers all the functionality you need to get the data out of the database.

This example shows a combination of Common Table Expression (CTE) Query combined with the PIVOT function, to generate you dataset.

image

2. Using PowerShell – Query

Re-using this quite complex Query using Scripting language is quite Powerful.

image

image

3. Excel – Query

Using Excel combined with MS Query we can re-use the same Query

image

image

image

image

4. Access – Pass-Through Query

Re-using the complex query using MS Access in a Pass-Through Query Statement.

image

image

image

5. MS SQL Reporting Services

Re-using the complex query using MS SQL Reporting Services & Report Builder

image

image

6. MS PowerPivot – Excel Addin

Re-using the complex query using MS Power Pivot – Addin

image

image

image

image

image

7. MS Power BI

Re-using the complex query using MS Power BI

image

image

This is not a limit list of tools you have a hand. There many more which you might overlook …

QlikView Client

MS Power Query

– …

For getting data out of a database you need to the proper tools, but this is not a constraint at the moment.

What is, is being able to manage all these different applications and technologies.

Bottom-line is that one you spend efforts in getting your queries right you can re-use them most any tool that comes around Smile


Windows Server 2016 – Event ID 7000 & 7009

November 8, 2017

More Event ID Errors, it does not seem to stop … ?

Event ID 7000 and 7009 relating to a Service not starting at reboot.

image

The WseMgmtSvc service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.

SOLUTION :

Go to Services and find Windows Server Essentials Management Service

image

Change the startup to Automatic – Delayed Start

image


Windows Server 2016 – Event ID 7023 Error

November 8, 2017

Every reboot you will see this error 3 times popping up … ?

Service Control Manager Event ID 7023

image

Message :

Data Sharing Service
%%3239247874

SOLUTION :

1. Run this command :

– sc config DsSvc type=own

image

2. Next start the service Data Sharing Service and check it runs OK

image

No errors in the Event Log anymore Smile

Enjoy !


Windows Server 2016 – Event ID 8193 / 8194 Error

November 8, 2017

OK while we are on track solving all critical Event log Errors we just might also tackle this one… Winking smile

Like Event ID 8193 / 8194 and 12291 VSS …

SOLUTION :

1. Event ID 8193 – Check Registry Key Security Settings for the NETWORK SERVICE Account.

MESSAGE : VSS error ID 8193 (Volume Shadow Copy Service error: Unexpected error calling routine RegOpenKeyExW…)

Add the NETWORKS SERVICE account to the VSS Service RegKey Diag :

– HKLM\System\CurrentControlSet\Services\VSS\Diag

image

2. Event ID 8194 – Check DCOM Security Settings for the NETWORK SERVICE Account.

MESSAGE : Volume Shadow Copy Service error: Unexpected error querying for the IVssWriterCallback interface.  hr = 0x80070005, Access is denied.

Open the DCOMCNFG check if the NETWORK SERVICE is present if not add the LOCAL ACCESS.

image


Windows Server 2016 – Event ID 3 Filter Manager Error After Backup starts

November 8, 2017

More Event Error to tackle Sad smile 

image

Message is a follows :

Filter Manager failed to attach to volume ‘\Device\HarddiskVolume64’. 

This volume will be unavailable for filtering until a reboot.  The final status was 0xC03A001C.

According to this blogpost the reason is simple :

https://www.mcbsys.com/blog/2012/12/filtermanager-event-id-3-during-backups/

When using the native Backup solution from Windows, and the backup destination is an External Drive.

You can get this error when the Windows Search Service is running ?

SOLUTION :

Stop the Windows Search Service before the backup starts and start again afterwards.

– net stop wsearch

– net start wsearch

image

You can incorporate this is the existing Backup Scheduled Tasks like this :

Add one command BEFORE and 1 command AFTER the backup job.

image

image

Check the errors afterwards again to see that they are gone.

Enjoy !