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
Login Frequency Query Report
The below report would help us find the last logged in time of the users in SCP 11.0 SELECT AaaUser.FIRST_NAME "Technician", MAX(AaaLogin.NAME) "LoginName", MAX(AaaContactInfo.EMAILID) "Email", MAX(AaaAccSession.USER_HOST) "IP ...Change the default font-size and font-family while sending emails from SCP
Kindly try the following steps below, Access the database and initiate the query below select * from globalconfig where category = 'rta'; It will list out the global config categories and from the list check for the globalconfigid for font -size and ...Exporting and importing requests in SCP using xls format
Step 1 : Generate a report as xls file * Go to Reports module and choose New Custom report, select Requests module and proceed to the report wizard. * Select the required fields (columns) and run the report. You might choose the Request ID as well, ...SCP upgrade from 11.0 to 14.0 prerequisites
Before migration to scp version 14 below 2 points has to be done in scp 11027 1. Back up password should not be default i.e SCP123!, it should be updated 2. TLSv1, TLSv1.1 has to be added under the file /home/jre/lib/security/java.security file ( ...Query Report to find the Contract details in SCP 11.0
SELECT ad.ORG_NAME AS "Account", ac.CONTRACTNAME AS "Contract Name", ac.CONTRACTNO AS "Contract Number", ( case when sp.PLANTYPE like 'Charge Per Hour' then concat(cast(((bc.consumedunits/(1000))/(60*60)) as varchar), ':' ...