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
IT analytics in 90 seconds: Tackle scope changes across projects in your MSP help desk
Master project management by tracking unplanned additions and deviations across all managed accounts using Analytics Plus reports. If you're not already using Analytics Plus, download your free, 30-day trial today.
Query Report produces error
I am trying to produce a report using a custom query and am getting an error reported through the MESD query editor. This query runs fine in a query analyser. I am using MYSQL and MESD Plus - MSP v8.1 Build 8106 and I have several other customer queries that run without issue. The query is: select wot.workorderid "Request ID", name "Site", ifnull(first_name, 'Unassigned') "Analyst", case pd.PRIORITYNAME when '1. Critical' then 'Critical' when '2. High' then 'High' when '3. Medium' then 'Medium' when
Time Sheets in Russian language
Service Desk Plus MSP 10.5 10507 Postgres (Windows) Technician Cyrillic names problem: https://drive.google.com/file/d/1L1zof0aUtnalDuyR8Q5UewWxpj8FGH4_/view?usp=drivesdk Translation missing: https://drive.google.com/file/d/15Ws8bs3u7irBq329OWJMmSCK9hJcr3Ja/view?usp=drivesdk Missing time sheets in the approval list: https://drive.google.com/file/d/1Z7sT84lYXzPzwNhGtXl4i5fKjZ9OqmKx/view?usp=drivesdk Please test this feature with Russian Language as it doesn't work properly.
Get our technicians activity report - online duration
Hi, I want to get report of online duration of our technicians with sign in and sign out time by day: for example: +------------------------------------------------------------------------------------+
| 2020-04-01 - Friday |
+-----------------+------------+---------------+----------+----------+------------+--+
| technician name | login time | sign out time | Duration | username | status | |
+-----------------+------------+---------------+----------+----------+------------+--+
|
[On-demand webinar] IT admin's guide to enabling organizational visibility
Hello folks, Sign up to watch our on-demand webinar on how IT admins can enable cross-functional visibility across the organization. During the session, we'll show you how analytics can help, Eliminate complex compliance, monitoring, and visibility issues. Efficiently unify disparate and complex business data spread across departments and functions. Provide decision-makers with a comprehensive overview via cross-functional reports and dashboards. Secure access to critical business data based on
IT analytics in 90 seconds: Ensure sustained profitability through revenue diversification in an MSP help desk
Track revenue distribution to fuel profitability in your organization using the Revenue Distribution report in Analytics Plus. If you're not already using Analytics Plus, download your free, 30-day trial today:
SQL SD + MSP query report - Average response time per account grouped by priority
Hello, I need to generate a report like the one below that I found in the community, but I need to group it by priority. Can someone help me? SELECT ad.ORG_NAME "Account",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",wo.TITLE "Subject",ti.FIRST_NAME "Technician",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.respondedTIME) "responded Time",TO_CHAR(((wo.TIMESPENTONREQ)/1000 || ' second')::interval, 'HH24:MI:SS') "Time Spent OH", TO_CHAR((((wo.respondedtime)-(wo.createdtime))/1000
SQL SD + MSP query report - Average response time per account grouped by priority
Olá, Preciso gerar um relatório como o que encontrei abaixo na comunidade, mas preciso agrupá-lo por prioridade. Alguém pode me ajudar? SELECT ad.ORG_NAME "Account",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",wo.TITLE "Subject",ti.FIRST_NAME "Technician",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.respondedTIME) "responded Time",TO_CHAR(((wo.TIMESPENTONREQ)/1000 || ' second')::interval, 'HH24:MI:SS') "Time Spent OH", TO_CHAR((((wo.respondedtime)-(wo.createdtime))/1000 || '
Unused Incident - Additional Fields or what Templates are they being used in
Is there a way of seeing what "Incident - Additional Fields" are not being used in any Incident template? Or is there a way to see what templates a particular "Incident - Additional Field" is being used in? For instance, we are trying to clean up some of our Fields to get under the maximum your software allows of 90, as well as try to find fields that could be removed safely and know what templates it is affecting. Such as if the field "Call Back Number" is removed, will it only affect one template
Reports on closed / resolved requests
Hello, We are facing issue where technicians solve easy tickets. It's good in a way but it skews the statistic. They are closing more then others. I guess I'm not alone with this problem, my idea was to create a report showing the max/min age of closed tickets closed per technicians. There are maybe some other good solution that I haven't thought of.
[Free e-book] Resolve your help desk's biggest challenges with analytics
Help desks are constantly firefighting with little or no time to look into their own problems such as staffing or technician skill. This e-book outlines a few key help desk challenges and offers actionable solutions to tackle them.
Average repports
Hello, I want to get the average time for each status of my cases per account/group. I like to get average first response time for each account. Please point me in the general direction. I'm new at creating SQL Querys.
Average response time - by date range
Hello, I'm trying to run a query to return the average response time of all tickets by technician for a sate range, in my case i need the last two years but will need to adjust this later on. I found this query below that returns the correct information for last month but I'm having trouble converting this to return data for a specific date range i.e. 2014-05-01 to 2016-05-01 We are using ServiceDesk Plus - MSP version 8.3 Build 8311 with MSSQL back end. Hoping someone can assist. select aau.first_name
ITSM analytics case study: Happiest Minds Technologies automates IT reporting using Analytics Plus
Happiest Minds Technologies, Bengaluru, India, is a leading IT services company focused on delivering seamless customer experiences across industry sectors such as retail, e-commerce, banking, insurance, IT, engineering R&D, and manufacturing. The company wanted a fully automated analytics program to gain real-time insights from an array of IT applications in a single console. The challenge was that their IT data was scattered across several IT applications and tools. The team at Happiest Minds
IT analytics in 90 seconds: Boost your MSP's revenue using customer effective rates
Identify the customers who bring in the most profit by using the Customer Effective Rate report in Analytics Plus. If you're not already using Analytics Plus, download your free, 30-day trial today:
Next Page