Query for Support Groups and all details
We are in need of a report that displays all of our Support Group names, description, owner, technicians associated to each group and
notifications set (“New request added to group” and “left unpicked”). I was able to run the following but it does not give me technicians and notifications.
SELECT ci.CINAME "CI Name",citype.TYPENAME "CI Type",cisite.NAME "Site",ci.DESCRIPTION "Description",ImpactDefinition.NAME "Business Impact",ownedby.FIRST_NAME "Owned By" FROM SupportGroup supportgroup LEFT JOIN BaseElement baseci ON supportgroup.CIID=baseci.CIID LEFT JOIN CI ci ON baseci.CIID=ci.CIID LEFT JOIN CIType citype ON ci.CITYPEID=citype.TYPEID LEFT JOIN SDOrganization cisite ON ci.SITEID=cisite.ORG_ID LEFT JOIN ImpactDefinition ON baseci.IMPACTID=ImpactDefinition.IMPACTID LEFT JOIN AaaUser ownedby ON supportgroup.OWNEDBY=ownedby.USER_ID