Call Data from LCsCDR and QoEMetrics Databases

Call data information is obtained using particular CDR and QoE Database SQL views, which are listed in the tables below. PowerSuite Agent version 1.0.17300.1 and above will obtain the SQL views marked with **. Additionally, links to Microsoft Documentation covering the details of these SQL views are provided.

CDR Data Table/ View Name	Skype for Business Details	Obfuscated Elements (optional)
SesssionDetailsView	SessionDetails view in Skype for Business	FromUri ToUri TargetUri OnBehalfOfUri ReferredByUri
VoipDetailsView	VoIPDetails view in Skype for Business	FromUri ToUri TargetUri OnBehalfOfUri ReferredByUri FromPhone ToPhone DisconnectedByUri DisconnectedByPhone
McuJoinsAndLeavesView	McuJoinsAndLeaves view in Skype for Business	UserUri
ConferencesView	Conferences view in Skype for Business	ConferenceUri OrganizerUri
ErrorReportView	ErrorReport view in Skype for Business	FromUri ToUri ConferenceUri
ConferenceSessionDetailsView	ConferenceSessionDetails view in Skype for Business	ConferenceUri McuConferenceUri UserUri OnBehalfOfUri ReferredByUri
FocusJoinsAndLeaves **	FocusJoinsAndLeaves view in Skype for Business	UserUri
ProgressReport **	ProgressReport view in Skype for Business	Not Applicable
ConferenceMessageCount **	ConferenceMessageCount view in Skype for Business	UserUri
Registration **	Registration view in Skype for Business	UserUri IpAddress DeviceMacAddress
dbo.FileTransfers **	FileTransfers table in Skype for Business Server	Not Applicable

Quality of Experience Data Table/ View Name	Skype for Business Details	Obfuscated Elements (optional)
SessionView	Session view in Skype for Business	ConferenceURI CallerPAI CalleePA CallerURI CalleeURI CallerEndpoint CalleeEndpoint
MediaLineView	MediaLine view in Skype for Business	CallerIPAddr CallerMacAddress CallerReflexiveLocalIPAddr CalleeIPAddr CalleeMacAddress CalleeReflexiveLocalIPAddr
Subnet	Subnet table in Skype for Business	Not applicable
NetworkConfigurationSettingsView	NetworkConfigurationSettings view in Skype for Business	Not applicable
FocusJoinsAndLeaves **	FocusJoinsAndLeaves table in Skype for Business Server	UserUri
ProgressReport **	ProgressReport table in Skype for Business	Not applicable
AudioClientEvent **	AudioClientEvent table in Skype for Business	Not Applicable
AudioStream **	AudioStream table in Skype for Business	Not Applicable
AudioSignal **	AudioSignal table in Skype for Business	Not Applicable
AppSharingStream **	AppSharingStream table in Skype for Business	Not Applicable
VideoClientEvent **	VideoClientEvent table in Skype for Business	Not Applicable
VideoStream **	VideoStream table in Skype for Business	Not Applicable
TraceRoute **	TraceRoute table in Skype for Business	IpAddress
CallQualityFeedback **	Not Applicable	FromURI
QoeCallDetails **	Not Applicable	ConferenceURI CallerPAI CalleePAI CallerEndpoint CalleeEndpoint CallerURI CalleeURI CallerIPAddr CallerMacAddress CallerRelayIPAddr CallerReflexiveLocalIPAddr CalleeIPAddr CalleeMacAddress CalleeRelayIPAddr CalleeReflexiveLocalIPAddr