Search This Blog


Saturday, March 28, 2015

Bulk Remove Azure Active Directory User and Group Using Powershell



  • Using Azure Active Directory
  • Has used AAD Sync to sync on-premise user account and group
  • Discovered has accidently sync user account and group to Azure Active Directory but require to remove it.

It’s quite a painful experience to delete each individual user account and group from Azure Management Portal. Wonder why no multiple select option and quite annoying when it asking for confirmation and refresh. But lucky enough got powershell to do the job.


[ Configuration]

After install the pre-requisite, open the Azure Active Directory Module for Windows Powershell.

Connect to Azure Active Directory by entering the Global Administrator account.

$msolcred = get-credential
connect-msolservice -credential $msolcred

Export the user account to csv file format

Get-MsolUser –All | Export-CSV C:\users.csv

Open the csv file and remove the Microsoft account and Global Administrator account. We just want to remove others account and retain the Global administrator account.

Export the group to csv file format

Get-MsolGroup –All | Export-CSV C:\Groups.csv

Final step is start to remove bulk users account and groups

Remove Users

Import-CSV C:\Users.csv | Remove-MsOlUser –Force

Remove Groups

Import-CSV C:\Groups.csv | Remove-MsOlGroup –Force

Deletion process is quite long period if you’ve more than 8000 records.

Friday, March 27, 2015

Starwinds News–27 March 2015

1. Tap Room Meeting: VMware and StarWind Virtual SAN: from Two, to Infinity and Beyond

Date: 2 April, 11 am ET / 4 pm BST

Host: Anatoly Vilchinskiy, Head of Support Department, StarWind Software Inc.

Let's put all cards on the table: VMware is good, their VSAN is good. But does it good for all situations? Get yourself on the most comfortable chair in the Tap Room, open the whisky bottle, and our host will tell you why is it better to start with two shots instead of shugging the whole bottle.

*The only Tap Room, where no one will snatch your cocktail if you leave it on a table.

Virtualize properly!

Book a table here!

2. Free Webinar! Critical SQL Server Databases: Provide HA with SQL Server Failover Clustering and Cluster Shared Volumes


Date: 15 April, 11 am PM / 2 pm ET

Speakers: Edwind Sarmiento, Microsoft SQL Server MVP and Microsoft Certified Master

Max Kolomyeytsev, Product Manager, StarWind Software Inc.

Highly-Available SQL Server with reliable Disaster Recovery is traditionally hard to achieve but necessary to have. We say it is possible to build a fully redundant SQL Server 2014 cluster with just 2 servers, StarWind Virtual SAN and Cluster Shared Volumes while implementing disaster recovery to several places with minimal RTO and RPO!
Join SQL Server MVP and Microsoft Certified Master Edwin M Sarmiento to learn how to use Windows Server Failover Clustering with Cluster Shared Volumes to provide high availability and disaster recovery solutions for mission-critical SQL Server 2014 databases.
We will look at how to configure a highly available SQL Server on top of Cluster Shared Volumes and also discuss best practices and recommendations.


3. Free Webinar! Make Your Storage Work For You: VAAI and ODX offload up to 30% of disk operations to the SAN


Date: 21 April, 11am PT / 2pm ET

Speakers: Aidan Finn, Microsoft MVP, Technical Sales Lead at MicroWarehouse Ltd.
Max Kolomyeytsev, Product Manager, StarWind Software Inc.

StarWind always considered virtual storage systems to be valued for uptime, performance and flexibility – take one out and the system is useless. Hypervisor CPU and Networking overhead is a common issue for operations like VM provisioning, migration, and cloning. There should be a way to enhance performance by offloading the unnecessary CPU load and shrinking the SAN traffic. ODX and VAAI features do exactly this by offloading routine disk tasks to the storage array so they will be executed more effectively. That is if your SAN supports one of these features. StarWind Virtual SAN does both – just saying.

Join Aidan Finn and Max Kolomyeytsev at this webinar dedicated to the use of Offloaded Data Transfer (ODX) and APIs for Array Integration (VAAI). They will explain exactly how you can greatly enhance the storage system performance and increase VM density with Hyper-V and vSphere.

Register here!

4. Win the Full Conference Pass for the Microsoft Ignite 2015!


Attend or register for any ‎StarWind ‪‎webinar or ‪#TapRoom Meeting till 16 April and take a chance to win the Full Conference Pass for Microsoft‪#‎Ignite 2015!

The winner will be announced at StarWind blog, and on Facebook and Twitter pages on the 20th of April!

5. Meet StarWind at MS Ignite 2015!


Request a chance to schedule a personal meeting with Anton Kolomyeytsev, StarWind Founder and CTO, or Joseph Preston, VP of Sales at Microsoft Ignite 2015

6. Product overview written by Vladan about Starwind Virtual SAN

Tuesday, March 24, 2015

