Dynamic Group Code for Viva Communities

Viva Engage Communities are ran by Microsoft 365 Groups that are using PowerShell scripts to query certain aspects of an AD Object.

NOTE: For Shared Accounts and/or Labourers, ensure that the Department Field in Active Directory is blank.

Dynamic Groups allow the auto enrollment of members without the need of someone needing to add or remove them from a group. The following query was used for each of the Viva Engage Memberships:

All Staff ACT:

(user.department -eq "ACT") and (user.accountEnabled -eq TRUE) or (user.jobTitle -contains "ICT") or (user.jobTitle -contains "Director") -and -not (user.jobTitle -eq "Project Director") or (user.jobTitle -eq "National Business Manager") or (user.jobTitle -eq "Marketing & Business Development Coordinator") or(user.jobTitle -eq "Human Resources Manager")

All Staff NSW:

(user.department -eq "NSW") and (user.accountEnabled -eq TRUE) or (user.jobTitle -contains "ICT") or (user.jobTitle -contains "Director") -and -not (user.jobTitle -eq "Project Director") or (user.jobTitle -eq "National Business Manager") or (user.jobTitle -eq "Marketing & Business Development Coordinator") or(user.jobTitle -eq "Human Resources Manager")

All Staff QLD:

(user.department -eq "QLD") and (user.accountEnabled -eq TRUE) or (user.jobTitle -contains "ICT") or (user.jobTitle -contains "Director") -and -not (user.jobTitle -eq "Project Director") or (user.jobTitle -eq "National Business Manager") or (user.jobTitle -eq "Marketing & Business Development Coordinator") or(user.jobTitle -eq "Human Resources Manager")

All Staff VIC:

(user.department -eq "VIC") and (user.accountEnabled -eq TRUE) or (user.jobTitle -contains "Director")

All Staff Arete:

(user.department -eq "Arete") and (user.accountEnabled -eq TRUE) or (user.jobTitle -contains "ICT") or (user.jobTitle -contains "Director") -and -not (user.jobTitle -eq "Project Director") or (user.jobTitle -eq "National Business Manager") or (user.jobTitle -eq "Marketing & Business Development Coordinator") or (user.jobTitle -eq "Human Resources Manager")

Construction Administration All Company:

(user.jobTitle -contains "Contract") and (user.accountEnabled -eq TRUE) or (user.jobTitle -contains "ICT") or (user.jobTitle -contains "Director") or (user.jobTitle -eq "National Business Manager") or (user.jobTitle -eq "Marketing & Business Development Coordinator") or (user.jobTitle -eq "Human Resources Manager") or (user.jobTitle -contains "Pre-Con") or (user.jobTitle -eq "Project Coordinator") or (user.jobTitle -eq "Clinical Interface Manager") or (user.jobTitle -eq "Construction Manager") or (user.jobTitle -eq "Cadet") or (user.jobTitle -contains "General Manager") or (user.jobTitle -eq "Construction Supervisor")

Construction All Company

(user.jobTitle -contains "ICT") or (user.jobTitle -contains "Director") or (user.jobTitle -eq "National Business Manager") or (user.jobTitle -eq "Marketing & Business Development Coordinator") or (user.jobTitle -eq "Human Resources Manager") or (user.jobTitle -contains "General Manager") or (user.jobTitle -contains "Cadet") or (user.jobTitle -eq "Clinical Interface Manager") or (user.jobTitle -eq "Commercial Manager") or (user.jobTitle -eq "Construction Manager") or (user.jobTitle -contains "Contract") or (user.jobTitle -contains "Contracts") or (user.jobTitle -contains "Design") or (user.jobTitle -contains "Director") or (user.jobTitle -contains "Foreman") or (user.jobTitle -contains "Project Engineer") or (user.jobTitle -eq "Head of Safety Operations") or (user.jobTitle -contains "HSE") or (user.jobTitle -contains "HSEQ") or (user.jobTitle -contains "Site Manager") or (user.jobTitle -contains "Leading Hand") or (user.jobTitle -contains "National Systems Manager") or (user.jobTitle -contains "Operations Manager") or (user.jobTitle -contains "Operations Manager") or (user.jobTitle -contains "Post Construction Manager") or (user.jobTitle -contains "Pre-Construction") or (user.jobTitle -contains "Pre Construction") or (user.jobTitle -contains "Project Coordinator") or (user.jobTitle -contains "Project Manager") or (user.jobTitle -contains "Safety Manager") or (user.jobTitle -contains "Engineer") or (user.jobTitle -contains "Work Health and Safety") or (user.jobTitle -contains "Engineer") or (user.jobTitle -contains "Services Manager") or (user.jobTitle -contains "WHS") or (user.jobTitle -contains "Yard")

Design and Engineering All Company