Get Skype for Business Numbers

As shown at Microsoft Ignite 2015 here is the script demoed called Get-SfBNumbers.net. At this time the tool is in beta since it has only been tested in a handfull of deployments

 
 
 
 
 
5 Star
(8)
2,719 times
Add to favorites
Lync
10/20/2015
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • .\get-sfbnumbers.ps1 -Name "UK London 0203 Main Range" -FirstAvailableAsLineURI $true
    1 Posts | Last post November 21, 2017
    • The script works very well apart from the below
      
      when I run
      
      .\get-sfbnumbers.ps1 -Name "UK London 0203 Main Range" -FirstAvailableAsLineURI $true
      
      
      it just runs the script without the options so never returns the line uri that I can then use in my user creation script 
      
      can you help 
      
      thanks 
  • I got the below error
    1 Posts | Last post September 11, 2017
    • Hello Stale
      I also attended your session @MSIgnite, it was amazing, I've the below error msg 
      
      
      Connecting to Monitoring CDR database to check for users that has not logged on
      for 30 days or more...Unable to index into an object of type Microsoft.Rtc.Manag
      ement.Xds.DisplayMoni
      toringDatabase.
      At D:\Get-SfBNumbers.ps1:550 char:28
      + $MonServer=$MonServerFound[ <<<< 0]
          + CategoryInfo          : InvalidOperation: (0:Int32) [], RuntimeException
          + FullyQualifiedErrorId : CannotIndex
      
      You cannot call a method on a null-valued expression.
      At D:\Get-SfBNumbers.ps1:552 char:137
      +     $SQLConnect = [System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetData
      Sources() | ? { $_.servername -eq $Monserver.PoolFqdn.Split <<<< (".")[0]} -Err
      orAction Stop
          + CategoryInfo          : InvalidOperation: (Split:String) [], RuntimeExce
         ption
          + FullyQualifiedErrorId : InvokeMethodOnNull
      
      You cannot call a method on a null-valued expression.
      At D:\Get-SfBNumbers.ps1:552 char:137
      +     $SQLConnect = [System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetData
      Sources() | ? { $_.servername -eq $Monserver.PoolFqdn.Split <<<< (".")[0]} -Err
      orAction Stop
          + CategoryInfo          : InvalidOperation: (Split:String) [], RuntimeExce
         ption
          + FullyQualifiedErrorId : InvokeMethodOnNull
      
      You cannot call a method on a null-valued expression.
      At D:\Get-SfBNumbers.ps1:552 char:137
      +     $SQLConnect = [System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetData
      Sources() | ? { $_.servername -eq $Monserver.PoolFqdn.Split <<<< (".")[0]} -Err
      orAction Stop
          + CategoryInfo          : InvalidOperation: (Split:String) [], RuntimeExce
         ption
          + FullyQualifiedErrorId : InvokeMethodOnNull
  • User activity check
    3 Posts | Last post November 19, 2015
    • I noticed that when you specify that you don't want to report user activity, it still runs the SQL against the monitoring database.  For some reason that is failing for me (although the permissions and access look fine) and it just exists the script.  I can comment out those functions and it will continue, but something to note.
    • Thanks. yes it still will connect, and get logon information. would be cool to know why it fails for you, is it possible for you to send me some more information to stale[at]msunified.net? Info from Get-CsService | Where-Object {$_.Role -eq "MonitoringDatabase"} would be nice. 
    • I have also come across the same issue with the SQL connection; I dug a bit into the script and tested the actual SELECT statement that is run; and I got this error straight from the SQL Mgmt Studio:
      Msg 229, Level 14, State 5, Line 1
      The SELECT permission was denied on the object 'Users', database 'LcsCDR', schema 'dbo'.
      
      I have also noticed that on line 583; you check for $SQLConnect to be $null; where as it is not null even though the Instance in use is the default instance.
      
      Hope this helps.
  • Mirror check
    3 Posts | Last post October 20, 2015
    • Hi,
      I attended your session on #MSIgnite in Chicago and now wanted to check the new features. Good session by the way.
      I have found that on installations were I used SQL mirroring the script tries to connect to both the active and mirror database. Obviously the mirror database is not available and should not be checked. You might want to add a little check on this.
      Thanks for sharing.
      
      Regards
      Kent, Denmark
    • Thanks for testing out Kent. I will work on the sql instance discovery for the next update :)
    • Hi Kent. I just released an updated version where this is fixed :)