System Center Data Protection Manager (DPM) Backup Summary Report


DPM  by default included with default reporting on the product. Below are the reports available and most of the time is insufficient for reporting.


Therefore we dig further and found UR5 for DPM has enhanced reporting with Data Protection Manager Central Console. However at this moment of writing this post, we found out that this MP has pull back and unavailable. We’re stuck without any other report.


Hmm…then we are lucky to found out that System Center MVP, Steve Buchanan has released “DPM Backup Summary Report” and we decide to explore the report. Time to import the report into DPM Report Server and able to see the result of report.

[DPM Pre-requisite ]

This report works with

  • DPM 2010
  • DPM 2012
  • DPM 2012 SP1
  • DPM 2012 R2

[ Report ]

The report provides

  • Ability to select day, week, month (Time range)
  • Ability to select a single server or many
  • Ability to select a single protection group or many
  • Ability to select disk, tape or both backup type
  • Summary of the backup success and failures with a percentage of the successes (Success Rate/SLA)
  • Health trend of backups (day, week, month)
  • Backup detail including:Individual data sources (What was actually backed up)
  • The status including the error (if there is an error)
    • Date and time the backup was created
    • How much data was transferred during the backup
    • Total time it took to backup to complete



DPM Backup Report Summary can export to


From a single pane of glass, the report provide a good reporting and information require by an administrator.

If you’re interested to get it , please feel free to download from Technet Gallery DPM Backup Summary


Backup VMM Database Using DPM 2012 R2 Failed With ID 3170 and ID 33424



  • System Center Data Protection Manager 2012 R2
  • System Center Virtual Machine Manager 2012 R2


[ Error ]

When we try to configure DPM to backup VMM Database by using VMM Express Writer, the protection group backup failed and displayed an error message with an ID 3170 and ID 33424




1. Login to VMM and use SQL Management Studio to modify NT Authority\SYSTEM to include “sysadmin” roles


2. Open DPM Management Console, perform consistency check


By right, now your backup will work.

Monday, March 23, 2015

Webinar: Upcoming features in Hyper-V vNext


This Thursday 26th March 4PM CET  / 11am EDT / 8am PDT we have a new upcoming webinar on Hyper-V vNext with Microsoft Sr. Technical Evangelist Rick Claus, & Hyper-V MVPs Aidan Finn & Andy Syrewicze.

More info and register link can be found here:

Friday, March 20, 2015

Countdown Earth Hour 2015


Synchronize Directory to Azure Using Microsoft Azure Active Directory Sync Services (AAD Sync)


We have been busy with recent project on Enterprise Mobility Suite (EMS) and the first tool that we are going to use is using Directory Synchronization tool. We used to use DirSync to synchronizes users, password, security groups, distribution lists, contacts, etc. However DirSync tool has been replaced by AAD Sync (Azure Active Directory Sync Services)

Here is a quick directory synchronization tool comparison:

Tools Description
DirSync support for single forest syncronization
AAD Sync support single and multi forest synchronization
Password write
AAD Connect Includes AAD Sync
Will assist to setup ADFS
Will assist to setup Web Application Proxy

In this articles, we are going to deploy AAD Sync

[Download AAD Sync]

To download – [Last update Feb 2015] – Click here


  • Define the location to install the Azure AD Sync


  • Click on Install . It will install few components such as SQL Express, Synchronization Services. This will take a while


  • Enter the Azure AD Account which has global administrator right and click Next. Remember to “Activate” Directory Synchronization in Azure.


  • Enter your domain admin authentication and forest name. It will install AD connector services


Define the user matching attribute


  • On Optional features page, select an additional features that AAD Sync perform. Example
      • Exchange Hybrid Deployment
      • Password Synchronization
      • Password write back
      • Azure AD App and attribute filtering


  • Click Configure and wait for AAD Sync tool to perform the changes


Just wait for a while and it will start to sync directory to Azure. To check the result, go to Azure Management Portal and able to view on-premise user and group has sync to Azure Directory.

It is still a simple tool and work exactly like DirSync

For other tool, please check out

Wednesday, March 18, 2015

Free Ebook: Microsoft System Center Deploying Hyper-V with Software Defined Storage and Networking

Microsoft System Center Deploying Hyper-V with Software-Defined Storage and Networking

MS Press just released a new ebook which talked about software defined datacenter; virtualization, storage and networking.

Summary of the content:-

  • Chapter 1 – Design and Planning
  • Chapter 2 – Deploying the management cluster
  • Chapter 3- Configuring network infrastructure
  • Chapter 4 – Configuring Storage Infrastructure
  • Chapter 5 – Configure Compute Infrastructure
  • Chapter 6 – Configure Network Virtualization

To download,

Download the PDF (5.48 MB)

Download the EPUB file (6.41 MB)

Download the Mobi for Kindle file (12.6 MB)