CsActiveUser* reports

Important: These reports are deprecated as of January 29, 2018. We recommend that you use the Microsoft Graph Skype for Business activity reports instead.

The CsActiveUser* REST URIs provide summary statistics about the number of Office 365 Lync Online active users during the report period. To be counted, each user must have been logged in and using the peer-to-peer or conference resources during the report period. There are four reports that use the same overall structure, and differ only in the time interval over which they summarize the data: daily, weekly, monthly and yearly. For simplicity, the four reports are detailed in this one topic.

Applies to: Office 365

REST URIs

https://reports.office365.com/ecp/reportingwebservice/reporting.svc/CsActiveUserDaily[?ODATA options]
https://reports.office365.com/ecp/reportingwebservice/reporting.svc/CsActiveUserWeekly[?ODATA options]
https://reports.office365.com/ecp/reportingwebservice/reporting.svc/CsActiveUserMonthly[?ODATA options]
https://reports.office365.com/ecp/reportingwebservice/reporting.svc/CsActiveUserYearly[?ODATA options]

Fields

The following fields can be specified in $select, $filter and $orderby ODATA2 query options. All fields are returned if no $select option is provided.

*WCF Type refers to the .NET Framework data type assigned to the field when you create a Windows Communications Framework (WCF) Service Reference in Visual Studio. The EDM Type refers to the ADO.NET Entity Data Model (EDM) types returned in Atom-formatted reports.

**[In/Out]: For more information, see the Input parameters and report output columns section.

Remarks

To be included in the reported numbers of active users, the organization user must attend sessions or conferences logged in to the Office 365 organization user account, from a computer running the Lync client. Similarly, "guest" participants are not included in the report data.

Conference participants who were attending via mobile devices such as phones or tablets are not included in the report. For this reason, if all the participants in a conference use mobile devices, that conference won't show up in the report.

The conference times returned include time spent in only conferences that were organized by a user of the organization. Because different Lync Online plans might not include the ability to organize conferences, but may still have the ability to participate in them, the number of conferences organized within that tenant could feasibly always return zero.

Each entry in the report includes several fields of metadata. For more information, see Common metadata returned by the Office 365 Reporting web service.

The four report types differ only in the amount of time that each report entry covers. The time reported in the Date field represents the end of the time period. Dates and times are reported in the time zone specified in the HTTPS GET X-timezone header. If no time zone is specified, UTC time is used. The time durations reported are calculated in the following manner.

Examples

The following request and response pair demonstrates how to retrieve a report listing the number of active Lync users per week.

https://reports.office365.com/ecp/reportingwebservice/reporting.svc/CsActiveUserWeekly?
    $select=Date,ActiveUsers&
    $format=Json

{
    "d":
      {
        "results":
          [
            
              {
                "__metadata":
                  {
                    "id":"https://reports.office365.com/ecp/ReportingWebService/Reporting.svc/CsActiveUserWeekly(datetime'2013-05-05T00%3A00%3A00')",
                    "uri":"https://reports.office365.com/ecp/ReportingWebService/Reporting.svc/CsActiveUserWeekly(datetime'2013-05-05T00%3A00%3A00')",
                    "type":"TenantReporting.CsActiveUserReport"
                  },
                "Date":"\/Date(1367712000000)\/",
                "ActiveUsers":"5"
              },
            
              {
                "__metadata":
                  {
                    "id":"https://reports.office365.com/ecp/ReportingWebService/Reporting.svc/CsActiveUserWeekly(datetime'2013-05-12T00%3A00%3A00')",
                    "uri":"https://reports.office365.com/ecp/ReportingWebService/Reporting.svc/CsActiveUserWeekly(datetime'2013-05-12T00%3A00%3A00')",
                    "type":"TenantReporting.CsActiveUserReport"
                  },
                "Date":"\/Date(1368316800000)\/",
                "ActiveUsers":"5"
              },
            
              {
                "__metadata":
                  {
                    "id":"https://reports.office365.com/ecp/ReportingWebService/Reporting.svc/CsActiveUserWeekly(datetime'2013-05-19T00%3A00%3A00')",
                    "uri":"https://reports.office365.com/ecp/ReportingWebService/Reporting.svc/CsActiveUserWeekly(datetime'2013-05-19T00%3A00%3A00')",
                    "type":"TenantReporting.CsActiveUserReport"
                  },
                "Date":"\/Date(1368921600000)\/",
                "ActiveUsers":"3"
              }
          ]
      }
  }

