Rule description
This report queries a telephone number range definition file, and returns information on each number defined in the range. This output can be filtered to show only unassigned or only assigned numbers.
When to use this rule
Use this rule when you need to get the list of Office 365 phone numbers in one or more ranges with their assignment status or when you need to get a list of numbers of a specified assigned status.
This rule requires the configuration of two CSV files:
- Phone ranges - specifies phone number ranges, possible extensions, and corresponding locations;
- 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.
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 range. |
|
Show numbers |
Select which numbers should be displayed in the report:
|
|
Filter ranges |
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 are counted as assigned in this report. |
|
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.
{$global:DatePeriod = (Get-Date).AddDays(-10)}
|
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. |
Comments
0 comments
Please sign in to leave a comment.