Azure – Page 28 – Set-AzWebApp -name "Anything Microsoft and other stuff on the side"

Identity is the new perimeter and why information protection matters.

Posted by Harri Jaakkonen Posted on 25/08/2021 0 Comments

Posted in Azure, Exchange, Hybrid, Intune, Microsoft 365, Onedrive, Onpremise, Security

Your identity, identification or credit card is important, don’t loose them and don’t take it lightly. Even if talking about social security number or just your email. Both can be hijacked and used for purposes you don’t want. How you…

Using Azure File Shares with On-Prem ADDS Authentication and S2S VPN Tunnel

Posted by Mikko Pantti Posted on 13/04/2021 0 Comments

Posted in Active Directory, Azure, Powershell

Nowadays, Azure Files supports identity based authentication over SMB through two kind of Domain Services. You can either use Azure Active Directory Domain Services (AADDS) or the old On-Prem Active Directory Domain Services that most of the environments already have….

Azure Cognitive Services – Speech

Posted by Harri Jaakkonen Posted on 13/04/2021 0 Comments

Posted in Azure, Cognitive Services, Java, Visual Studio

Hi all, Last week I was doing something really different (not new because I already knew a little bit of Java and .net) I guess that my mind set is going like Microsoft future plans for certifications. Half hardcore architect…

Connect to Cloud with or without MFA and replace user licenses with menu.

Posted by Harri Jaakkonen Posted on 29/03/2021

Posted in Azure, Microsoft 365, Powershell

Made a powershell script to replace or add user licenses based on the same csv that were used for Exchange Hybrid migration. First You need a csv to be like this, but probably You have it if You did a…

Azure Dynamic Groups and how to use Extended attribute.

Posted by Harri Jaakkonen Posted on 29/03/2021

Posted in Azure, Exchange, Hybrid, Powershell

I wondered how to automagically add users to an Azure AD group with after their mailboxes have been migrated to the Cloud thru an Exchange Hybrid (Classic or Modern) And I figured out this one. Users get always populated with…

SQL Server Backup from inside Azure VM

Posted by Mikko Pantti Posted on 10/04/2019 0 Comments

Posted in Azure, SQL

You can backup SQL Server databases and instances running inside Azure VM using Azure Backup. The solution leverages the SQL native APIs to take backup of your SQL databases. When you specify the SQL Server VM that you want to…

Top 10 actions to secure your environment

Posted by Harri Jaakkonen Posted on 10/04/2019 0 Comments

Posted in Azure, Security

Hi, Microsoft has a blog series about securing our environment. The first one came in December 2018. For now there is 8 parts released, hopefully part 9 is coming soon. When almost all functions are out in the open these…

Office 365 Group and alias email-address.

Posted by Harri Jaakkonen Posted on 23/11/2017 0 Comments

Posted in Azure, Exchange, Office 365, Powershell

If You want to archive this You have to use Powershell. Connect to Exchange Online Powershell and use the command below:

Set-UnifiedGroup -Identity GroupMailboxIdentity@domain.fi -EmailAddresses @{Add='alias@domain.fi'}

1	Set-UnifiedGroup -Identity GroupMailboxIdentity@domain.fi -EmailAddresses @{Add='alias@domain.fi'}

Happy Powershelling,

Getting started with Windows Autopilot

Posted by Mikko Pantti Posted on 26/10/2017 0 Comments

Posted in Azure, Intune, Windows 10

Here is a small guide, on how to get started with Windows Autopilot. First thing that you need to make sure, is that you have the following prerequisites: Devices must be registered to the organization Devices have to be pre-installed…

Get a Msolusers with License details to seperate CSV-files.

Posted by Harri Jaakkonen Posted on 06/04/2017 0 Comments

Posted in Azure, Office 365, Powershell

Hi again, Today I found a script export users and licenses to csv-file. This one worked out nicely 🙂 http://sikkepitje.blogspot.fi/2016/10/get-msoluserlicense.html

<#

    Get-MsolUserLicense.ps1
    
    makes a report of license type and service plans per use , and saves one Excel-sheet (CSV) per uses license type.

    Original source: https://gallery.technet.microsoft.com/scriptcenter/Export-a-Licence-b200ca2a?tduid=(26fc5a009171934296bd78c7f4dd6590)(256380)(2459594)(TnL5HPStwNw-0Z3.3otQ5VeALpBrI1CXBg)()

    created by Alan Byrne
    modified 20161006 by p.wiegmans@bonhoeffer.nl/sikkepitje@hotmail.com

    Changed separator from comma to semi-comma, fixes formatting errors whene displayname contains comma (very common).
    Changed: separate output file , one for each license type.
    Changed: added timestamp to filename. 
    Changed: Fetching all users once, instead of every license type, givea huge speed boost.
#>

$VerbosePreference = 'Continue'    # Makes verbose meldingen zichtbaar : Modify to your needs
# The Reports will be written to files in the current working directory

# Connect to Microsoft Online IF NEEDED
#write-host "Connecting to Office 365..."
#Import-Module MSOnline
#Connect-MsolService -Credential $Office365credentials

# Get a list of all licences that exist within the tenant
$licensetype = Get-MsolAccountSku | Where {$_.ConsumedUnits -ge 1}

