Note: This content is automatically generated by the ETL tool. Last build time is 2024-03-19 13:44:37. Please contact MWS Insights Data Infrastructure for the query.

CurrentEmployee

Data source: 1es

cluster('1es.kusto.windows.net').database('HeadTrax').Person
| where CurrentlyEmployed
| project AadTenantId, AadObjectId, Alias, Department, DisplayName, EmailAddress, FullName,
JobTitle, JobTitleName, JobTitleSummary, StandardTitle, OrganizationAliasHierarchy
| extend PartitionKey = hash(strcat(AadObjectId,AadTenantId), 5)
| project-away PartitionKey