Detail License Customer Aggregate Data Export¶
This is the partner view of the data that includes customer details for better understanding.
Filename: vlf_<provider_name>_<host_name>_detailed_<YYYY-MM-DD_HHMM>.csv
Metadata: header rows showing the date time stamp and version, prefixed by a #, for example:
#OrgID=0010O00001kPTUpQAO
#Platform ID=5e54067d116fa10046313224
#hostname=VOSS-UN-1
#Provider Name=CS-P
#Software Version=21.2
#Platform Version=21.2.0-1630252949
#Deployment Mode=Provider with HCMF
#Date Time=2021-11-19 13:11
#Audit Version=4.0.1
Note
For licensing:
OrgIDis the account id from the Customer Portal: Company Information.CTI Ports are not counted as user or standalone phones.
Cisco Spark Remote Devices are only counted if a subscriber has no other phones. If a subscriber has more than one Cisco Spark Remote Device, this is counted as a single device.
If a user has more than 10 devices associated to them (via associated devices or ownerid on the phone) then for each increment of 10, an additional license is counted.
For example:
a user with 5 phones assigned = 1 license and not added to Users With More Than 10 Phones list.
a user with 15 phones assigned = 2 licenses and added to Users With More Than 10 Phones list.
a user with 30 phones assigned = 3 licenses and added to Users With More Than 10 Phones list.
DEVICE/SERVICE |
DESCRIPTION |
DATA TYPE |
|---|---|---|
Provider |
Provider hierarchy name on the system. |
string |
Reseller |
Reseller hierarchy name on the system. |
string |
Customer |
Customer hierarchy name on the system. |
string |
Customer PKID |
Customer hierarchy pkid on the system. |
string |
One Phone (No VM & No WebEx & No Spark) |
Number of Subscribers at the site level with one device (Hard or Soft Phone) but without VM, WebEx or Spark (Webex Teams) Services. A user’s associated devices as well as a phone’s ownerUserName are used to determine if a phone belongs to the user. |
integer |
One Phone & Spark (No VM & No WebEx) |
Number of Subscribers at the site level with one device (Hard or Soft Phone) and Spark (Webex Teams) service but without VM or WebEx Services. A user’s associated devices as well as a phone’s ownerUserName are used to determine if a phone belongs to the user. |
integer |
One Phone & VM (No WebEx) |
Number of Subscribers at the site level with one device (Hard or Soft Phone) and VM but without WebEx Services. A user’s associated devices as well as a phone’s ownerUserName are used to determine if a phone belongs to the user. |
integer |
One Phone & WebEx |
Number of Subscribers at the site level with one device (Hard or Soft Phone) and WebEx. A user’s associated devices as well as a phone’s ownerUserName are used to determine if a phone belongs to the user. |
integer |
Multiple Phones |
Number of Subscribers at the site level with more than one device (Hard or Soft Phone). A user’s associated devices as well as a phone’s ownerUserName are used to determine if a phone belongs to the user. |
integer |
Users With More Than 10 Phones |
Number of Subscribers at the site level with more than 10 devices (Hard or Soft Phone). A user’s associated devices as well as a phone’s ownerUserName are used to determine if a phone belongs to the user. |
integer |
UCM User (No Phone & No EM & No VM & No WebEx & No SNR & No Spark) |
Number of Subscribers at the site level without any services and without an Extension Mobility Profile. |
integer |
SNR (No Phone & No EM & No VM & No WebEx & No Spark) |
Number of Subscribers at the site level that only have the SNR service enabled. |
integer |
VM (No Phone & No EM & No WebEx) |
Number of Subscribers at the site level that only have the VM service enabled. |
integer |
WebEx (No Phone & No EM) |
Number of Subscribers at the site level that only have the WebEx service enabled. |
integer |
Spark (No Phone & No EM & No SNR & No VM & No WebEx) |
Number of Subscribers at the site level that only have the Spark (Webex Teams) service enabled. |
integer |
DEVICE/SERVICE |
DESCRIPTION |
DATA TYPE |
|---|---|---|
EM & Spark (No Phone & No VM & No WebEx) |
Number of Subscribers at the site level with an Extension Mobility profile and Spark (Webex Teams) service but without VM or WebEx Services. |
integer |
EM (No Phone & No SNR & No VM & No WebEx & No Spark) |
Number of Subscribers at the site level with an Extension Mobility profile but without any device or services. |
integer |
EM & SNR (No Phone & No VM & No WebEx & No Spark) |
Number of Subscribers at the site level with an Extension Mobility profile and Remote Destination Profile but without devices or services. |
integer |
EM & VM (No Phone & No WebEx) |
Number of Subscribers at the site level with an Extension Mobility profile and VM but without devices or WebEx service. |
integer |
EM & WebEx (No Phone) |
Number of Subscribers at the site level with an Extension Mobility profile and WebEx service but without devices. |
integer |
Standalone Phones (No UCM User) |
Number of phones at the site level in the system that are not assigned to a Subscriber. A user’s associated devices as well as a phone’s ownerUserName are used to determine if a phone belongs to a user. |
integer |
Standalone WebEx (No UCM User) |
Number of standalone WebEx accounts at the site level in the system (no corresponding UCM user). |
integer |
Standalone Voicemail (No UCM User) |
Number of VM only accounts at the site level in the system (no corresponding UCM user). |
integer |
Contact Center Enterprise |
Number of Contact Center Enterprise users at the site level in the system (UCCE). |
integer |
Contact Center Express |
Number of Contact Center Express users at the site level in the system (UCCX). |
integer |
Standalone Spark (No UCM User) |
Number of standalone Spark (Webex Teams) users in the system at any level. This means a Spark (Webex Teams) user without a corresponding UCM user. |
integer |
Public Sector |
Flag that indicates if the Customer has been flagged as a public sector customer. |
boolean |
Inactive Billing |
Flag that indicates if the Customer’s licenses should be billed - used for test customers. |
boolean |
Standalone Analog Ports (No UCM User) |
Number of Analog phones at the site level in the system that are not assigned to a Subscriber. |
integer |
Standard Users with Spark |
Number of Subscribers with multiple devices, other services (e.g VM and/or WebEx) and Spark (Webex Teams) service. |
integer |
DEVICE/SERVICE |
DESCRIPTION |
DATA TYPE |
|---|---|---|
MS Teams (No Voice) |
Number of Microsoft Teams users under the Customer who do not have Enterprise Voice enabled. |
integer |
MS Teams & Voice |
Number of Microsoft Teams users under the Customer with Enterprise voice service enabled. |
integer |
MS Teams & Voice & Exchange |
Number of Microsoft Teams users with Enterprise voice service enabled and with MS Exchange mailbox under the Customer. User is in Azure AD and licensed. |
integer |
MS O365 User (no Teams) |
Number of Microsoft Office 365 users without Microsoft Teams. |
integer |
Cisco and MS Integrated Service |
Number of Subscribers under the Customer with integrated Cisco and Microsoft services. (Hybrid) |
integer |
Multi-vendor Users |
Number of Subscribers under the Customer with devices from multiple vendors, e.g. Cisco and Microsoft. (excluding Hybrid) |
integer |
PexIP only |
Number of users under the Customer only provisioned with Pexip Conference service. |
integer |
Phone Server Phones |
Number of VOSS Phone Server phones set up under the Customer. |
integer |
Site Count |
Number of Sites under the Customer. |
integer |
UCM: Unified Communications Manager
UCCX: Unified Contact Center Express
UCCE: Unified Contact Center Enterprise
EM: Extension Mobility profile
VM: Voicemail
SNR: Single Number Reach
Public Sector: boolean flag on Customer to indicate public sector customer. Can be set with an API call or on the GUI Customer form.
MS O365: Microsoft Office 365
MS Teams: Microsoft Teams
Example:
#OrgID=0010O00001kPTUpQAO
#Platform ID=5e54067d116fa10046313224
#hostname=VOSS-UN-1
#Provider Name=CS-P
#Software Version=21.2
#Platform Version=21.2.0-1630252949
#Deployment Mode=Provider with HCMF
#Date Time=2021-10-30 11:53
#Audit Version=4.1.1
Provider,Reseller,Customer,Customer PKID,One Phone & Spark (No VM & No WebEx), \
One Phone (No VM & No WebEx & No Spark),One Phone & VM (No WebEx), \
One Phone & WebEx,Multiple Phones,Users With More Than 10 Phones, \
UCM User (No Phone & No EM & No VM & No WebEx & No SNR & No Spark), \
SNR (No Phone & No EM & No VM & No WebEx & No Spark), \
VM (No Phone & No EM & No WebEx),WebEx (No Phone & No EM), \
Spark (No Phone & No EM & No SNR & No VM & No WebEx), \
EM & Spark (No Phone & No VM & No WebEx), \
EM (No Phone & No SNR & No VM & No WebEx & No Spark), \
EM & SNR (No Phone & No VM & No WebEx & No Spark), \
EM & VM (No Phone & No WebEx),EM & WebEx (No Phone), \
Standalone Phones (No UCM User),Standalone WebEx (No UCM User), \
Standalone Voicemail (No UCM User),Contact Center Enterprise, \
Contact Center Express,Standalone Spark (No UCM User),Public Sector, \
Inactive Billing,Standalone Analog Ports (No UCM User), \
Standard Users with Spark,MS Teams (No Voice),MS Teams & Voice, \
MS Teams & Voice & Exchange,MS O365 User (no Teams), \
Cisco and MS Integrated Service,Multi-vendor Users,PexIP only, \
Phone Server Phones,Site Count
Provider_01,Reseller_01,Customer_01,6197a2522f7ab2c5dbb8f2aa,3,6,2,6,13,3,6,4,4,2,5,3,4,6,7,6,5,2,3,2,2,12,Y,Y,4,0,0,0,0,0,0,0,0,0,2
Provider_01,Reseller_01,Customer_02,6197a2572f7ab2c5dbb8f2fc,0,4,6,7,0,0,0,0,0,1,4,1,1,2,1,3,2,1,1,1,1,8,Y,N,2,0,0,0,0,0,0,0,0,0,1