query hardware changes
Hi, I want to know when removed or changed ram, harddisk, board or another else from workstations. do you send me a query for this? there have a report for this which name is Audit history by hardware changes but there are very details on it and no show query button. just i want to what physical hardware changed, which workstation and when?
Tabular Report, Excel Export, Date Format not compatible
Hi, When exporting tabular reports the date format is: DD-MM-YYYY This format is not compatible with Excel. IS there a w ay to change the Tabular report to export in an Excel Date friendly format? Thanks
Within MSP 14910 export of Reports as PDF idles with Window Export Configuration Checker
Hello, we upgraded from 14610 -> 14840 -> 14910 recently (linux) and discovered issue with exporting Reports/Job sheets/... as PDF. Reports including statistical graphics won't be exported as pdfs, whereas reports including tables will. Our Testsystem
[Free e-book] The handbook for MSPs to achieve profitability
Hello folks, We're excited to share with you our latest e-book that focuses on nine critical metrics for MSPs to achieve profitability in challenging economic times. In this e-book, you'll discover metrics that can give you multiple perspectives into
Custom Report - Two Date Filters
I am in need of a report that will show me everything that was either Created last week or Resolved last week for a specific technician. I am not seeing where I can select both the "Created Time" and "Resolved Time" for a report. I'm left with one or
Unable to generate Report: SDP 14.9 Build 14940
When I try to generate report I get below error: This is for advance matrix reports and for Tabular matrix report Please I need help
Report on Deleted Requests
I need to create a report that shows deleted requests and who deleted them. Is that possible? I can see them in the System Logs, but not sure how to pull that data out. Thanks!
Technicians Auto Assigned to Multiple Accounts, Sites
Shortly after creating a new account recently (this may be coincidence) we had a report from one of our customer technician groups that they were suddenly able to see all accounts and all sites of other customers, not simply their own. There doesn't seem
5 capabilities every IT team should adopt for survival [Free whitepaper]
Hello there, In an era of unprecedented digital transformation, survival of the fittest has never rung more true. To remain competitive, organizations must adapt to changing trends and adopt AI's diverse capabilities for operational sustainability and
Need report showing servers and relationships to business service and environemnt
How can I create a list of servers with their relationships to Business Services and Environments? For example: CI Name CI Type Business Service Environment
Request Conversation
I'am trying to get conversations related to requests using the below query but the latest date is 29-03-2023 any idea why ? select c.workorderid "Request ID", cond.conversationid "Conversation ID", 'Incoming' "Conversation type", DATEADD(s,datediff(s,getutcdate(),getdate())+(c.createdtime/1000),'01-01-1970')
Reporting Query
Hi Guys, We are trying to generate a report so we can look at tickets logged monthly + time spent on the ticket. The attached is a great start showing our monthly tickets and which category they are in as a bar chart. How would I: 1 – Include time spent
Tickets opened by hour by site query
I'd like to change the following query to do by site instead of by group. Is that possible? I am running ManageEngine ServiceDesk 14.5 with sql database. SELECT qd.QUEUENAME AS "Group", YEAR(dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (workorder.CREATEDTIME/1000),'1970-01-01
Query
I am seeking assistance with locating the relevant data within a PostgreSQL database to broadcast the number of open tickets on my site’s support section. Specifically, I need to identify the database schema or table that contains the information about
Can I generate a report on the number of tasks generated by tickets
Hi, I am able to get a report each day / month for the number of requests that come in. Some tickets have say 10 tasks assigned. I need to report on how many tasks were generated each day / month. How can that be done in SDP?
Report All tickets for a given requester
I am trying to get a report for a specific user on demand using ALL tickets, open or closed to discover trends of issues based on users. I however cannot seem to get it. I can show all tickets, then search by requester and the one I was trying showed
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
ServiceDesk Plus Sites Report
Is there a query or report to list all of our sites with details on them?
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)
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 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 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 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",
Next Page