Schedule Reports
what roles are required to give technican permission to Schedule Reports and view the scheduled report. currently we use our admin account.
Report on overall number of incidents by Requester
G'day All, Is there a report template to list the overall number (or for a specified time frame) of requests by requester? I am looking to see if there are individual requesters who may feature more prominently by the number of request they raise. This would be used to make training recommendations or in the worst case scenario assist with weeding out nuisance or trivial ticket raisers. Gary
Tickets mayores a 30 dias (requests/incidents greater than 30 days)
hi, I need report from request/incidents pending greater 30 days. thangs.
can not select warranty expiry date on custom report
Hi, I ‘am using Servicedesk plus version 8100. I need to build a simple report listing printers including the column warranty expiry date. When building a custom report for product type printers, the column warranty expiry Date is not available ?
Tickets Report Unassigned
How I can get a report that tells me how long you were a ticket without being assigned to a technician? and how many times had to be reassigned a ticket? Thanks, Mauricio Fuentes
Report Request - unassigned requests
Hi, I need to create a report to show all open requests, that have been open for at least 8 hours and that have not been assigned to a technician. The results need to be grouped by 'group'. Any help would be much appreciated. Thanks.
Report not visible
Hi, I have created a new report with a customized query in the Corporate IT part. The results of the report are ok. However, this report is not available for the rest of the people. They don't show it in the reports tab. I'am as a administrator role so I dont know which is the permissión which regulate this. Any idea? I paste the query. Maybe is missing something that is related with that. SELECT solution.solutionid 'Solutionid' , KB_Topics.TOPICNAME ' Topic',Solution.TITLE 'Subject ',Creator.FIRST_NAME
Report tickets by Site
I have created a simple report to display tickets by Site, but how do I make it so its ordered by closed tickets. I have the query below: SELECT std.STATUSNAME "Request Status",sdo.NAME "Site",wo.WORKORDERID "Request ID" FROM WorkOrder wo LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE (wo.ISPARENT=1)
Help with Computer by Software query
I want to be able to list Microsoft Office 2007 Computer 1 Computer 2 Computer 3 Microsoft Office 2010 Computer 4 Computer 5 its very similar to Computers by OS , which is a standard report in service desk. Not sure how to do this any help woul be greatly appreciated.
Matrix report with two Sumarize columns
Hi all, I'm trying to create a matrix custom report, and I need your help to insert two "Sumarize" columns ("Count Request ID" and "Average Elapsed Time"). I did these steps: - New Report -> Matrix/All Request -> Advanced - Column grouping: Created Time / Month; - Group by Category, then Group by Subcategory - Sumarize column by: Count of Request ID; or (Sumarize column by: Average of Time Elapsed) How can I insert "Count of Request ID" AND "Average of Time Elapsed"? pratically, what I want is a
CMDB Export Results
Dear It would be interesting to export the results of relationship in PDF Regards Marcelo
Requests View
Hi I am wondering, in Dashboard -> Heldesk View we have a view with Request Status (request not Closed). This includes Open, On Hold an Overdue. I have made a new status (Pågår) that indicates that we have started on the request. How do I get this status in the global Request Status View? rmo
Overdue request report
Hi, I have been using an overdue request report, filtered by dueby time, request status = overdue and technician. The problem I have is a request will go overdue, the technician will change the due date which resets the overdue flag and I cannot report on it. Basically you get get around overdue SLA's by rescheduling the due date! Anyone else overcome this problem? Thanks, Lee
How Can I make report for more requests frequently ?
How Can I make report for more requests frequently ?
How Can I make report for more requests frequently ?
How Can I make report for more requests frequently ?
Report on Technician's open tickets over period of time
I am looking for a way to run a report. I want to see the number of non-Closed/Resolved tickets that a technician has had over a period of time. so a report that shows Technician A had 10 open tickets on Jan 1st and 12 on Jan 2nd, etc. Any help would be appreciated.
OU report showing users in a specific OU
I've look through all of the reports several times and maybe I missed it but I need to run a report showing only the users within an OU. Can someone point me in the right direction. Thanks,
Help with Custom Query Report for outputting the times calls come in
Hello, I'm trying to create a Custom Query Report to show how many calls we receive during specific time periods of the day. For example: How many calls we receive: From 8-9 a.m. From 9-10 a.m. From 11-12 noon, etc. I'm also trying to group it by Category to know what type of calls come in during those times. For example, Are they all password resets, or logon failures, etc.? I can only seem to create a report to show how many calls per DAY we receive but I need to know the times these calls are
Time Spent combined reports.
I already have the answer from Tech Support that what I am asking for needs to be evaluated for future development, however, thought I would post to see if anyone has a workaround in place already. I would like to build a custom report that pulls from all modules where technicians can log time on a project or request, task, problem log, or change management. currently I have separate queries for these, that don't really line up to show the right data. so If anyone else has taken it upon themselves
Running a Ticket Report help
Hello, I have successfully created a report that shows me how many tickets have been created, how many tickets have been closed and how many are still open at the end of each month. My issue is that for the open tickets, I want to know how many are still open at all times..here is an example: My report says I have 39 tickets opened. We closed 32. Basic math will tell you 7 tickets were still open. However, I want to know ALL of the tickets that are still open, because there are possibly 13-15
Retroactively run weekly reports to graph trends
Hi, I am hoping someone can help me out - I am not sure if I am running into a limitation of the program, or a limitation on my understanding of how to create a custom report... I am trying to run a report which can show the total number of pending requests in a given week along with the number of requests added during that week. In the same report I would like to show the number of both closed or resolved requests for each week. I want to be able to retroactively go back say 6 months or a year to
Error opening links
Good afternoon. If the browser is closed and you are not logged in the system, then the task of opening links in a browser http://server/tasks/CUDTask.jsp?TASKID=903&MODE=Edit start out mistake. does not depend on the browser, tried Chrome and IE.
Ticket report help
I have created a report that shows created, open, and closed tickets per month. The problem is that it shows open tickets only for that month, and not total open tickets by the end of the month. Example: January 39 tickets opened 35 closed 9 still open Basic math tells me 9 are still open. This report doesnt tell me about the other 20 tickets still open at the end of January. It should say around 29 tickets are STILL open. So it needs to show previous open tickets from earlier months.
cartridges reports
Hello. I was added my cartridges (over 600) to sd like assets. i need special report. what asset and how many times get state "in use" for month. catridge serial number (235) state date 49a 235 in use 15.05 85a 215 in use 14.05 85a 215 in use 19.05 assets must be in report if their state change in use-instore-in
Error when running report
I have created the query report below. (SDP 8026) SELECT wo.WORKORDERID "Request ID",longtodate(wo.CREATEDTIME) "Created Time",aau.FIRST_NAME "Requester", awo.STATUSNAME "Status",awo.URGENCYNAME "Urgency",qd.QUEUENAME "Group",ti.FIRST_NAME "Technician", wo.TITLE "Subject",wotodesc.FULLDESCRIPTION "Description",longtodate(won.NOTESDATE) "Note Date", won.NOTESTEXT "Note",tsd.Title "Task Title",longtodate(tsd.SCHEDULEDSTARTTIME) "Scheduled Start",longtodate(tsd.SCHEDULEDENDTIME) "Scheduled End",longtodate(tsd.ACTUALSTARTTIME)
Report of asset relationships
I would like to create a report that lists all my workstation and/or servers and assets assigned to them. For example: Workstation 1 Monitor 1 Monitor 2 Phone Scanner Workstation 2 Monitor 1 Printer
Creating a report
I have a need for a report that is similar to this request summary report: But, I only need to show the inbound and the completed requests and the ability to select month to date, quarter to date and week to date. Is this report included for selection in the reporting section? I don't see it. We are running: Service Desk plus Version: 8.0.0, Build 8022 If it's not available, how can I create my own custom report to show this information? It's not intuitive from the report builder.
KPI Report
Hello, I want a KPI report for those requirement in attach. I want this for each technical, category and by Year,Month and week. I know how to make it with Custom Report, but over due requests and first response will not be in the same report they will be in separate report for each which I want all of them in one report Also if you can add ring charts it will be better. Regard.
Report of Printers
Hi, at first i would like to say that this is a easy-manageable Report creator, but the query-reports are a little bit more tricky. I tried to figure it out by my self, but i'm on a point where i need help. I want to make a report from all the printers which starts with 'BGPRT', listing following colums: - Hostname - IP - Product Name - User - Location - Vendor - Acquisitation Date and all should be grouped twice, by Site and then by Department. It's even possible to make such a complex query?? Thanks
Problem with "Standalone audit" !
I have a servers and computers, i want to get the information of the computer(client). But i use Standalone audit in Quick Actions, it cant push data infomation from client to server. i cant resovle this problem ! who can help me I use ISA firewall !
Data dictionary SDPlus
Hi, I would like to customize some reports. Is there a data dictionary of ServiceDeskPlus 8.x? Thanks in advance, Sutot
Audit Reports - need results to show "who" did change
Hi... I believe my resource manager used the "Audit Reports" to show what changes have taken place on the scanned workstations/servers. However, she would like the report to reflect "who" was on the server at the time the change took place. Is this possible? Additionally, would like to customize Audit Report to specific workstations or software changes. Haven't found a way to customize Audit Reports by the Query mode. Thanks! Also, wanted to "signup" for ME Community, but SignUp button
Report request please
Hi there, I have an existing report that I would like modified and the person who wrote it has left the company. I don't have the knowledge to use the query editor to edit it and I need information additional to that available from custom reports. Please could someone urgently help me? It can be based on this report (screenshot also attached) but requires a lot of additions: SELECT std.STATUSNAME "Request Status",ti.FIRST_NAME "Technician",ti.FIRST_NAME "Technician" FROM WorkOrder wo LEFT JOIN
createdtime and MS SQL Scripting to decipher date in reports
I created the following Script in MSSQL and it is working. I have Two questions. SELECTChange_fields.UDF_CHAR1 ,ltrim(dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (CREATEDTIME/1000),'1970-01-01 00:00:00')) 'Open Date' ,changedetails.CHANGEID ,INITIATORID ,TECHNICIANID ,STAGEID ,PRIORITYID ,CATEGORYID ,SUBCATEGORYID ,ITEMID ,APPR_STATUSID ,CHANGETYPEID ,URGENCYID ,TITLE ,DESCRIPTION ,SCHEDULEDSTARTTIME ,SCHEDULEDENDTIME ,COMPLETEDTIME ,NOTESPRESENT ,SITEID FROM ChangeDetails, Change_Fields
russian translate
The file with the Russian translation lacks the last 200 rows. So to translate these buttons do not predstavlyaetsya possible. Even with the assistance of an interpreter in the menu. For example there's this group of lines sdp.change.reqattachlinktitle = Attach similar requests sdp.change.reqdetachlinktitle = Detach the selected requests sdp.change.actions.associate = Associate Requests sdp.change.error.reqdetachnoselection = Select one or more requests to detach. sdp.home.ssp.others.defaultrequest.title
Russian translate
In the build of a 8100 Russian version of the translation, not translated button "request catalog" in the top menu is cleared in English. Should I send these shortcomings? Also in the user interface in a window where the list requests is not translated the button "New Issue" Should I send these shortcomings?
Custom Report for "Problems" unable to select "Root Cause" and "Symptoms"
Hi, Using the Custom Reports for Problems, i am unable to select fields from "Analysis". Mentioned fields: Root Cause Symptoms I did not find this under known issues nor planned features. I know that i can get these information with query reports, but that "custom report" function would be needed for non- IT staff to create reports. Best regards, Nils
Scheduled Report deleted but still sending.
I've got a requests report "Weekly Workload for the web designers" going to two executives, every week. They said they were done with this report, so I deleted it from "Showing, Schedule Reports". The report is still sending apparently. I can't edit the report or the scheduling because it does not exist. I am an SRAdmin and I created the report and the schedule. Any ideas where I can find it, or shut it off? John "You know you've been doing tech support too long when you answer your home phone
Report on number of requests raised per day
I am looking for a report with the following: All requests raised for a period Day of week request raised All the reports I seem to get have the DATE of the request but I cant see how to convert the date to a DAYOFWEEK. Appreciate any help. Cheers.
Client Login Log
Can I get a historical log of the income to the portal of my clients. I need to know the schedules to which they entered to the portal. Regards.
Next Page