My query was resolved by examining the activation meta data property of each Content instance.
content.metaData.isActivated or content.metaData.activationStatus eq MetaData.ACTIVATION_STATUS_ACTIVATED, ACTIVATION_STATUS_MODIFIED, ACTIVATION_STATUS_NOT_ACTIVATED ---------------------------------------------------------------- for list details see http://documentation.magnolia.info/ ----------------------------------------------------------------
