SDP MSP - v14.5 Build 14507 - Email Schedule Report Error
Hello, good day, I am encountering the following error when programming an email report; upon receiving the email, the following error occurs.
Scheduled Request option
Hi team sorry, but I cannot see anymore the scheduled request option on my Admin portal, maybe is this feature moved inside other section? We used to use this feature to plan an automatic opening of request thanks I'm on 14304 thanks
Query to get Survey response info with count of number of survey given by customer
Version : 14200 DB : PGSQL OUTPUT : Query : SELECT aau.FIRST_NAME AS "Requester", ti.FIRST_NAME AS "Technician", Longtodate(srm.responsetime) AS "Responded Time", srcmt.COMMENTTEXT AS "Comments", ad.ORG_NAME AS "Account", sra.VALUE AS "Rating Value",
Query to get list of Request created from Maintenance schedule
Version : 14200 DB : MSSQL / PGSQL OUTPUT : Query : select wo.workorderid AS "Request ID", wo.title AS "Subject", wotodesc.FULLDESCRIPTION AS "Description" from pmtasktoworkorder pmtw INNER JOIN workorder wo ON pmtw.WORKORDERID=wo.WORKORDERID LEFT JOIN
Query to get Account details along with additional attributes and postal address info
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",
Query to get Status info with technician,group and timespent.
Version : 14001 DB : MSSQL OUTPUT : Query : select woa.workorderid "RequestID", wo.title "Subject", pd.priorityname "Priority", aauOwn.FIRST_NAME AS "Technician", qd.queuename AS "Group", sd1.statusname "From status", sd2.statusname "To status", longtodate(wsi.ENDTIME)
Query to get project and task along with comments
Version : 14001 DB : PGSQL OUTPUT : Query : SELECT ad.org_name AS "Account Name", pd.projectid AS "Project ID", pd.title AS "Title", LONGTODATE(pd.createdtime) AS "Project Date", pd.projectcode AS "Project Code", aa.first_name AS "Technician", taskdet.title
Query to get Request Count on hourly bases
Version : 14300 DB : MSSQL OUTPUT: Query : select case when (DATEPART(hh,dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.CREATEDTIME/1000),'1970-01-01 00:00:00'))>0 AND DATEPART(hh,dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.CREATEDTIME/1000),'1970-01-01
Query to get Group change info
Version : 14300 DB:PGSQL / MSSQL Query : SELECT wo.WORKORDERID AS "Request ID", au.FIRST_NAME AS "Created By", LONGTODATE(wo.createdtime) AS "CREATEDTIME", qd.QUEUENAME AS "Group", std.STATUSNAME AS "Request Status", ti.FIRST_NAME AS "Support Rep", LONGTODATE(si.ENDTIME)
Query to get Survey info with questions as columns and rating as values
Version : 14300 DB : MSSQL / PGSQL OUTPUT : Query : SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Request Title", ad.org_name AS "Account", qd.queuename AS "Group", aau.FIRST_NAME AS "Requester", dpt.DEPTNAME AS "Department", ti.FIRST_NAME AS "Technician",
Query to get count of conversation in request
Version : 14300 DB : PGSQL OUTPUT : Query : 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 "Status", ti.FIRST_NAME AS "Technician",
Query to get technician timespent on each contract
Version: 14200 DB : MSSQL OUTPUT : Query: SELECT "rctd"."FIRST_NAME" AS "Time Spent Support Rep", "ac"."CONTRACTNO" AS "Contract Number" , "ac".contractname AS "Contract Name", CAST((sum(ct.TIMESPENT)/3600000) AS VARCHAR(20)) +':'+CAST(((sum(ct.TIMESPENT)
Query to get Request Time Elapse calculation of service request changed to incident request.
Version : 13000 DB : PGSQL Query: SELECT wo.WORKORDERID AS "Request ID", longtodate(wo.CREATEDTIME) AS "Created Time", aau.FIRST_NAME AS "Requester", longtodate(wo.COMPLETEDTIME) AS "Closed On", ad.ORG_NAME AS "Account", rtl.TEMPLATENAME AS "Template
Query to get Request list based on created time grouped by
Version : 13000 DB : PGSQL OUTPUT: SELECT wo.WORKORDERID AS "Request ID", longtodate(wo.CREATEDTIME) AS "Created Time", aau.FIRST_NAME AS "Requester", longtodate(wo.COMPLETEDTIME) AS "Closed On", ad.ORG_NAME AS "Account", rtl.TEMPLATENAME AS "Template
Query to get Request conversation info with last updated info
Version : 14300 DB : PGSQL OUTPUT : SELECT wo.WORKORDERID "Request ID", (aau.FIRST_NAME) "Requester", (wo.TITLE) "Subject", (ti.FIRST_NAME) "Technician", LONGTODATE(wos.LAST_TECH_UPDATE) AS "Last Updated Time", lastby.first_name "Last Updated By", longtodate(wo.CREATEDTIME)
Query to get Request Ageing info.
Version : 14304 DB : PGSQL OUTPUT: SELECT LONGTODATE(wo.CREATEDTIME) AS "Created Time", wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", wo.TITLE AS "Subject", pd.PRIORITYNAME AS "Priority", std.STATUSNAME AS "Request Status", cd.CATEGORYNAME
Report grouped by month
Hello. How do I make a report in te best way in my sdp msp(version 40001) for a specific account with colums: Request ID, Subject, Technican, Created time, completed time Requst mode: Preventive maintenance The report should Sort this years preventive
Query to get Request technician shared info
Version : 14305 DB : MSSQL / POSTGRES OUTPUT: Query: select Longtodate(wosh.SHARED_TIME) "Shared Date", wo.workorderid "Request ID", aaush.FIRST_NAME "Who Shared", aau.FIRST_NAME "Technician Shared To", wosh_comment.TECHNICIAN_COMMENTS "Comments" from
Query to get Support Group info
Version : 10.6 DB : MSSQL OUTPUT : select qd.QUEUEID, qd.QUEUEDESCRIPTION, qd.QUEUENAME "Support group", ownedby.FIRST_NAME AS "Owned By", au.FIRST_NAME "Technician", qe.email "Group EMAIL" from QueueDefinition qd left join Queue_Technician qt on qd.QUEUEID=qt.QUEUEID
Query to get operational hours info based on account and site
Version : 10609 DB : MSSQL OUTPUT: select "ad"."ORG_NAME" AS "Account", "sdorg"."NAME" AS "Site", case when hop.starttime = '00:00:00' and hop.endtime = '23:59:00' then 'Yes' else 'No' END as "24 Hours (Y/N)", hop.starttime as "Start time", hop.endtime
Query to get Change info with additional date fields time difference calculation.
Version : 14000 DB : MSSQL OUTPUT: Query : Execute the below two queries 1 and 2 and get the roleids from the output and replace it in highlighted spot in query 3. 1 . select chrol.name,chrolusermap.ROLEID from changeroles chrol LEFT JOIN changeroleusermapping
Query to get CI relationship and history info
Version : 13004 DB : MSSQL / PGSQL OUTPUT: select c1.ciname as "CI Name", rel.relationship as "Relationship", c2.ciname as "CI Name 2", cih.editmode as "Mode", adp.OPERATIONSTRING as "Operation", LONGTODATE(cih.operationtime) as "Operation Time", au.first_name
Query to get Technician roles in single row
Version : 13000 DB : MSSQL OUTPUT : select auser.first_name as "TECHNICIAN", (sd.employeeid) as "Employee ID", longtodate(auser.createdtime) as "Creation Date", (SELECT STUFF(( Select ar.NAME+ CHAR(10) from PortalTechnicians pu left join AaaUser au on
Query to get Request task and worklog info
Version : 13000 DB : MSSQL OUTPUT : SELECT "wo"."WORKORDERID" AS "Request ID", "wo"."CREATEDTIME" AS "Created Time", "wo"."TITLE" AS "Subject", "wo"."DUEBYTIME" AS "DueBy Time", "wo"."IS_CATALOG_TEMPLATE" AS "Service Request", "aau"."FIRST_NAME" AS "Requester",
Query to get Technician list with associated Project Role info.
Version : 10609 DB : PGSQL OUTPUT : SELECT aaauser.First_name AS "Name", al.name "Login Name", sduser.FIRSTNAME AS "First Name", aaacontact.EMAILID AS "E-Mail", deptTable.DEPTNAME AS "Department", cisite.NAME AS "Site", projro.rolename AS "Project Role",
ServiceDesk Plus Sites Report
Is there a query or report to list all of our sites with details on them?
Query to get Announcement List and info
Version : 13002 DB : MSSQL / PGSQL OUTPUT : select ad.org_name "Account Associated", anno.TITLE "Announcement Title", LONGTODATE(anno.CREATEDDATE) "Created time", LONGTODATE(anno.DATE_TO) "End time" from announcement anno Left JOIN announcementaccountmapping
Query to get Users/Requesters list who has login.
Version : 14200 DB : MSSQL / PGSQL OUTPUT : SELECT AaaUser.USER_ID, AaaUser.FIRST_NAME "FullName", AaaLogin.NAME "LoginName", AaaLogin.DOMAINNAME "Domain", AaaContactInfo.EMAILID "Email" FROM AaaUser LEFT JOIN UserDepartment ON AaaUser.USER_ID = UserDepartment.USERID
Query to get Group hop count of request.
Version : 10524 DB : MSSQL OUTPUT : SELECT MAX("wo"."WORKORDERID") AS "Request ID", Longtodate("wo"."CREATEDTIME") AS "Created Date", "sdo"."NAME" AS "Site", "qd"."QUEUENAME" AS "Current Group", "std"."STATUSNAME" AS "Request Status", count(wohd.columnname)
Query to get Info about request technician change and changed by
Version : 14001 DB: MSSQL / PGSQL OUTPUT : SELECT wo.WORKORDERID "Request ID", (aau.FIRST_NAME) "CREATEDBY", (wo.TITLE) "Subject", (std.STATUSNAME) "Request Status", aau.FIRST_NAME AS "Changed By", auTech.FIRST_NAME as "Tech Changed From", auNextTech.FIRST_NAME
Query to get Template list with fields mapped to it and default values.
Version : 14000 DB : PGSQL OUTPUT : select sd.name "Service Catalog Name",rt.templatename "Template name",fc.field_name "Fields",fc.default_value "Field Value" from requesttemplate_list rt left join servicedefinition sd on sd.serviceid = rt.parent_service
Query to get Project and milestone timespent in same query.
Version : 10.6 DB : MSSQL OUTPUT : SELECT tpr.PROJECTID , MAX(pr.TITLE) "Title", (SELECT SUM(ct.TIMESPENT)/1000/3600 "Total Time Spent" FROM ChargesTable ct LEFT JOIN TaskToCharge tkc ON ct.CHARGEID=tkc.CHARGEID LEFT JOIN TaskDetails tk ON tkc.TASKID=tk.TASKID
Query to Request created from Mail and waiting for an Tech Reply.
Version : 14001 DB : PGSQL / MSSQL OUTPUT : SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", ad.ORG_NAME AS "Account" FROM WorkOrder wo LEFT JOIN ModeDefinition mdd ON wo.MODEID=mdd.MODEID LEFT JOIN WorkOrderAccountMapping wam ON wo.WORKORDERID=wam.WORKORDERID
Query to get Request Closure Comments added by requester.
Version : 13000 DB : MSSQL / PGSQL SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", cd.CATEGORYNAME AS "Category", scd.NAME AS "Subcategory", rtdef.NAME AS "Request Type", lvd.LEVELNAME AS "Level", std.STATUSNAME AS "Request Status", wo.CREATEDTIME
Query to get SLA and First Response voilated percentage based on account
Version : 10609 DB : PGSQL / MSSQL OUTPUT : SELECT ad.org_name "Account", count(wo.WORKORDERID) "Total Request", count(case when std.ISPENDING='0' THEN 1 ELSE NULL END) "Completed Requests" , count(case when (wos.ISOVERDUE='1') THEN 1 ELSE NULL END) "SLA
Query to get Change WorkLog
Version : 14001 DB : PGSQL / MSSQL OUTPUT : SELECT ch.CHANGEID "Change ID", ch.TITLE "Change Title", rctd.FIRST_NAME "WorkLog Owner", Longtodate(ct.TS_ENDTIME) "WorkLog END Time", ct.DESCRIPTION, chfd.UDF_DATE2 AS "Signature Date" FROM ChargesTable ct
Query to get Time calculation of request from created time to resolved / closed status
Version : 10.5 DB : PGSQL SELECT wo.WORKORDERID AS "Request ID", case when (wo.completedtime=0) then null else TO_CHAR(((wo.completedtime-wo.createdtime)/1000 || ' second')::interval, 'HH24:MI:SS') end "Completed Date - created Date", case when (wo.resolvedtime=0)
Query to get list of template name, rule name, event, conditions and actions information
Version : 13000 DB : PGSQL OUTPUT: SELECT rd.rulename "Rule Name", rd.usertype "Applies To", rd.jscode "Script", ry.ruletype "Event", rff.fieldname"Field Condition", rcm.condition_string "Condition", rcfv.fieldvalue "field value", raty.actionname "Action
Query to get Active Technician key list with Technician info.
Version : 13004 DB : PGSQL OUTPUT: select au.first_name, techkey.techniciankey, techkey.status from techniciankeydefinition techkey left join AaaLogin al on techkey.LOGIN_ID = al.LOGIN_ID Left join AaaUser au on al.user_id=au.user_id where techkey.status
[Analytics Plus webinar] How analytics-driven IT service management improves employee productivity
Hello folks, We're back with an insightful new webinar on how analytics-driven IT service management can improve employee productivity . Date and time: April 27, 2023 2pm AEST | 10am GMT | 10am PST Why attend this webinar? When faced with a plethora of
Next Page