The following request and response pair demonstrates how to retrieve the daily count of active Lync users, for the days between May first and May 15th, 2013, in reverse-chronological order. This query requests the Date and ActiveUsers count, and requests the information in Atom format. Line breaks were added to the request and response for clarity.

https://reports.office365.com/ecp/reportingwebservice/reporting.svc/CsActiveUserDaily?
  $select=Date,ActiveUsersCount&
  $filter=Date%20ge%20datetime'2013-05-01T00:00:00'%20and%20Date%20le%20datetime'2013-05-15T00:00:00'&
  $orderby=Date%20desc&
  $format=Atom

<?xml version="1.0" encoding="utf-8"?>
<feed xml:base="https://reports.office365.com/ecp/ReportingWebService/Reporting.svc/" 
    xmlns="http://www.w3.org/2005/Atom" 
    xmlns:d="https://schemas.microsoft.com/ado/2007/08/dataservices" 
    xmlns:m="https://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
  <id>https://reports.office365.com/ecp/reportingwebservice/reporting.svc/CsActiveUserDaily</id>
  <title type="text">CsActiveUserDaily</title>
  <updated>2013-06-25T19:01:23Z</updated>
  <link rel="self" title="CsActiveUserDaily" href="CsActiveUserDaily" />
  <entry>
    <id>https://reports.office365.com/ecp/ReportingWebService/Reporting.svc/CsActiveUserDaily(datetime'2013-05-14T00%3A00%3A00')</id>
    <category term="TenantReporting.CsActiveUserReport" scheme="https://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <title />
    <updated>2013-06-25T19:01:23Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:Date m:type="Edm.DateTime">2013-05-14T00:00:00</d:Date>
        <d:ActiveUsers m:type="Edm.Int64">5</d:ActiveUsersCount>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reports.office365.com/ecp/ReportingWebService/Reporting.svc/CsActiveUserDaily(datetime'2013-05-13T00%3A00%3A00')</id>
    <category term="TenantReporting.CsActiveUserReport" scheme="https://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <title />
    <updated>2013-06-25T19:01:23Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:Date m:type="Edm.DateTime">2013-05-13T00:00:00</d:Date>
        <d:ActiveUsers m:type="Edm.Int64">5</d:ActiveUsersCount>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reports.office365.com/ecp/ReportingWebService/Reporting.svc/CsActiveUserDaily(datetime'2013-05-10T00%3A00%3A00')</id>
    <category term="TenantReporting.CsActiveUserReport" scheme="https://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <title />
    <updated>2013-06-25T19:01:23Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:Date m:type="Edm.DateTime">2013-05-10T00:00:00</d:Date>
        <d:ActiveUsers m:type="Edm.Int64">5</d:ActiveUsersCount>
      </m:properties>
    </content>
  </entry>
</feed>

Input parameters and report output columns

The [In/Out] indicators in the fields table have the following meanings:

• Fields marked [In] in the fields table are primarily intended for use in $filter=, $orderby= and other query options that restrict which entries the report returns. Fields marked [In] in the fields table can be included the $select= option, and they will appear in the report entries, but they will contain no useful data.

• Fields marked [In/Out] in the fields table can be used in both column selection ($select=) and entry restriction ($filter= and $orderby=) options. When you include one of these fields in the $select= option, they will appear in the report entries, and will contain useful data when it is available.

Compatibility

The CsActiveUserDaily, CsActiveUserWeekly, CsActiveUserMonthly, and CsActiveUserYearly reports were introduced in Office 365 service version 2013-V1. For more information about versioning, see Versioning in the Office 365 Reporting web service.

Corresponding PowerShell cmdlets

The CsActiveUser* reports return the same information as the Get-CsActiveUserReport Windows PowerShell cmdlet.

Permissions

The account you access the reports from must have administrative permissions in that Office 365 organization. If the report is present in the service description document and the $metadata document returned to the user, then they have permissions to retrieve the data from the REST web service. This report requires the user to be assigned to the View-Only Recipients Role. In the default Office 365 permissions structure, users with the following administrator permissions can access this report: billing administrator, global administrator, password administrator, service administrator, and user management administrator.

Data granularity, persistence, and availability

Information available through these reports can be separated into one-day periods, starting at midnight of the time zone reported by the calling application in the HTTP X-timezone header.

The information for this report is available for a period of one year, or until the subscription is cancelled.

Events may be delayed by up to 24 hours before they appear in a report.