License Anonymous Customer Aggregate Data Export

This is the VOSS version of the report file without identifying customer data.

Filename: vlf_<provider_name>_<host_name>_anonymous_<YYYY-MM-DD_HHMM>.csv Layout:

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.1.1

Note

For licensing:

  • OrgID is 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

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 App) 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 App) 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 App) 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 App) 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 App) users in the system at any level. This means a Spark (Webex App) 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 App) service.

integer

DEVICE/SERVICE

DESCRIPTION

DATA TYPE

MS Teams (No Voice) 1

The PhoneSystem is not in the FeatureTypes list. If the FeatureTypes list is empty or null, that record is not counted as a license regardless of the license type.

integer

MS Teams & Voice 1

Number of Microsoft Teams users under the Customer who have PhoneSystem as FeatureType in device/msteamsonline and EnterpriseVoiceEnabled=true.

integer

MS Teams & Voice & Exchange 1

Number of Microsoft Teams users who have PhoneSystem as FeatureType in device/msteamsonline and with MS Exchange mailbox under the Customer and EnterpriseVoiceEnabled=true.

integer

MS O365 User (no Teams) 1

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
1(1,2,3,4)

Counts are only for records and users that have MS services only. In other words, no numbers are added to these columns if the same user has a Cisco service/license.

  • 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-11-19 13:11
#Audit Version=4.1.1
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
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
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

previous

Detail License Customer Aggregate Data Export

next

Licensing Destinations and Formats