Queries for the ProjectActivity table

  • Article

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 != "5b5a146c-eba8-46af-96f8-e31b50d15a3f"
| summarize count() by UserId, ResultStatus