problem with business rules and default requester template
I have a problem. I have set of bussiness rules and it's work ok but i modify the default requester template with which the client generates their requester and now some rules don´t work. it seems the template had not been modified.
Site name instead of SLA name
Hi! Looks like there is a GUI bug, so Site name is displayed instead of SLA name at SLA list (see screenshots).
Technician support hierarchy
Query select ad.Org_name"Account",sdo.name "Site", qd.queuename "Group", au.first_name "Technician" from queue_technician qt left join aaauser au on au.user_id=qt.technicianid left join queuedefinition qd on qt.queueid=qd.queueid left join sdorganization sdo on sdo.org_id=qd.siteid left join accountsitemapping asm on asm.siteid=qd.siteid left join accountdefinition ad on ad.org_id=asm.accountid order by 1,2 Krishna Bharat ServiceDesk Plus - MSP team
Custom Report not working
I am trying to create a report that calculates "travel time" start and end. This is a custom field added to a work log. I want to calculate the sum of this column but cannot see and option. here is my query can anyone help? SELECT rctd.FIRST_NAME "Time Spent Technician",wo.WORKORDERID "Request ID",ct.CREATEDTIME "Time Spent Created Time",rctd.FIRST_NAME "Time Spent Technician",aau.FIRST_NAME "Requester",wo.COMPLETEDTIME "Completed Time",ct.TIMESPENT "Time Spent",ct.TOTAL_CHARGE "Time Spent Total_Charge",wlf.UDF_DATE1
New report with IP Address
Dear, we need new query report for all assets details with IP Address. Regards, Sharif Masarweh
Report using Last Update date
I am trying to run this report however I get the error "only select statements can be used". Can you please help? SELECT ti.FIRST_NAME "Technician",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",cd.CATEGORYNAME "Category",ti.FIRST_NAME "Technician",sdo.NAME "Site",longtodate(wos.LAST_TECH_UPDATE) "Last Update Time" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID
Project Worklog Report per Technician
Howdy, I'm looking for a weekly report that I can run on SDP + PGSQL. I looking for a daily breakdown of worklogs per technician so I can see what work has been achieved this week. Accounts and tasks would be a bonus. Thanks Greg.
Want a empty space as default setting for Empty fields in Reports
WIthin reports of SDP-MSP, there is a custom setting to allow you to pick whatever value you would like for empty fields. However, the one logical value one would want, you cannot do....at least not with the version I am using which is 8106...yes, I know, old. There HAS to be a way to put a blank space in the column if there is no value. Can someone give me some ideas of what to try? I do not want "Empty" or "Blank" or "none" or "Null"...I want "". Thanks MIke
역삼립카페〖ＯＰＢＯＮＤＡ.ＣＯＭ〗영등포립카페〖오피뷰〗죽전립카페
역삼립카페〖ＯＰＢＯＮＤＡ.ＣＯＭ〗영등포립카페〖오피뷰〗죽전립카페 역삼립카페〖ＯＰＢＯＮＤＡ.ＣＯＭ〗영등포립카페〖오피뷰〗죽전립카페 역삼립카페〖ＯＰＢＯＮＤＡ.ＣＯＭ〗영등포립카페〖오피뷰〗죽전립카페 역삼립카페〖ＯＰＢＯＮＤＡ.ＣＯＭ〗영등포립카페〖오피뷰〗죽전립카페 역삼립카페〖ＯＰＢＯＮＤＡ.ＣＯＭ〗영등포립카페〖오피뷰〗죽전립카페 역삼립카페〖ＯＰＢＯＮＤＡ.ＣＯＭ〗영등포립카페〖오피뷰〗죽전립카페 역삼립카페〖ＯＰＢＯＮＤＡ.ＣＯＭ〗영등포립카페〖오피뷰〗죽전립카페 역삼립카페〖ＯＰＢＯＮＤＡ.ＣＯＭ〗영등포립카페〖오피뷰〗죽전립카페 역삼립카페〖ＯＰＢＯＮＤＡ.ＣＯＭ〗영등포립카페〖오피뷰〗죽전립카페 역삼립카페〖ＯＰＢＯＮＤＡ.ＣＯＭ〗영등포립카페〖오피뷰〗죽전립카페 역삼립카페〖ＯＰＢＯＮＤＡ.ＣＯＭ〗영등포립카페〖오피뷰〗죽전립카페 역삼립카페〖ＯＰＢＯＮＤＡ.ＣＯＭ〗영등포립카페〖오피뷰〗죽전립카페 역삼립카페〖ＯＰＢＯＮＤＡ.ＣＯＭ〗영등포립카페〖오피뷰〗죽전립카페 역삼립카페〖ＯＰＢＯＮＤＡ.ＣＯＭ〗영등포립카페〖오피뷰〗죽전립카페 역삼립카페〖ＯＰＢＯＮＤＡ.ＣＯＭ〗영등포립카페〖오피뷰〗죽전립카페
Account Details
Query SELECT accountdefinition.org_name, accountdefinition.support_email, accountdefinition.sendername, accountdefinition.login_uri, aaacontactinfo.emailid, aaacontactinfo.landline, aaacontactinfo.mobile, aaacontactinfo.fax, aaacontactinfo.web_url, aaacontactinfo.res_phone, aaapostaladdress.door_no, aaapostaladdress.street, aaapostaladdress.location, aaapostaladdress.landmark, aaapostaladdress.city, aaapostaladdress.postalcode, aaapostaladdress.state,
Color Code
Can we change chart colours for reports from ME ?
Report
Hi! I'm trying to understand the Reportdesign and QueryEditor for the Progress version of MSP. I've designed a Report that shows all the reported time spent grouped by Technician. Now I would like to redesign the query so it... Only shows current Technician (whos running the repport) reported time Sorts the output by date descending Only shows the last 7days So, I tried opening the report in the Query editor. Directly after opening it it shows the Query that I think the report is based on (as shown
How to comment a line on a SQL Query under Query Reports.
Hi, Is there a way to comment a line on a Query Report inside the aplication? The normal SQl does not work /* */ or -- does not work. Vitor.
Project timespent and charges report
Report: Database : PGSQL select pdet.projectid "Project ID", pdet.title "Project Name ", pst.statusname "Status", acdef.org_name "Account Name ", au.first_name "Owner Name", longtodate(pdet.scheduledstarttime) "Scheduled Start Time", longtodate(pdet.scheduledendtime) "Scheduled End Time" , longtodate(pdet.actualstarttime) "Actual Start Time ", longtodate(pdet.actualendtime) "Actual End Time", pest.estimatedhours "Estimated Hours", cast((sum(cgt.timespent)/1000 * interval '1 second') as varchar)
Blank column exporting report in excel
Hi we have this problem, empty columns inserted between data column when report exported, see the attached screenshot Build: MSP 8.2 Thankyou Michele Edit: could depend on joined cells, see for example "Time Spent" column, all rows are joined cells of J and K colums
SQL Reporting with a date of today
Hi I have a several custom reports which for example show how many calls each technician has updated today. The SQL query for this is shown below. We also use SQL reporting services to display a wallboard of automatically refreshed query results. If I copy the SQL query below at use it to form the basis of a Dataset in SQL Reporting Services I can create the requred table, however because the date is coded in the query, the same query can not be used for more than one day. Can you give me any advise
Report based on worklog
I need to track my technicians time by the day. When they have a ticket open for a week for example, they may put 1 hour in the worklog each day before closing the ticket. I want a report that will track the time spent each day and on what tickets. The timespent reports, even modified are very misleading. What seems to happen is when I pull a report, it will show the created date of the ticket and the time spent on the ticket, but in the above example, it will show 5 hours on the ticket open date,
report for Customer Account - uninstalld and installed programs
Can you help rewrite this query? I would like to select a customer account from the drop down menu Account: and for selected Account execute the report (for all Client compiuters) It would be good to see additional column "Last logged in user" select si.workstationname 'COMPUTER',swl.softwarename 'PROGRAM', LONGTODATE(ah.audittime) 'AUDIT',(Case ao.operationstring when 'Delete' then 'UNINSTALLED' when 'Insert' then 'INSTALLED' when 'Update' then 'CHANGE' end) 'ACTION' from audithistory ah left
Hourly Request Summary per day
Database : MSSQL Query SELECT 'Inbound' "Status", COUNT(CASE WHEN datepart(hh,dateadd(s,createdtime/1000,'1970-01-01 00:00:00'))=1 THEN 1 ELSE NULL END) '1 AM', COUNT(CASE WHEN datepart(hh,dateadd(s,createdtime/1000,'1970-01-01 00:00:00'))=2 THEN 1 ELSE NULL END) '2 AM', COUNT(CASE WHEN datepart(hh,dateadd(s,createdtime/1000,'1970-01-01 00:00:00'))=3 THEN 1 ELSE NULL END) '3 AM', COUNT(CASE WHEN datepart(hh,dateadd(s,createdtime/1000,'1970-01-01 00:00:00'))=4 THEN 1 ELSE NULL END) '4 AM', COUNT(CASE
Problem Worklog report
Database : MSSQL Query : SELECT pr.problemid "Problem ID",max(pr.title) "Subject" ,max(prs.rootcause) "Root Cause",longtodate(max(pr.reportedtime))"Created Time", CONVERT(varchar, sum(ct.timespent/1000) / 3600) + ':' + RIGHT('0' + CONVERT(varchar,sum(ct.timespent/1000) % 3600 / 60), 2) + ':' + RIGHT('0' + CONVERT(varchar, sum(ct.timespent/1000) % 60), 2) "Time Spent in Hrs",max(au.first_name) "Technician" FROM chargestable ct inner join problemtocharge ptc ON ct.chargeid=ptc.chargeid LEFT JOIN problem
ME SDP MSP Not able to update task status from tasks list
Hello, In ME SDP, if you go to the Tasks tab of a Request, you can do two things: 1. Update any piece of information, including status, right from the list by clicking on the row column. 2. Tick the checkbox and select an action from the Action drop-down on top In ME SDP MSP both of these are not possible despite that there is a checkbox before each row. So is that a bug or am I missing something? Thank you P.S. I tried this with the online demo.
Add sites thru Servlet API - not get format for Time zone
Hi, I'm a registered customer but i share this question because i believe is not a easy one. I need to add 900 sites to Service desk Plus MSP, I was able to do it by Servlet API but all without time zone. For all of them all fields are ok but time zone is not set. I need to add them with this time zone: (GMT) Western European Time(Portugal)* Looking at database table i find that this combo box field is a composed field so i try other values: TIMEZONEID GMTOFFSET DISPLAYNAME
Filter Report by custom Account Field
Hi - I have decided to not use contract billing in SDP MSP at this time. Instead, I run a report on the first of the month for the previous month's work log. I have added an additional Pick List Account field to set billing type for an account, and would like to modify the report query to filter the report and only show accounts with a specific account type. I've found the fields in actablecolumns (ATTRIBUTE_301) but not sure how to add the additional WHERE to filter on this field in the following
Report for Contracts module
Hey Guys, I have been fighting the query tool. I am attempting to extract a report that contains contracts by name that are about to expire, I was going to use a 60-90 day lead time to catch them before they expire. It seems the date info is stored as an integer that looks like came from LONGDATE. I cant seem to convert it back?? I keep getting data truncation errors. Any help is greatly appreciated. Thanks
Latest Public Notes query report
I have the following query report which runs fine, however I want to remove the column "Last Notification Date", but I can't figure out what needs to stay and what needs to be removed just to get rid of that column. SELECT max(ad.ORG_NAME) "Account", max(wo.WORKORDERID) "Request ID", max(aau.FIRST_NAME) "Requester", max(cd.CATEGORYNAME) "Category", max(scd.NAME) "Subcategory", max(wo.TITLE) "Subject", max(ti.FIRST_NAME) "Technician", max(std.STATUSNAME) "Request Status", longtodate(max(nt.NOTIFICATIONDATE))'Last
Manage Engine MSP Report on Calls by Resolved Time per Customer Per Month
We are wanting to produce a report on the number a calls a specific customer closes per month but instead of using the default field Closed Time (Which I still want to include in the report) I want to add the Time a call was Resolved. Requirements Need the Reports to be shown for a specific Customer, To show CallID, Requester, Subject, Created Date, Resolved Time Closed Time Grouped by Priority and Sorted by Resolved Time. Do you have a query that will be able to assist me with this.
I want to run a report on all tickets with all information (especially tickets with multiple technicians comments)
I understand it will take a little while to run but that's ok. When I run the kitchen sink report now I get a lot of information, about 5Mb worth in .csv but not nearly all the data fields/metada that I can see when looking at the individual ticket. This is a work dictated request and ticket history is of high importance. I haven't found any solution on my own after several hours of work.
Pending request
I need pending report by percent. Is it possible?
Android App login error "Login Failed No input data for creating request"
- Have generated technician key - Have tried using IP address - Am using https - Not using domains - Version : 8.2 Build 8203 - Tried on different tablets - Tried with different technician logins
Surveys not answered
Database : ANY Use the below query under Report tab--> New Query Report SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",aaacontact.EMAILID "Email" FROM surveyperrequest sr LEFT JOIN workorder wo ON wo.WORKORDERID=sr.WORKORDERID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN AaaUserContactInfo aaausercontact ON aau.USER_ID=aaausercontact.USER_ID LEFT JOIN AaaContactInfo aaacontact ON aaausercontact.CONTACTINFO_ID=aaacontact.CONTACTINFO_ID
Group field in MSP
Hi, I am wanting urgently to get the 'Group' field you would normally find in the All Requests report module to be available in a Change report i am generating but i am having issues when trying to get the right query. Any ideas?
Account and Site SQL Report
Do you have a query to list list all Sites grouped by Account? I am trying to do some quality checks before going live and want to check the quality of my imports and data entry.
Service template and Approver mapping
Query SELECT servicedefinition.NAME "Service Category", requesttemplate_list.TEMPLATENAME "Service template", accountdefinition.ORG_NAME "Account", aaauser.FIRST_NAME "Approver" FROM requesttemplate_list LEFT JOIN servicedefinition ON (requesttemplate_list.PARENT_SERVICE = servicedefinition.SERVICEID) LEFT JOIN servicetempaccmapping ON (servicetempaccmapping.TEMPLATEID = requesttemplate_list.TEMPLATEID) LEFT JOIN escalateton ON (servicetempaccmapping.ESCALATETOID = escalateton.ESCALATETOID)
Service templates and SLA
Query SELECT servicedefinition.NAME "Service Category", requesttemplate_list.TEMPLATENAME "Service template", sladefinition.SLANAME "SLA", accountdefinition.ORG_NAME "Account", slaescalation.LEVEL "SLA escalation LEVEL", aaauser.FIRST_NAME "Escalate TO" FROM requesttemplate_list LEFT JOIN serviceslaaccmapping ON (requesttemplate_list.SLAID = serviceslaaccmapping.SLAID) LEFT JOIN accountdefinition ON (serviceslaaccmapping.ACCOUNTID = accountdefinition.ORG_ID) LEFT JOIN sladefinition ON (serviceslaaccmapping.SLAID
Last updated notes and reply
Query SELECT wo.WORKORDERID "Request ID",max(aau.FIRST_NAME) "Requester",max(dpt.DEPTNAME) "Department",max(rtdef.NAME) "Request Type",max(cd.CATEGORYNAME) "Category",max(scd.NAME) "Subcategory",max(wo.TITLE) "Subject",max(ti.FIRST_NAME) "Technician",longtodate(max(wo.DUEBYTIME))"DueBy Time",max(std.STATUSNAME) "Request Status",longtodate(max(nt.NOTIFICATIONDATE))'Last Notification date', max(nt.NOTIFICATIONDESCRIPTION)'Last Notification', (select longtodate(max(note.NOTESDATE)) from Notes note where
Russian characters on iOS devices
Hello! I have a problem with display russian characters in request on my ipad. Thank you.
Worklog details summed
Query SELECT wo.WORKORDERID "Request ID",max(qd.QUEUENAME) "Group",max(ti.FIRST_NAME) "Technician",max(aau.FIRST_NAME) "Requester",max(wo.TITLE) "Subject",max(wo.DESCRIPTION)"Description",SUM(rc.MM2COMPLETEREQUEST)/3600000 "Sum of Time Elapsed in HRS",sum(rc.amount)"Amount" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID
Work log details
Database: MYSQL/MSSQL/PGSQL Query SELECT wo.WORKORDERID "Request ID",wo.TIMESPENTONREQ/3600000 "Time Spent",qd.QUEUENAME "Group",rc.MM2COMPLETEREQUEST/3600000 "Time Elapsed",rc.AMOUNT "Amount",longtodate(rc.DATETIME) "Cost entry date",longtodate(rc.EXECUTEDTIME) "Executed Time",rctd.FIRST_NAME "Technician",ti.FIRST_NAME "Assigned Technician",scd.NAME "Subcategory",icd.NAME "Item",wo.TITLE "Subject",rc.DESCRIPTION "Time Spent Description",wotodesc.FULLDESCRIPTION "Description",aau.FIRST_NAME "Requester",sdo.NAME
Report which shows the response time overdue and resolution time overdue
Database : MSSQL SELECT wo.WORKORDERID "Request ID",sdo.NAME "Site",qd.QUEUENAME "Group",ti.FIRST_NAME "Technician",rtdef.NAME "Request Type",pd.PRIORITYNAME "Priority",urgdef.NAME "Urgency", longtodate(wo.FR_DUETIME) "Response DueBy Time", longtodate(wo.DUEBYTIME) "DueBy Time", (case when wos.IS_FR_OVERDUE='1' then 'True' else 'False' end) "First Response Overdue Status", (case when wos.IS_FR_OVERDUE='1' then (case when wo.respondedtime is NULL then datediff(hh,dateadd(s,wo.FR_DUETIME/1000,'1970-01-01
Resolved time Query
Database : MYSQL Execute the below query under Report tab--> New Query Report SELECT wo.WORKORDERID "Request ID",cd.CATEGORYNAME "Category",scd.NAME "Subcategory",icd.NAME "Item",wo.TITLE "Subject",cri.FIRST_NAME "Created By",ti.FIRST_NAME "Technician",serdef.NAME "Service Category",pd.PRIORITYNAME "Priority",sinfo.WORKSTATIONNAME "Workstation",std.STATUSNAME "Request Status",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.COMPLETEDTIME) "Completed Time", (select from_unixtime(woh.operationtime/1000)
Next Page