PKS Telemetry Data Dictionary

	A	B	C	F
9
10	Table Name			Description
11	PKST_EVENTINFO			Table of Generic Metrics for PKS Events
12
13
14	Metric Name	Type	Example values	Description
15	id	string	d364cff4-4d48-4d4a-9b25-9e066c4d4394	unique row id
16	cloud_provider	string	vSphere, GCP, AWS	name of cloud provider PKS is deployed on
17	customer_number	string	1234-123aa-1234bb	VMWare Account Number or Pivotal Customer Number if user selects enhanced level of participation
18	environment_provider	string	raas-pipeline	This is a hidden field, not available to customers. It is only used by engineering and sales teams to self identify as not a customer. Values "none", "raas-pipeline" at the moment.
19	event	string	api_started, create_cluster, create-cluster-end	name of event
20	installation_purpose	string	demo_or_poc	Purpose of installation of thie tile, it can be one of these choices: demo_or_poc, dev_or_pre_prod, prod, not_provide_info
21	participation_level	string	standard	Levels of Participation in PKS Customer Experience Improvement Program (CEIP) and Telemetry program, enhanced, standard, or none
22	product_version	string	1.4.1-build.4	version of PKS
23	vcenter_id	string	adcdf4a7-bd35-4ca4-b55b-8d2c1fb8d0c2	vcenter uuid
24
25
26
27
28
29	Table Name			Description
30	PKST_EVENTINFO_PKST_API_STARTED			Table of Metrics for PKS API Started Events
31
32
33	Metric Name	Type	Example values	Description
34	id	string	d364cff4-4d48-4d4a-9b25-9e066c4d4394	UUID
35	authentication_mode	string	service_account	Method of authentication used (Service account vs OIDC)
36	c_advisor	string	Yes	Describes whether the cAdvisor is deployed
37	control_plane_ephemeral_disk	bigint	65536	Size of ephemeral disk for the control plane
38	control_plane_instances	bigint	2	Number of instances of the control plane
39	control_plane_persistence_disk	bigint	10240	Size of persistence disk for the control plane
40	control_plane_ram	bigint	8192	Size of memory for the control plane
41	http_proxy	string	Disabled	Whether https proxy is used, enabled/disabled
42	ldap_referral_strategy	string	follow	Values "follow" / "ignore"/"exception"
43	log_sink_resources_enabled	boolean	true	describes whether the log sink resource is enabled
44	max_worker_vms_in_flight	bigint	10	Max number of worker VMs that can be created at a time
45	metric_sink_resources_enabled	boolean	true	Enable the cluster metric sink
46	network	string	flannel	Describes whether the installation uses Flannel or NSX-T for Networking
47	oidc_groups_claim	string	roles	Describes the --oidc-groups-claim flag set on the kube-api server.
48	oidc_groups_prefix	string	oidc:groupname	Describes the --oidc-groups-prefix flag set on the kube-api server.
49	oidc_username_claim	string	user_name	Describes the --oidc-username-claim flag on the kube-api server.
50	oidc_username_prefix	string	oidc:username	Describes the --oidc-username-prefix flag on the kube-api server.
51	outbound_internet_access_enabled_for_k8s	boolean	true	Describes whether outbound internet access is enabled
52	pkst_eventinfo__fk	string	d364cff4-4d48-4d4a-9b25-9e066c4d4394	fk to parent table PKST_EVENTINFO
53	stemcell_version	string	ubuntu-xenial 315.64	Describes the stemcell in use by the PKS API
54	syslog	string	disabled	logging enabled/disabled
55	timestamp	timestamp	2019-07-21T00:15:49Z	Timestamp
56	uaa_user_account_store	string	internal	"internal" or "external"
57	vrli	string	disabled	vRealize integration, "enabled" or "disabled"
58	wavefront	string	disabled	Wavefront integration, "enabled" or "disabled"
59
60
61
62
63
64	Table Name			Description
65	PKST_EVENTINFO_PKST_API_STARTED_PLANS			Table of PKST Plan Properties Selected to Start PKS API
66
67
68	Metric Name	Type	Example values	Description
69	id	string	e01adc56-5234-4f35-bdb7-0acebefb0f83	unique row id
70	admission_plugins	string	"["pod_security_policy", "deny_escalating_exec", "security_context_deny"]"	Describes whether the PodSecurityPolicy, DenyEscalatingExec, and  SecurityContextDeny admission plugins are enabled
71	allow_privileged_containers	boolean	FALSE	boolean, describes whether privileged containers are allowed
72	disable_deny_escalating_exec	boolean	FALSE	boolean, describes whether to enable/disable exec and attach cmds to pods that run with escalating privileges
73	enable_windows_workers	boolean	FALSE	boolean, describes whether windows workers are enabled
74	errand_vm_type	string	micro	"micro", "small", "medium", "large", "xlarge", "xxlarge" and some other similar variants
75	kubelet_drain_delete_local_data	boolean	FALSE	Describes whether drain should continue even if there are pods using emptyDir (local data that will be deleted when the node is drained). Equivalent to kubectl drain --delete-local-data.
76	kubelet_drain_force	boolean	FALSE	Describes whether drain should continue even if there are pods not managed by a ReplicationController, ReplicaSet, Job, DaemonSet or StatefulSet. Equivalent to kubectl drain --force.
77	kubelet_drain_force_node	boolean	FALSE	Force node to drain even if pods are still running after timeout.
78	kubelet_drain_grace_period	bigint	10	Pod Shutdown Grace Period (seconds) min: -1, max: 86400
79	kubelet_drain_ignore_daemonsets	boolean	FALSE	Drain should continue even if there are pods managed by a daemonset. Equivalent to kubectl drain --ignore-daemonsets.
80	kubelet_drain_timeout	bigint	10	The time in minutes that a node will attempt to drain pods before giving up. Must be a valid integer between 0 and 1440. 0 sets the timeout to infinite.
81	kubelet_eviction_hard	boolean	FALSE	If all pods fail to drain on the worker node during the timeout,the node will forcibly terminate remaining pods and continue with upgrade or scale operation.,USE WITH CAUTION
82	kubelet_system_reserved	boolean	FALSE	Reserve Compute Resources for System Daemons. Enter a comma separated list of parameters e.g memory=250Mi, cpu=150m
83	master_persistent_disk_type	string	10240	permitted integer values for plan persistent disk, from 1 GB to 32 TB
84	master_vm_type	string	medium.disk	"micro", "small", "medium", "large", "xlarge", "xxlarge" and some other similar variants
85	max_number_of_worker_instances	bigint	50	An integer describing the maximum nr of worker instances
86	name	string	Plan-4	plan name; the users are able to name the plan themselves
87	number	bigint	4	order in which the plans appear in PKS CLI
88	number_of_master_instances	bigint	3	Self descriptive, an integer
89	number_of_worker_instances	bigint	5	Self descriptive, an integer
90	pkst_eventinfo_pkst_api_started__fk	string	e01adc56-5234-4f35-bdb7-0acebefb0f83	FK into the pkst_eventinfo_pkst_api_started table
91	state	string	Plan Inactive	"Plan Active", "Plan Inactive"
92	worker_persistent_disk_type	string	51200	Size of worker disk
93	worker_vm_type	string	medium.disk	"micro", "small", "medium", "large", "xlarge", "xxlarge" and some other similar variants
94
95
96
97
98
99	Table Name			Description
100	PKST_EVENTINFO_PKST_CREATE_CLUSTER			Table of start events for the PKS create cluster operation
101
102
103	Metric Name	Type	Example values	Description
104	id	string	195b7176-e074-48e9-a4ce-76f5c0e48843	unique row id
105	cluster_id	string	4efb779d-1d69-4372-895a-00f0987f601b	id of cluster
106	number_of_masters	bigint	1	number of master nodes
107	number_of_workers	string	1	number of worker machines
108	operation_id	string	8e7037a0e1f110d90e76b8431f744a9c64433314abdd73232353f9fa658b2343	unique ID for this PKS operation, hashed string