Query to export conversations in SCP 8.1 (incoming and outgoing emails)
select notification.notificationid, notify_workorder.workorderid, notification.notificationtitle, notificationtodescription.notificationdescription from notification left join notificationtodescription on notification.notificationid = notificationtodescription.notificationid left join notify_workorder on notificationtodescription.notificationid=notify_workorder.notificationid
select conversation.conversationid, conversation.workorderid, conversation.title, conversationdescription.description from conversation left join conversationdescription on conversation.conversationid=conversationdescription.conversationid
select conversation.conversationid, conversation.workorderid, conversation.title, conversationdescription.description from conversation left join conversationdescription on conversation.conversationid=conversationdescription.conversationid
New to ADSelfService Plus?
Related Articles
Query to show total number of conversations, incoming and outgoing conversations (MSSQL & PGSQL)
Tested in build PGSQL (14300) and MSSQL (14306) Total Number of Conversations: SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", pd.PRIORITYNAME AS "Priority", aau.FIRST_NAME AS "Requester", ad.ORG_NAME AS "Account", std.STATUSNAME AS ...Incoming and Outgoing conversations with Attachment name and location (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) PGSQL & MSSQL: Incoming: (Referred as 'Conversations' in the database) select conv.conversationid "Conversation ID", conv.workorderid "Request ID", wo.title "Request Subject", aaau.first_name "Sender", ...Account based outgoing mail sever settings post build 14001
ACCOUNT-BASED OUTGOING MAIL SERVER FEATURE: Introduction: Account-based outgoing mail server feature was introduced in build 14001. This feature ensures that users receive notifications and responses from the specific email address associated with ...Outgoing EWS issue: The value indicated for the parameter "incomingEwsUrl" is not valid"
The issue happens with the outgoing mail server settings All the fields in the outgoing setting are configured properly and then when you try to save the settings an error pops up as below. The error is the value indicated for the parameter incoming ...SQL Query to export request details
Supported only for SQL DB(14201 build). Executed in SQL DB directly to export the requests. Below query to export requests for one account / site. SELECT "wo"."WORKORDERID" AS "Request ID", "wo"."TITLE" AS "Subject", "wotodesc"."FULLDESCRIPTION" AS ...