Write-Verbose "License types are:" 
$lts = $licensetype| select -expandproperty accountskuid | Format-Table -Autosize | Out-String
Write-Verbose $lts

Write-Verbose "Getting all users (may take a while) ..."
$allusers = Get-MsolUser -all 
Write-Verbose ("There are " + $allusers.count + " users in total")

# Loop through all licence types found in the tenant
foreach ($license in $licensetype) 
{ 
 # Build and write the Header for the CSV file
    $LicenseTypeReport = "Office365_" + ($license.accountskuid -replace ":","_") + "_" + (Get-Date -Format "yyyyMMdd-HHmmss") + ".csv"
    Write-Verbose ("New file: "+ $LicenseTypeReport)

 $headerstring = "DisplayName;UserPrincipalName;JobTitle;Office;AccountSku"
 
 foreach ($row in $($license.ServiceStatus)) 
 {
  $headerstring = ($headerstring + ";" + $row.ServicePlan.servicename)
 }
 
 Out-File -FilePath $LicenseTypeReport -InputObject $headerstring -Encoding UTF8 -append
 
 write-Verbose ("Gathering users with the following subscription: " + $license.accountskuid)

 # Gather users for this particular AccountSku
 $users = $allusers | where {$_.isLicensed -eq "True" -and $_.licenses.accountskuid -contains $license.accountskuid}

 # Loop through all users and write them to the CSV file
 foreach ($user in $users) {
  
        $thislicense = $user.licenses | Where-Object {$_.accountskuid -eq $license.accountskuid}
        $datastring = (($user.displayname -replace ","," ") + ";" + $user.userprincipalname + ";" + $user.Title + ";" + $user.Office + ";" + $license.SkuPartNumber)
  
  foreach ($row in $($thislicense.servicestatus)) {   
   # Build data string
   $datastring = ($datastring + ";" + $($row.provisioningstatus))
  }  
  Out-File -FilePath $LicenseTypeReport -InputObject $datastring -Encoding UTF8 -append
 }
} 

write-Verbose ("Script Completed.")

Get-MsolUserLicense.ps1

makes a report of license type and service plans per use , and saves one Excel-sheet (CSV) per uses license type.

Original source: https://gallery.technet.microsoft.com/scriptcenter/Export-a-Licence-b200ca2a?tduid=(26fc5a009171934296bd78c7f4dd6590)(256380)(2459594)(TnL5HPStwNw-0Z3.3otQ5VeALpBrI1CXBg)()

created by Alan Byrne

modified 20161006 by p.wiegmans@bonhoeffer.nl/sikkepitje@hotmail.com

Changed separator from comma to semi-comma, fixes formatting errors whene displayname contains comma (very common).

Changed: separate output file , one for each license type.

Changed: added timestamp to filename.

Changed: Fetching all users once, instead of every license type, givea huge speed boost.

$VerbosePreference = 'Continue' # Makes verbose meldingen zichtbaar : Modify to your needs

# The Reports will be written to files in the current working directory

# Connect to Microsoft Online IF NEEDED

#write-host "Connecting to Office 365..."

#Import-Module MSOnline

#Connect-MsolService -Credential $Office365credentials

# Get a list of all licences that exist within the tenant

$licensetype = Get-MsolAccountSku | Where {$_.ConsumedUnits -ge 1}

Write-Verbose "License types are:"

$lts = $licensetype| select -expandproperty accountskuid | Format-Table -Autosize | Out-String

Write-Verbose $lts

Write-Verbose "Getting all users (may take a while) ..."

$allusers = Get-MsolUser -all

Write-Verbose ("There are " + $allusers.count + " users in total")

# Loop through all licence types found in the tenant

foreach ($license in $licensetype)

{

# Build and write the Header for the CSV file

$LicenseTypeReport = "Office365_" + ($license.accountskuid -replace ":","_") + "_" + (Get-Date -Format "yyyyMMdd-HHmmss") + ".csv"

Write-Verbose ("New file: "+ $LicenseTypeReport)

$headerstring = "DisplayName;UserPrincipalName;JobTitle;Office;AccountSku"

foreach ($row in $($license.ServiceStatus))

{

$headerstring = ($headerstring + ";" + $row.ServicePlan.servicename)

}

Out-File -FilePath $LicenseTypeReport -InputObject $headerstring -Encoding UTF8 -append

write-Verbose ("Gathering users with the following subscription: " + $license.accountskuid)

# Gather users for this particular AccountSku

$users = $allusers | where {$_.isLicensed -eq "True" -and $_.licenses.accountskuid -contains $license.accountskuid}

# Loop through all users and write them to the CSV file

foreach ($user in $users) {

$thislicense = $user.licenses | Where-Object {$_.accountskuid -eq $license.accountskuid}

$datastring = (($user.displayname -replace ","," ") + ";" + $user.userprincipalname + ";" + $user.Title + ";" + $user.Office + ";" + $license.SkuPartNumber)

foreach ($row in $($thislicense.servicestatus)) {

# Build data string

$datastring = ($datastring + ";" + $($row.provisioningstatus))

}

Out-File -FilePath $LicenseTypeReport -InputObject $datastring -Encoding UTF8 -append

}

write-Verbose ("Script Completed.")

Category: Azure