...
Permission is also required from the vendor for some solutions therefore please contact us for further information and we can assist.
...
...
Data Blending
Data blending is the process of adding additional files to a PBX audit to augment it and add information from other systems such as Active Directory, Voicemail or call data (CDR).
Supported formats
All additional files for blending are required to be in CSV format. We can also provide example files for you to compare/check against if required.
The format for each filetype is shown in the table below.
Type | Typical export from | Default Field mappings | Info |
Active Directory | Microsoft AD via PowerShell (On-Prem) or Azure AD GUI using export users option. | Telephonenumber/Phone | Looks for Line1DN to patch telephonenumber/phone, if no match, attempts to match on name. Will map all appropriate fields if it finds a match. |
DDI | This is generated by us/you on a per-customer basis | EXTNPATTERN | This is used to bulk-map DDI and override locations if needed.In this example, any extension in the form 420xxx will be given an appropriate DDI number, and the location will be overrriden to "Amsterdam" - The RegionId of -1 means "match all locations to find this number in the list"The example 567x will only be overridden if the existing location (RegionID/RegionName) matches. Note: The number of underscores must be the same in the suffix of the 1st two columns for this to work |
Devices
Generated by you/us if needed
userId
MAC
deviceType
Used primarily for Broadworks exports where device information isn't in the backup;
Looks for the Line1DN or Line1DDI matching userId, if matched, sets the MAC and primaryModel (if each not already populated)
Network
Edge switches
Number
MAC
IP
Switch
Port
Last Seen
Will try to match on Number, IP or MAC. If found, will set Switch, Port and Last Seen values
Recorder
NICE NTR
Primary Extension Name
If the "Primary Extension Name" matches Line1DN, then the "Recorder" column is set to "Yes"
Voicemail
Unity
FirstName
LastName
Extension
group
Will set "Personal" voicemail if found, or "Group" if set
...
