Query to get Request Details with Group change info and Technician Timespent info
Build: 10609 Database: MSSQL OUTPUT : SELECT "wo"."WORKORDERID" AS "Request ID", LONGTODATE("wo"."CREATEDTIME") AS "Created Time", LONGTODATE("wo"."RESOLVEDTIME") AS "Resolved Time", "cri"."FIRST_NAME" AS "Created By", "aau"."FIRST_NAME" AS "Requester",
Query to get SLA escalation time difference for each request.
Version:10609 DB:PGSQL OUTPUT: SELECT wo.WORKORDERID AS "Request ID", LONGTODATE(wo.CREATEDTIME) AS "Open date", pd.PRIORITYNAME AS "Priority", std.STATUSNAME AS "Request Status", qd.QUEUENAME AS "Group", ti.FIRST_NAME AS "Technician", LONGTODATE(wos.LAST_TECH_UPDATE)
Query to get Project details and Worklog timespent details of Project
Version : 10602 DB: MSSQL Output : Query : SELECT "projectdet"."PROJECTID" AS "Project id", "projectdet"."TITLE" AS "Project NAME", "ad"."ORG_NAME" AS "Account", "projectestimations"."TOT_TASKHOURS_COST" AS "Actual Cost", "projectdet"."ACTUALENDTIME"
IT analytics in 90 seconds: Track finances across all accounts in an MSP help desk
Track the bill information of your managed customer accounts using the Bill Details report in Analytics Plus. If you're not already using Analytics Plus, get started with your free, 30-day trial today:
Worklog Queries for various modules
Worklog Queries Database : PGSQL Request Charges SELECT COALESCE(wtk.WORKORDERID , wo.workorderid) "Request ID", CASE WHEN (tk.TASKID) IS NOT NULL THEN (wo2.TITLE) ELSE (wo.TITLE) END "Title",cast((ct.TIMESPENT/1000 * interval '1 second') as varchar) "Time Spent",to_timestamp((ct.createdtime)/1000)::TIMESTAMP "Time Spent Created Time", rctd.FIRST_NAME "Time Spent Technician" FROM ChargesTable ct LEFT JOIN WorkOrderToCharge wotoc ON ct.CHARGEID=wotoc.CHARGEID LEFT JOIN WorkOrder wo ON wotoc.WORKORDERID=wo.WORKORDERID
Reporting on emails sent by technician?
I have built a report to provide a listing of notes added to requests in the past 7 days, but have identified a gap where emails sent via the system are not recorded. How can I report on emails a given technician sends? Incase it helps anyone else, here
Receiving the twice the report email from the schedule.
Hi , We are receiving twice email with one attaching the report subject "Report" and other with no report to attach subject "No data available to generate report" . Please suggest any fix for this.
Assigned date for the current engineer
I want a MS SQL query to show me the assigned date for the current engineer for every ticket, MangeEngine version is 10.5, Build 10530.
[Free e-book] Kick-start hyperautomation with AI-powered service management
Did you know that you can save anywhere between 10-50% of IT costs with automation? Also, employees can save between 10-40% of their time by automating manual, laborious, and repetitive tasks. IT service processes are abundant with such repetitive tasks
[Free e-book] 5 reasons why your analytics initiatives are failing and how to fix them using AI
Gartner predicts that 80% of analytics initiatives will fail by 2022. Don't let your business initiatives be one of them. Download our e-book to learn how AI-driven analytics can put your organization on the fast track to success.
Need a Technician and Group combined report
Hi I need a report that lists all technicians and also every group they belong to. So a simple report. A Technician would be listed on multiple lines if they are in more than one Support Group: Technician Name Support Group Technician Name
All request + SLA report
Hi, I need a report that lists all request and how many of these that violate SLA. SQL database Thanks
[Free e-book] Six strategies to eliminate costly inefficiencies in your IT service processes
An organization's IT department is its powerhouse. However, IT can still be affected by service outages, service performance issues and inefficiencies. Discover how advanced analytics for IT service management can provide visibility into IT services,
Survey Report Total Count
I'm looking for a way to get a total count of surveys sent so I can compare that to surveys received. I have made a report which can give me all the information I need regarding surveys that were responded to but nothing on how to find out how many surveys
Report of technician last login and quantity of login
Hi I wonder if we can have a report (SDP MSP) that shows the last login of the technicians configured and alslo the quantity of logins performed during a period of time (month, quarter and year). Thanks in advance.
SLA details report (Service Desk Plus MSP)
Hi. I wonder if there is a query for SDP MSP that can provide me a reporte with all the details of the SLAs configured in the tool? Appreciate your help.
Report From Tasks whose status has changed over the past month
HI Friends I Need a Report From Tasks whose status has changed over the past month. how can i do it? What is the appropriate query for this report? Report columns: Task Title , status , technician , status changed by , status changed in (Time) My SDP
[Webinar alert] Is your IT team ready for the hybrid work model?
Hybrid work—a combination of remote work and work-from-office—is becoming the norm for several organizations. This presents a unique set of challenges for the IT teams, who have to prepare to tackle these new challenges and ensure efficient service desk
worklog
75 / 5000 Translation result I need a report of all the worklogs of all modules (request, task, project,....) I am looking to get this data for a specific range - Daily, Weekly, Monthly, etc. i am ver: msp 10510 database : mssql server
[Free e-book] Back to work: An IT admin's guide
As employees begin to return to the office, organizations need to adapt to the requirements of new-age workers. Read our e-book to learn how to transform your workplace to keep up with changing dynamics. Download now.
How to report from approved timesheet
Hi, I need a view to see all approved timesheet or approved work logs in SDP MSP. What should I do? Thanks for helping
Technician Leave report
Query select au.first_name "Technician", ltd.name "Leave type", longtodate(du.leavedate) "Leave date" from techunavailability ta left join aaauser au on au.user_id=ta.technicianid left join leavetypedefinition ltd on ltd.leavetypeid=ta.leavetypeid left join dateunavailability du on du.leaveid=ta.leaveid where du.leavedate >= <from_thisquarter> and du.leavedate <= <to_thisquarter> order by 1 Krishna Bharat ServiceDesk Plus - MSP Support team.
[Free e-book] 7 real-life IT problems and how to solve them using advanced analytics
Did you know that advanced analytics can help you resolve 70 percent of your help desk problems? Download our e-book to learn how.
Need a report to show me tickets that have been idle for xx days
I would like to know if there is a way to create a report that looks for any tickets that haven't been auctioned for a period of time, say 4 days, and notifys somone. Note that I am specifically NOT referring to the SLA prompts Response, or Resolution. A ticket may well be assigned to a tech, who then sits on his hands and does nothing with it for a few days. I want to know well before the 3 hours SLA clock in the dashboard comes around. Thanks! PS, can someone actually moderate and approve this
[E-book] 10 secret strategies to supercharge IT reporting
Hey there! Far too often critical insight goes unseen and unused without the right reporting strategies. Download our e-book to discover reporting strategies and learn how to build reports that fuel growth.
Contract Billing Issue
I have a contract billing configure with an allowance of 60 hour. It configure with the option "Deduct only Operational Hours from allowance", it mean I only want to deduct the hour of service given from 8am to 6pm (this is configure well in MSP Operational
Unexpected behavior when filtering Archived requests on Account
What we want to do: Filter archived requests on <Account name>. Expected behavior: List all archived requests with <Account name>. Actual behavior: List all archived requests that has a requester where the requester is in account with <Account name> Result:
Resolved within 24 hours report
Hello, I have been trying to search for a report that shows this: Created: last year Account XYZ Group: ABC Request typ: Incident Resolved within 24h from the request created ( NOT Time Elapsed ) Sound simple, just find the right search words. Your
Actual Time Spent Reports
Hi, Hope you are doing well. How can I get the excel version of the report of the mentioned data?
Power Bİ
Hi, İs getting report with Power Bİ possible according no service common fields? For example, if "Report name" field are used only "Bİ" service kategory. Can we get report according "Report name" by using Power BI?
Query Report on Contract Billing
Good morning, We are in the live implementation of an Manage Engine Service Desk Plus ITSM solution. We attempt to purchase 25 agent licenses + the service catalogue module by the end of this month. A big challenge at the moment, is the fact that the
[Free E-book] 6 help desk hacks to reduce your ticket volume
An ever-increasing pile of IT tickets can be intimidating for any service desk. Regardless of whether these tickets were created over time or were the result of a massive outage, our list of curated hacks can help you reduce your ticket volume.
Reports
Hi, How do I run a report that shows me how long my team spent working on each ticket? Also are there a centralized place were I can locate training on how to navigate the system? Thank you -Keila
First day of week
Hello, How can I change the first day of week?. When I select "Last Week" in report it take from Sunday to Saturday, I wand to change this from Monday to Sunday. Thanks,
Technician Report Needed
Hi I need a simple report that lists all Technicians and the Groups they belong to.
Postgre Query to get Account manager for account
Hi! Can you help us? We're want to get, with Postgres query or with API query, an Account manager for provided Account.
SQL query to surveys
Hello I would like to know if I can query de surveys schema and which tables and columns I have to use to get the records. thanks for your help.
[Free e-book] Guide to data democratization
Hello folks, We're delighted to bring you our latest e-book, Guide to data democratization. In this e-book, we discuss the challenges faced by enterprises in handling the deluge of data coming in, and suggest several helpful frameworks for democratizing data to facilitate data-driven decision-making.
Report for Requests Open longer than 7 days
Hi I am trying to get a report that can be scheduled that will show all open requests that are still open and were created over 7 days a go. Can anyone help with this query: SELECT ti.FIRST_NAME AS "Technician", ti.FIRST_NAME AS "Technician", wo.WORKORDERID AS "Request ID", sdo.NAME AS "Site", aau.FIRST_NAME AS "Requester", longtodate(wo.CREATEDTIME) AS "Created Time", longtodate(wos.LAST_TECH_UPDATE) AS "Last Update Time", std.STATUSNAME AS "Request Status", wo.TITLE AS "Subject" FROM WorkOrder
Task Report
Hi I have Service Desk Plus - MSP v 8.2 with PS-SQL data base.. I would like to make Task report which show all tasks (not only tasks related to requests) with the following details: task ID Task owner task description task status task % of completion task created date task created by
Next Page