Articles in this section

See more
Print

Direct Routing Phone Number Ranges rule

Avatar
Tatiana Golubovich
  • Updated
Follow

Rule description

This report queries a telephone number range definition file, finds the assigned numbers in each range and returns the aggregate information on number usage for each range.

 

When to use this rule

Note: Before using this rule in Administrator Console please navigate to Home > Configuration > Connected Systems Extensions > Microsoft Office 365 and set Connect to Microsoft Teams (Skype for Business Online) to Yes. 

Use this rule when you need to get the usage information for each defined number range. Also use this rule if you need to get a notification report when the percentage of free numbers in a range fall below a configurable threshold. 

 

This rule requires the configuration of two CSV files:

  1. Phone ranges - specifies phone number ranges, possible extensions, and corresponding locations;
  2. Reserved numbers - specifies phone numbers that are reserved and can not be assigned to users;

You can use the template CSV file provided with the rule, or create a file in Microsoft Excel and export as CSV.

Tip: You should normally use the same CSV files that are configured for the related 'AD Users | Direct Routing Assignment' rule

 

Rule Settings

Query Section

Setting name Description

Phone Number Ranges

 

Phone ranges data source

Specifies the CSV file where ranges data are defined. 

The […] button allows to browse for the file and the Create/Edit button allows the creation or editing of the existing file in the built-in Data Source editor.

Separator used in file 

 Specify separator used in the file: comma or semi-colon.

Range Start

Range End

You should specify the number format in range start and range end columns and select these columns here.

The number should be in standard E.164 format like +123456789.

Note: To query ranges built on extensions of the same number, use the following format: Range start = +12346789;ext=10, Range end = +12346789;ext=100. When specifying extension ranges, the telephone number must be the same for the range start and range end. 

Ignore assigned extension

When set to Yes, the currently assigned extension will be ignored for matching the assigned number with the range.
Warning threshold %

Specify the warning threshold in %. When the free numbers in a given range fall below this value, the range is considered as having a warning status 
Group by

Select a column to group ranges for threshold calculation by this attribute.
Show ranges

Select which ranges should be displayed in the report:

  1. All 
  2. Warnings only

 

Tip: Set your warning threshold and this setting to 'Warnings only' to get a report that contains only warning ranges. You can receive this report on schedule into your inbox by configuring the output section
Filter CSV data The filter can be used to filter by the values in the CSV file columns like {$_.ColumnName -eq 'value'}

Reserved Numbers

  

Reserved numbers data source

 Specifies the CSV file to be used with the list of reserved numbers. Reserved numbers that fall into one of the ranges defined in the Phone Number Ranges file above will be counted as used and will go towards calculating the warning threshold. 

Reserved number

 Select the column in the data source that contains reserved telephone numbers.

More Options 

  

Returned Properties

To display additional properties for each object found by the query, add those properties to the list.

Sort by

Sort result objects list.

Exclude disabled AD users

Specify if disabled AD user accounts should be excluded.

Maximum number of users

By default, all objects that you have provisioned in Microsoft Office 365 are returned.

Tip: It is possible to change the default value in Microsoft Skype Server extension settings.

Post filter

In this filter, you can use both Active Directory attributes and column names from the CSV file. Column names you should type manually.

Initialization Script 

 

Script

Usually, rules use query criteria to limit the query search scope. It improves the performance of the executed rule.

Due to PowerShell limitations, it is not possible to use calculated expressions in query criteria. That is the point where the initialization script can help. You can initialize a global variable in this setting and then use it in query criteria. 

Important: To use a variable, declared in the initialization script, in the query scope, it must be global: $global:<variable name>.

Example: Update AD users, created in the last ten days.

  1. Add this initialization script:
{$global:DatePeriod = (Get-Date).AddDays(-10)}
  1. Use $DatePeriod variable in query criteria builder:

 

Output Section

This section defines the output format of this rule.

To get more information about this section, please see the Output section article.

 

Enforce/Schedule section

This section defines the schedule for how often to run the rule.

To get more information about this section, please see the Enforce/Schedule section article. 

 

 

 

Change History

Version Notes
7.4.0 The rule is introduced in the product.

 

 

 

 

Related articles

Comments

0 comments

Please sign in to leave a comment.