[Index]

Model: data/DataO365ActivitySummary

DataO365ActivitySummary resource. The schema will be used to create data/ReporterResource instances, the description is used to store the table name of the associate field.

Model Details: data/DataO365ActivitySummary

Title Description Details
Has Ever Had Usage data_o365_activity_summary
  • Field Name: has_ever_had_usage
  • Type: Integer
Never Active data_o365_activity_summary
  • Field Name: never_active
  • Type: Integer
Is Account Enabled data_o365_activity_summary
  • Field Name: is_account_enabled
  • Type: Integer
Is Deleted data_o365_activity_summary
  • Field Name: is_deleted
  • Type: Integer
Is External data_o365_activity_summary
  • Field Name: is_external
  • Type: Integer
Is Licensed data_o365_activity_summary
  • Field Name: is_licensed
  • Type: Integer
Is Active data_o365_activity_summary
  • Field Name: is_active
  • Type: Integer
Is Disabled With Licenses data_o365_activity_summary
  • Field Name: is_disabled_with_licenses
  • Type: Integer
Is Teams No Usage data_o365_activity_summary
  • Field Name: is_teams_no_usage
  • Type: Integer
Is Phone System No Usage data_o365_activity_summary
  • Field Name: is_phone_system_no_usage
  • Type: Integer
Is Recent data_o365_activity_summary
  • Field Name: is_recent
  • Type: Integer
Is Inactive data_o365_activity_summary
  • Field Name: is_inactive
  • Type: Integer
Is Dormant data_o365_activity_summary
  • Field Name: is_dormant
  • Type: Integer
Has Active Issue data_o365_activity_summary
  • Field Name: has_active_issue
  • Type: Integer
Assigned Products data_o365_activity_summary
  • Field Name: assigned_products
  • Type: String
  • MaxLength: 1024
Team Chat Message Count data_o365_activity_summary
  • Field Name: team_chat_message_count
  • Type: Integer
Private Chat Message Count data_o365_activity_summary
  • Field Name: private_chat_message_count
  • Type: Integer
Call Count data_o365_activity_summary
  • Field Name: call_count
  • Type: Integer
Meeting Count data_o365_activity_summary
  • Field Name: meeting_count
  • Type: Integer
Meetings Organized Count data_o365_activity_summary
  • Field Name: meetings_organized_count
  • Type: Integer
Meetings Attended Count data_o365_activity_summary
  • Field Name: meetings_attended_count
  • Type: Integer
Ad Hoc Meetings Organized Count data_o365_activity_summary
  • Field Name: ad_hoc_meetings_organized_count
  • Type: Integer
Ad Hoc Meetings Attended Count data_o365_activity_summary
  • Field Name: ad_hoc_meetings_attended_count
  • Type: Integer
Scheduled One Time Meetings Organized Count data_o365_activity_summary
  • Field Name: scheduled_one_time_meetings_organized_count
  • Type: Integer
Scheduled One Time Meetings Attended Count data_o365_activity_summary
  • Field Name: scheduled_one_time_meetings_attended_count
  • Type: Integer
Scheduled Recurring Meetings Organized Count data_o365_activity_summary
  • Field Name: scheduled_recurring_meetings_organized_count
  • Type: Integer
Scheduled Recurring Meetings Attended Count data_o365_activity_summary
  • Field Name: scheduled_recurring_meetings_attended_count
  • Type: Integer
Has Other Action data_o365_activity_summary
  • Field Name: has_other_action
  • Type: Integer
Urgent Messages data_o365_activity_summary
  • Field Name: urgent_messages
  • Type: Integer
Post Messages data_o365_activity_summary
  • Field Name: post_messages
  • Type: Integer
Reply Messages data_o365_activity_summary
  • Field Name: reply_messages
  • Type: Integer
Report Period data_o365_activity_summary
  • Field Name: report_period
  • Type: Integer
Days Since Last Activity data_o365_activity_summary
  • Field Name: days_since_last_activity
  • Type: Integer
Optimization Candidate data_o365_activity_summary
  • Field Name: optimization_candidate
  • Type: Integer
Has Teams License Derived data_o365_activity_summary
  • Field Name: has_teams_license_derived
  • Type: Integer
Has Phone System License Derived data_o365_activity_summary
  • Field Name: has_phone_system_license_derived
  • Type: Integer
License Cost Annual Total data_o365_activity_summary
  • Field Name: license_cost_annual_total
  • Type: Number
License Cost Monthly Total data_o365_activity_summary
  • Field Name: license_cost_monthly_total
  • Type: Number
Optimization Reasons JSON array of all applicable license issue codes (disabled_with_licenses, activity_not_matched_to_msoluser, teams_no_usage, phone_system_entitled_no_usage). See license_issue_type for the single primary issue used for paired notes and recommended steps.
  • Field Name: optimization_reasons
  • Type: String
  • MaxLength: 1024
Potential Savings Monthly data_o365_activity_summary
  • Field Name: potential_savings_monthly
  • Type: Number
Potential Savings Annually data_o365_activity_summary
  • Field Name: potential_savings_annually
  • Type: Number
License Cost Monthly Total Formatted data_o365_activity_summary
  • Field Name: license_cost_monthly_total_formatted
  • Type: String
  • MaxLength: 1024
User Id data_o365_activity_summary
  • Field Name: user_id
  • Type: String
  • MaxLength: 1024
First Report Refresh Date With No Usage data_o365_activity_summary
  • Field Name: first_report_refresh_date_with_no_usage
  • Type: String
  • MaxLength: 1024
  • Format: date-time
First Teams Activity Date Earliest non-empty Teams last activity date for this user from snapshot history and current batch; empty if none. Sourced from latest snapshot history row.
  • Field Name: first_teams_activity_date
  • Type: String
  • MaxLength: 1024
  • Format: date-time
