Forum Discussion

Deleted's avatar
Deleted
Feb 20, 2019
Solved

Get-MsolUser filtered variable

Wonder if anyone can help... > I have a txt file containing a list of user principal names.  > I need to return all users if they have a licence and their UPN isn't listed in the TXT file.    #Us...
office 365
  • Kevin_Morgan's avatar
    Kevin_Morgan
    Feb 20, 2019

    Hi,

     

    You can try this script (after replacing your UserName) :

    $Results = @();
    $Users = Get-Content C:\Users\UserName\UserImport.txt
    #Get All Licensed Users & Filtered
    $licensedUsers = Get-MsolUser -All | Where-Object { $_.isLicensed -eq $true }
    $licensedUsers | ForEach-Object {
    If ($Users -notcontains $_.UserPrincipalName)
    {
    $Results += "$_.UserPrincipalName"
    }
    }
    $Results.Length

     Or you can try this script :

     

    $Results = @();
    $Users_Txt = Get-Content C:\Users\UserName\UserImport.txt -Raw
    #Get All Licensed Users & Filtered
    $licensedUsers = Get-MsolUser -All | Where-Object { $_.isLicensed -eq $true }
    $licensedUsers | ForEach-Object {
    $upn = $_.UserPrincipalName
    If ($Users_Txt -notlike "*$upn*")
    {
    $Results += $upn
    }
    }
    $Results.Length

     

Kevin_Morgan's avatar
Kevin_Morgan
Iron Contributor
Feb 20, 2019

Hi,

 

You can try this script (after replacing your UserName) :

$Results = @();
$Users = Get-Content C:\Users\UserName\UserImport.txt
#Get All Licensed Users & Filtered
$licensedUsers = Get-MsolUser -All | Where-Object { $_.isLicensed -eq $true }
$licensedUsers | ForEach-Object {
If ($Users -notcontains $_.UserPrincipalName)
{
$Results += "$_.UserPrincipalName"
}
}
$Results.Length

 Or you can try this script :

 

$Results = @();
$Users_Txt = Get-Content C:\Users\UserName\UserImport.txt -Raw
#Get All Licensed Users & Filtered
$licensedUsers = Get-MsolUser -All | Where-Object { $_.isLicensed -eq $true }
$licensedUsers | ForEach-Object {
$upn = $_.UserPrincipalName
If ($Users_Txt -notlike "*$upn*")
{
$Results += $upn
}
}
$Results.Length

 

  • Deleted's avatar
    Deleted
    Feb 21, 2019

    This is working perfectly! Thank you for your help.

    One final question, is it possible to pass the $Results variable in to "$User = Get-MsolUser -UserPrincipalName $Results" ? When i do this is I get:

     

    Get-MsolUser : Cannot convert 'System.Object[]' to the type 'System.String' required by parameter 'UserPrincipalName'.
    Specified method is not supported.
    At line:2 char:41
    + $User = Get-MsolUser -UserPrincipalName $Results
    + ~~~~~~~~
    + CategoryInfo : InvalidArgument: (:) [Get-MsolUser], ParameterBindingException
    + FullyQualifiedErrorId : CannotConvertArgument,Microsoft.Online.Administration.Automation.GetUser

     

     

    Or depending where I insert the line I get:

     

    Get-MsolUser : Cannot convert 'System.Object[]' to the type 'System.String' required by parameter 'UserPrincipalName'.
    Specified method is not supported.
    At line:6 char:41
    + $User = Get-MsolUser -UserPrincipalName $Results
    + ~~~~~~~~
    + CategoryInfo : InvalidArgument: (:) [Get-MsolUser], ParameterBindingException
    + FullyQualifiedErrorId : CannotConvertArgument,Microsoft.Online.Administration.Automation.GetUser

    • Kevin_Morgan's avatar
      Kevin_Morgan
      Iron Contributor
      Feb 21, 2019

      Yes, you can do it as like in below script:

      $Results | ForEach-Object {
      $userObj = Get-MsolUser -UserPrincipalName $_
      Write-Host $userObj.DisplayName
      }

      But what you are going to do? As we have already formed the $Results object from the output of Get-MsolUser. I think you can extract required data from previous step itself.

       

      If you explain your need clearly, I will provide the updated script.

Resources