Microsoft 365 License & Activity - User Drilldown

Microsoft 365 License & Activity - User Drilldown#

Drilldown view of a single user: license cost and utilization, Teams activity counters, and usage over time for the selected date range and datasource.

Counters

COUNTERS
Days since last activity Days since last activity Microsoft O365 Activity Summary	Monthly Cost Monthly Cost Microsoft O365 Activity Summary	Ad Hoc Meetings Organized Ad Hoc Meetings Organized Microsoft O365 Activity Summary	Potential Monthly Savings Potential Monthly Savings Microsoft O365 Activity Summary	Teams Meeting Count Teams Meeting Count Microsoft O365 Activity Snapshot History	Teams Call Count Teams Call Count Microsoft O365 Activity Snapshot History	Teams Message Count Teams Message Count Microsoft O365 Activity Snapshot History	Teams Private Message Count Teams Private Message Count Microsoft O365 Activity Snapshot History

Charts

CHARTS
Title	Type	Resource	Description
Usage Over Time	chart-line	Microsoft O365 Activity Snapshot History	Trend of Teams meetings, calls, and ad hoc meetings organized for this user over the selected range.

Text

TEXT
Title	Resource	Datasource	Fields
User Summary	Microsoft O365 Activity Summary	LXT0	User Principal Name (user_principal_name) - Select Query User Id (user_id) - Select Query Display Name (display_name) - Select Query Department (department) - Select Query Office Location (office_location) - Select Query Located At (located_at) - Grouping Count Last Activity Date (last_activity_date) - Select Query Is Account Enabled (is_account_enabled) - Select Query Recommended Action (recommended_action) - Select Query Assigned Licenses (assigned_products) - Select Query

Text Widget Content

Title

User Summary

            <div style="max-width:1100px;margin:0 auto;">
              {% set user = rows[0] if rows and rows|length > 0 else {} %}
              {# User pkid (Id) used for Manage User link, but not displayed #}
              {% if user['Id'] is defined %}
                {% set user_pkid = user['Id'] %}
              {% elif user['id'] is defined %}
                {% set user_pkid = user['id'] %}
              {% else %}
                {% set user_pkid = '' %}
              {% endif %}
              {# Manage User URL (relative, environment-agnostic) #}
              {% set manage_user_url =
                '/portal/#/admin/form/form-generic/relation%2FWebexTeamsPlace'
                ~ ';originator=dashboard'
                ~ ';pkid=' ~ user_pkid
                ~ ';type=relation%2FWebexTeamsPlace'
              %}
              {% for h in headers %}
                {% set rule = h.field.ruleName if h.field is defined and h.field.ruleName is defined else '' %}
                {% set is_id = (rule == 'id') or (h.name == 'Id') or (h.displayName == 'Id') %}
                {% set is_user_name = (rule == 'user_principal_name') %}
                {% if not is_id %}
                  {% set v = user[h.name] if user[h.name] is defined else "" %}
                  <div style="display:flex;align-items:baseline;margin:12px 0;">
                    <div style="width:220px;padding:0 30px 0 0;text-align:right;white-space:nowrap;
                                font:14px Roboto, Helvetica, sans-serif;font-weight:600;color:#000;">
                      {{ h.displayName }}{% if h.required %}<span style="margin-left:4px;font-weight:700;">*</span>{% endif %}
                    </div>
                    <div style="flex:1;font:14px Roboto, Helvetica, sans-serif;color:#000;line-height:1.4;">
                      {% if is_user_name and user_pkid %}
                        <span>{{ v if v|string != "" else "&nbsp;"|safe }}</span>
                        <a href="{{ manage_user_url }}"
                           style="margin-left:12px;font-size:14px;text-decoration:underline;">
                          Manage User
                        </a>
                      {% else %}
                        {% if h.displayName == 'Assigned Products' %}
                          {% if v is iterable and v is not string %}
                            {{ v | join(', ') }}
                          {% else %}
                            {{ v|string|replace('[', '')|replace(']', '')|replace('"', '') }}
                          {% endif %}
                        {% elif h.displayName == 'Is Account Enabled' %}
                          {{ 'Yes' if v|string == '1' else ('No' if v|string == '0' else (v if v|string != "" else "&nbsp;"|safe)) }}
                        {% else %}
                          {{ v if v|string != "" else "&nbsp;"|safe }}
                        {% endif %}
                      {% endif %}
                    </div>
                  </div>
                {% endif %}
              {% endfor %}
            </div>