Recommended Action data_o365_activity_summary
  • Field Name: recommended_action
  • Type: String
  • MaxLength: 1024
Recommended Action Scope data_o365_activity_summary
  • Field Name: recommended_action_scope
  • Type: String
  • MaxLength: 1024
License Issue Type Primary license issue code when any apply; NULL if none. One of disabled_with_licenses, activity_not_matched_to_msoluser, teams_no_usage, phone_system_entitled_no_usage. Priority: disabled, then no MSOL match, then Teams no usage, then Phone.
  • Field Name: license_issue_type
  • Type: String
  • MaxLength: 1024
License Issue Notes Diagnostic narrative for license_issue_type; same prose as data_o365_activity_license_issues.notes for that issue. NULL when license_issue_type is NULL.
  • Field Name: license_issue_notes
  • Type: String
  • MaxLength: 1024
License Issue Recommended Steps Remediation for license_issue_type; same text as data_o365_activity_license_issues.recommended_steps for that issue. NULL when license_issue_type is NULL.
  • Field Name: license_issue_recommended_steps
  • Type: String
  • MaxLength: 1024
License Cost Annual Total Formatted data_o365_activity_summary
  • Field Name: license_cost_annual_total_formatted
  • Type: String
  • MaxLength: 1024
Audio Duration data_o365_activity_summary
  • Field Name: audio_duration
  • Type: String
  • MaxLength: 1024
Audio Duration Seconds data_o365_activity_summary
  • Field Name: audio_duration_seconds
  • Type: Integer
User Principal Name data_o365_activity_summary
  • Field Name: user_principal_name
  • Type: String
  • MaxLength: 1024
Display Name data_o365_activity_summary
  • Field Name: display_name
  • Type: String
  • MaxLength: 1024
Video Duration data_o365_activity_summary
  • Field Name: video_duration
  • Type: String
  • MaxLength: 1024
Video Duration Seconds data_o365_activity_summary
  • Field Name: video_duration_seconds
  • Type: Integer
Department data_o365_activity_summary
  • Field Name: department
  • Type: String
  • MaxLength: 1024
Job Title data_o365_activity_summary
  • Field Name: job_title
  • Type: String
  • MaxLength: 1024
Office Location data_o365_activity_summary
  • Field Name: office_location
  • Type: String
  • MaxLength: 1024
Usage Location data_o365_activity_summary
  • Field Name: usage_location
  • Type: String
  • MaxLength: 1024
Hierarchy Path data_o365_activity_summary
  • Field Name: hierarchy_path
  • Type: String
  • MaxLength: 1024
Automate Ipaddress data_o365_activity_summary
  • Field Name: automate_ipaddress
  • Type: String
  • MaxLength: 1024
Located At data_o365_activity_summary
  • Field Name: located_at
  • Type: String
  • MaxLength: 1024
Provider data_o365_activity_summary
  • Field Name: Provider
  • Type: String
  • MaxLength: 1024
Customer data_o365_activity_summary
  • Field Name: Customer
  • Type: String
  • MaxLength: 1024
Site data_o365_activity_summary
  • Field Name: Site
  • Type: String
  • MaxLength: 1024
Reseller data_o365_activity_summary
  • Field Name: Reseller
  • Type: String
  • MaxLength: 1024
Intermediate Node data_o365_activity_summary
  • Field Name: IntermediateNode
  • Type: String
  • MaxLength: 1024
Linked Site data_o365_activity_summary
  • Field Name: LinkedSite
  • Type: String
  • MaxLength: 1024
Channel data_o365_activity_summary
  • Field Name: Channel
  • Type: String
  • MaxLength: 1024
Latest Report Refresh Date data_o365_activity_summary
  • Field Name: latest_report_refresh_date
  • Type: String
  • MaxLength: 1024
  • Format: date-time
Last Activity Date data_o365_activity_summary
  • Field Name: last_activity_date
  • Type: String
  • MaxLength: 1024
  • Format: date-time
Screen Share Duration data_o365_activity_summary
  • Field Name: screen_share_duration
  • Type: String
  • MaxLength: 1024
Screen Share Duration Seconds data_o365_activity_summary
  • Field Name: screen_share_duration_seconds
  • Type: Integer
Deleted Date data_o365_activity_summary
  • Field Name: deleted_date
  • Type: String
  • MaxLength: 1024
  • Format: date-time
Tenant Display Name data_o365_activity_summary
  • Field Name: tenant_display_name
  • Type: String
  • MaxLength: 1024
Shared Channel Tenant Display Names data_o365_activity_summary
  • Field Name: shared_channel_tenant_display_names
  • Type: String
  • MaxLength: 1024
License Cost Currency data_o365_activity_summary
  • Field Name: license_cost_currency
  • Type: String
  • MaxLength: 1024
License Cost Monthly By Bucket data_o365_activity_summary
  • Field Name: license_cost_monthly_by_bucket
  • Type: String
  • MaxLength: 1024
Buckets List Csv data_o365_activity_summary
  • Field Name: buckets_list_csv
  • Type: String
  • MaxLength: 1024
License Cost Monthly By Sku data_o365_activity_summary
  • Field Name: license_cost_monthly_by_sku
  • Type: String
  • MaxLength: 1024
License Friendly Names data_o365_activity_summary
  • Field Name: license_friendly_names
  • Type: String
  • MaxLength: 1024
Teams Activity Status data_o365_activity_summary
  • Field Name: teams_activity_status
  • Type: String
  • MaxLength: 1024
Teams Usage Level data_o365_activity_summary
  • Field Name: teams_usage_level
  • Type: String
  • MaxLength: 1024