Detail License Customer Aggregate Data Export#

This is the partner view of the data that includes customer details for better understanding.

Filename:

License Super Patch version 4.1.11 and older:

vlf_<provider_name>_<host_name>_detailed_legacy_<YYYY-MM-DD_HHMM>.csv

License Super Patch version 5.0.0:

vlf_<provider_name>_<host_name>_detailed_<YYYY-MM-DD_HHMM>.csv

Metadata: header rows showing for example the date time stamp, version and licensing information, prefixed by a #, for example:

#OrgID=0010O00001kPTUpQAO
#Platform ID=5e54067d116fa10046313224
#hostname=VOSS-UN-1
#Provider Name=CS-P
#Software Version=21.4
#Platform Version=21.4.0-1630252949
#Deployment Mode=Provider with HCMF
#Date Time=2022-11-19 13:11
#License Token=[Token or <license-token-not-found>]
#License Expiry=[Date-time or <license-expiry-not-found>]
#Audit Version=4.1.5

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.

Fields that are additional in detailed reports:

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

For a detailed description of the fields, see: Licensing Audit Details.

Examples:

License Super Patch version 4.1.11 and older:

#OrgID=0010O00001kPTUpQAO
#Platform ID=5e54067d116fa10046313224
#hostname=VOSS-UN-1
#Provider Name=CS-P
#Software Version=21.4
#Platform Version=21.4.0-1630252949
#Deployment Mode=Provider with HCMF
#Date Time=2022-11-19 13:11
#License Token=[Token or <license-token-not-found>]
#License Expiry=[Date-time or <license-expiry-not-found>]
#Audit Version=4.1.5
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

License Super Patch version 5.0.0:

#OrgID=42
#Platform ID=65421bc70b9bb5b66d48c714
#hostname=python
#Provider Name=Provider_01
#Software Version=19.1.2.001
#Platform Version=19.1.2-001
#Deployment Mode=Provider with HCMF
#License Token=<license-token-not-found>
#License Expiry=<license-expiry-not-found>
#Date Time=2023-11-20 08:57
#Audit Version=5.0.0
Provider,Reseller,Customer,Customer PKID,User Licenses,Cisco and MS Integrated Services,Standalone Devices,Meeting Rooms,Voss Phone Servers,Sites
Provider_01,Reseller_01,Customer_02,6544be240c82f662ed230b79,30,0,0,0,0,1
Provider_01,Reseller_01,Customer_01,6544be260c82f662ed230ba1,72,4,0,0,3,2