import info.magnolia.context.MgnlContext
import info.magnolia.jcr.util.PropertyUtil

import javax.jcr.Node
import javax.jcr.Property
import javax.jcr.query.Query

session = MgnlContext.getJCRSession("users")
session.getWorkspace().getQueryManager()
        .createQuery("SELECT * FROM [mgnl:user] AS user WHERE ISDESCENDANTNODE('/admin') AND user.timezone IS NOT NULL", Query.JCR_SQL2)
        .execute()
        .nodes
        .forEachRemaining((Node node) -> {
            Property property = PropertyUtil.getPropertyOrNull(node, "timezone")
            if (property != null) {
                println "Removing " + property
                property.remove()
            }
        })
//session.save() //uncomment this when satisfied with list of properties to remove