Version : 14201

DB : PGSQL / MSSQL

OUTPUT :

Query :

select ad.ORG_NAME As "Account",
org.description AS "DESCRIPTION",
ad.LOGIN_WEBURI AS "LOGIN WEB URL",
ad.LOGIN_URI AS "LOGIN URI",
ad.SUPPORT_EMAIL AS "SUPPORT EMAIL",
ad.SENDERNAME AS "SENDER NAME",
imdef.NAME AS "Business Impact",
inattr.ATTRIBUTENAME AS "ATTRIBUTENAME",
inattr.ATTRIBUTEVALUE AS "ATTRIBUTEVALUE",
post.COUNTRY AS "Country/Region",
post.DOOR_NO AS "Door",
post.STREET AS "STREET" from PortalAccounts pa
LEFT JOIN AccountDefinition ad on pa.ACCOUNTID = ad.ORG_ID
LEFT JOIN SDOrganization org ON ad.ORG_ID = org.ORG_ID
LEFT JOIN ci ci on pa.ciid = ci.ciid
LEFT JOIN instanceattributes inattr on ci.ciid = inattr.ciid
LEFT JOIN BaseElement be on ci.ciid = be.ciid
LEFT JOIN ImpactDefinition imdef on be.IMPACTID = imdef.IMPACTID
LEFT JOIN SDOrgPostalAddr org_post ON org.ORG_ID=org_post.ORG_ID
LEFT JOIN AaaPostalAddress post ON org_post.POSTALADDR_ID=post.POSTALADDR_ID