Query Report -- Multiple metrics per technician
Greetings all! I would like to create a combination report, one that covers the following: INCIDENTS: - incidents past due (Only Open or In-progress status) - incidents coming due (Only Open or In-progress status) - Critical priority incidents not modified for 2 days (Not closed, resolved status) - High priority incidents not modified for 4 days (Not closed, resolved status) - Medium priority incidents not modified for 2 weeks (Not closed, resolved status) SERVICE REQUESTS: - service requests past
Solutions Report with Keywords
I use the following report to review our solutions (clean up and reviews), but I would like to add a column for the solutions keywords field. Can this field be added the query below please? SELECT solution.solutionid "Solutionid" , KB_Topics.TOPICNAME " Topic",Solution.TITLE "Subject ",solutioninfo.noofhits "Views",Creator.FIRST_NAME "Created By",longtodate(SolutionInfo.CREATEDTIME) "Created Time",Updater.FIRST_NAME "Last Modified By",longtodate(SolutionInfo.LASTUPDATEDTIME) "Last Modified Time",Sol_StatusDefinition.STATUSNAME
Report
Hello, I need to create report as below: Request ID \ Group \ Requester \ Category \ Technician \ Request Status \ Discussion Notes Thanks!
Report for Problems, Changes and Projects
Hi team, I want have a report with this query but for Problems, Changes and Projects. SELECT wotask.TITLE "Request Title",wotask.WORKORDERID "RequestID",(taskdet.TASKID) "Task ID",(taskdet.TITLE )"Title", (taskcreatedby.FIRST_NAME) "Created By", (taskowner.FIRST_NAME) "Owner",(taskdet.PER_OF_COMPLETION) "Percentage Of Completion", longtodate(taskdet.CREATEDDATE) "Created Date", wotask.TITLE "Request Title", longtodate(taskdet.SCHEDULEDSTARTTIME) "Scheduled Start Time", longtodate(taskdet.SCHEDULEDENDTIME)
Report containing the time spent by members of a project
Good afternoon I need your help. I need to generate a report showing how many projects are involved and how long an individual is employed. Also a report showing the comparative of the planned advance against the actual status of a project. Thank you
Custom query Tickets not updated before last 3 months?
Dear SD colleagues, I build a query via the wizard in "All Requests" as seen below. When trying to edit this query in the query window, I only get error message: "Java.lang.Exception: Only select queries can be executed". We use SD Plus 9.0 build 9045 with Microsoft SQL 2008 R2. I would like to list tickets from predefined sites, technicians and groups which have been NOT updated for more than 3 months from now. "LAST_TECH_UPDATE" is longer than 3 months. How can I do that with the below query? SELECT
Scheduled report running under Technician who has left
We have a number of Technicians who schedule reports. These reports cannot be seen unless you are logged in as the Technician and you go to the Showing: Scheduled Reports option. One of these Technicians has recently left. 1) If we remove the Technician license from that user, downgraded them to an ordinary requester, will that delete all scheduled reports? 2) If I delete the underlying report, will this cancel the scheduled action? 3) If not, is there any way for an admin to remove a user's report
extracting report satisfaction survey ?
Extracting report satisfaction survey ?
New Report
Hello, I wonder if they can help me with the case below, I need a report to me the following information: - Request - Request Status (all status it passed) - Time the request was in each of these status - Date - Technical taribuido It's possible??
Open Incidents
Hi, The standard reports allow a technician to see all their "Open Incidents" that are currently assigned to them. When a ticket goes back to the requester for further info etc. we lose sight of this ticket for the technician. Is there any way we can run a report that would pick up the active incidents they own as well as those the technician has previously owned but are with a requester for action ? We're on 9120. Thanks. A
Query report on requesters create date
Hi, We would like to clear up the requesters in SDP, as we have over 55,000 and would like a query report to be written, to list out the requester details with the date they were created. Is this possible? Thanks Lynne
PieChart and Time Spent
Hello! We want to make a report with chart for us. So, we did a report with time spent, and in that report we make PieChart 2D with axis column - category. And we have this: So here all requests of tehcnican for 1 day by categories. But we don`t want in that chart quantity of request by category. We want spent time of technican by category. How we can do it? Thank you :)
Report on Request Status on a Certain Day
Hi all, I'm looking to create a report that shows us how many tickets are open on a certain day. It doesn't matter when they were opened or if they were closed after it but simply on Jan 31st how many tickets had the status set to open. Looking at the report builder the simple date selection doesn't seem to make sense for this report. None of the single date fields line up with this idea. Then using the advanced filtering I'm currently trying to set completion date to null AND opened date to later
Template Audit Query amendment
Hi, Would you be able to amend the below, so I can change the query to run the report by our individual Regions please? SELECT serd.NAME "Service", reqt.TEMPLATENAME "Template", COUNT(CASE WHEN MONTH(dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.CREATEDTIME/1000),'1970-01-01 00:00:00'))=1 THEN 1 ELSE NULL END) 'JAN' , COUNT(CASE WHEN MONTH(dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.CREATEDTIME/1000),'1970-01-01 00:00:00'))=2 THEN 1 ELSE NULL END) 'FEB' , COUNT(CASE WHEN MONTH(dateadd(s,datediff(s,GETUTCDATE()
Report Request for Workstation + Software
Hello, I am looking to see how I can create a report for the following: We have workstations that go into a "in-store" state after employee leaves. We need to make sure there is specific software that is uninstalled from that PC. Is there a way I can create a report to pull all workstations with an "in-store" status that has Software-XX installed? I have been playing around with it-- I was so sure I found a way, but I cannot figure out how I got that far now. Thanks!
Reporting for Service Desk Plus
I have Service Desk Plus Enterprise and would like to know if anyone has any reports for the following IT Project Module - there seems to be a list of canned reports for all modules except the IT Project Module Time Sheet reports - I have a couple of custom reports I created but would like to know if anyone has some reports specific to timesheets that are used by techs for manager weekly sign-off and review of time allocation to validate that developers are entering their time frequently to projects
Desk top running verrrrry slow.
Good Morning IT, Can you take a look at my desk top. It is getting hung on previous pages. The pages will not advance or shut down. Thanks,
Scheduled Reports
Dear Support, We have upgraded our SDP (installed since 2011) to version 9121 and we are not seeing where to access Scheduled Reports. We have some reports already scheduled since installation and is still being sent by email but we want to change the email recipients but we cannot find the possibility to do so. The scheduled reports list does not show anything. Please assist ASAP
Tickets chaned from rejected
HI. Is there a way to get a report of tickets that had a rejected status but they are changed to another status right now? Appreciate any response. Thanks
Zoho reports "Request type"
Good morning, I just configure Service Desk plus to have auto reports with zoho Reports Analytics. Reviewing the data imported, the field "Request type" is not getting any data. This field is configured in our Service Desk application with the options issue, requirement, problem, task, etc. Do you know how to fix this problem? We have 9020 release and the standard version. Kind regards
ManageEngine Servicedesk Plus sees chrome as mozilla 1.3 <
I get this warning when ever the editor is used in manage engine service desk plus. is there any way of getting rid of this issue as it is extremely annoying.
Technicians and Groups
Is there a report or easy way to list what technicians are assigned to various groups?
Query for Has requester acknowledged the resolution?
Hi can you please let me know if there is a way (report wizard or query) to find out on how many requests user validate the resolution? I
Transactions per second
Dear all, Can I get a report from the Service Desk of transactions per second, at DB level? Will appreciated. Regards, Davis Onsakia
Report SQL Query
Hi All, Please can I have some assistance below. We need to amend the below query to show contact details such as phone numbers against the "Last Logged on User" and NOT the "User". Any help would be mostly appreciated! SELECT MAX(workstation.WORKSTATIONNAME) "Machine Name", MAX(workstation.MODEL) "Model", MAX(workstation.MANUFACTURER) "Manufacturer", MAX(workstation.SERVICETAG) "Service Tag", MAX(workstation.LOGGEDUSER) "Last Logged In User", MAX(state.DISPLAYSTATE) "Asset State", MAX(osInfo.OSNAME)
Report SQL Query
Hi All, Please can I have some assistance mending the below. The script shows all the correct information but instead of receiving contact information regarding "User" we need it to show all the information for the "Last Logged on User" such as phone numbers etc. SELECT MAX(workstation.WORKSTATIONNAME) "Machine Name", MAX(workstation.MODEL) "Model", MAX(workstation.MANUFACTURER) "Manufacturer", MAX(workstation.SERVICETAG) "Service Tag", MAX(workstation.LOGGEDUSER) "Last Logged In User", MAX(state.DISPLAYSTATE)
Graph: Total requests as time goes
Hello, I'm looking to be able to generate graphs that show the total amount of open/onhold requests at the end of each week. The vertical axis would show number of tickets (say a scale of 0 - 500) The horizontal axis would be time in week (for example: January Week 1, January Week 2, Januar...) The amount of requents needs to be total, not new. So if a request lasts from week 1 to week 3, it would be counted in week 1 and 2. Hope that makes sense. If someone can show me how to do this, then I'm looking
Report time spent by members in a project
Good afternoon I need your help. I need to generate a report showing how many projects are involved and how long an individual is employed. Also a report showing the comparative of the planned advance against the actual status of a project. Thank you
Report time spent by members in a project.
Good afternoon I need your help. I need to generate a report showing how many projects are involved and how long an individual is employed. Also a report showing the comparative of the planned advance against the actual status of a project. Thank you
Report time spent by members in a project
Good afternoon I need your help. I need to generate a report showing how many projects are involved and how long an individual is employed. Also a report showing the comparative of the planned advance against the actual status of a project. Thanks
Scheduled Report
I need to create a report on the last day of every month. If I add a scheduled report, select all months and set to generate this report On Date of 31, will it run, for example in February 29?
Custom report linked with column alais
, I am attempting to generate a report, that will display the column names , this is successfully however i also need to add the Reason for test request into the report however i am unable to located this Please an you confirm how to add column in so that we can report on the as well (second screen shot) COLUMNALIASESID TABLENAME COLUMNNAME ALIASNAME 29514 ServiceReq_1501 UDF_CHAR3 Reason for Test Request servciedesk1.PNG (33.97 KB) servciedesk2.PNG (69.57 KB) 04 Feb, 04:32 AM . Like . Comment . Share
Sql Report
Can someone offer support support in generating a sql report based on finding out the following information, i am still attempting to review the database schema so any help would be greatly appreciated · SD ref number · Subject · Description · Name (requester) · Test Environment · Implementing Group
Need to combine two type of report in one single report
Hi admin, I would like to have a combination of these to report in into one single report: tabular matrixThe combination report is tabular + matrix Thanks
Multiple Schedule Reports In One Email
Hi there, I have 3 different reports that I have scheduled to run every night and be sent to the same email group. Is there any way to have these sent in the same email so there is a bit less spam? Thank You, James Leitz
Reportng/Scheme Table for ServiceDesk Plus
Is there anybody here have difficulty on generating report? Say. I am generating a time spent report but it is not easy to filter out by incident/service request type. That's why now we need to create a general incident report with all incident and service request and take a vlookup to merge all fields I need. Is there any way we can have a full scheme table structure then I may easy to create such report?
Cannot generate report in ServiceDesk Plus V9.1
Dear, ServiceDesk Plus Team I'm now using Service Desk plus 8.2 and trying to upgrate to version 9. The setup probably work fine but I found some problem in my Ubuntu 15.04 X64 with progreSQL Server. When I generate any report in my testing server, the result of its show below: Dear user, Unable to generate the report, So please contact servicedesk support for further assistance to resolve the issue and forward this mail and support file(s) to support@servicedeskplus.com Error Trace
Customer Facing Reports/Dashboards
I would like to provide all of my requesters a dashboard that show all open incidents at the moment. In other words, a real-time tool that requesters can use to see what issues we face at any given time. This does not seem to be possible by default. My question is, is there a way to do that with REST API? Or has anyone tried to do something similar to this? Any ideas or advice will be greatly appreciated.
How to pull a report to show workstations with specific software and associated local user accounts
I'm able to create and run a report to show workstations that have specific software. But I need additional information on that report, more specifically, local user accounts on those workstations. Can someone help, provide some details on how this can be accomplished? Thanks
Report - No of received requests each month
Hi, Can someone help me with the SQL query for above report? Thanks R
Next Page