Queries for the ProjectActivity table

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

MS Project events filtered by organization ID

Display events from more than one day ago, filtered by organization ID and summarized by user ID and result status.

ProjectActivity
| where OrganizationId != "22223333-cccc-4444-dddd-5555eeee6666"
| summarize count() by UserId, ResultStatus