select agent.id ,agent.description, agent.className, agent.enableAccessControl , agent.authoritativeSource,
agent.enableAttributeMapping, agent.enableObjectTriggers, p.tenant.name
from com.soffid.iam.model.AgentDescriptorEntity agent
left join agent.plugin as p
where p.id=:id