Scedulled Reports
problem regarding scheduled reports - even though I can see all Scheduled reports other technician not able to see that, how can we set this up ?
One of Frequently asked Reports could not be executed
Hi Expert, I'd like to add one of Frequently asked Reports into SDP system, which is called Count of request created based on hour range. But when I exeute the query, the error messages poped-up. Refer to the attached file for more details. The query of report is: select DATENAME(mm,dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.CREATEDTIME/1000),'1970-01-01 00:00:00')) 'Month',sum(CASE WHEN DATEPART(hh,dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.CREATEDTIME/1000),'1970-01-01 00:00:00'))>0
Logo Report
Hi, how can change logo report because when we create a report will receive AC ME helpdesk logo we need to change it to our logo. thank you
Generate a new report project
Please, I need your help to generate a report containing the following, it is urgent : 1) The Database is MSSQL 2) The version is 9.2 the build number 9202 the last version 9.2 the build number 9200 -Project's name -Project description -Project status -Total Percentage of project progress Project-owner -Comments Overall project -Date Expiration of the project -Tasks Project -Description Of the task -Task-owner -Task -status -% Advance task -Date expiration task -Comments Each task Generate
Report on requests with notes
Hi, I would like to run a report on all requests closed in last month which have had a Note added to them. If the note itself could also be added to the report that would be ideal but if not then at least returning the calls with notes would be a big help. Is this possible? If so can you let me know how or provide the query? I would just want RequestID, Requester and Subject of all calls with a note. (unless the text of the note itself can be displayed directly). Thanks
Report \ Hour range
Hi, How to fix this report that it reads the data only for the last month? select DATENAME(mm,dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.CREATEDTIME/1000),'1970-01-01 00:00:00')) 'Month',sum(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 00:00:00')) <= 3 THEN 1 ELSE 0 END) '0:00 to 3:00 hrs',sum(CASE WHEN DATEPART(hh,dateadd(s,datediff(s,GETUTCDATE()
System Log Mass Extract
Hi, Recently joined my organisation in a reporting capacity and trying to get an idea of what reports are currently being run by whom within Service Desk Plus and with what frequency. I've come to the conclusion that the System Log Viewer is what I need to get this information but I can only view the data 250 records at a time from the front end. Is there any way you can get this information out of the application en masse so I can properly test what is being used? I'm assuming I can get to this
Time Spent by Technician in a week over all categories (Requests, Problems, Changes and Projects)
Hi all, I want to create a report that will show me the time spent by a technician regardless on which category its booked. At this moment I've got separate reports for each individual categories but I would like to combine them to have one report overview. Our technicians can work on requests, problems, changes and projects through a week. For example: A Technician works on Monday 1 hour on requests, 2 hours on a problem, 1 hour on a change and 4 hours on a project. The Technician writes down all
Report all open work items by Technicians across all modules
Hi- i would like to have a report that shows all Requests/Problems/Changes/Projects assigned to Technicians and grouped by Technician. Is this possible? I'm running Build 9204 PGSQL -Jon
last 90 days report
Hi can someone assist with Reports Reflect the following: Open tickets only filter to 90 days Tickets closed within the last 7 days.
How to get query totals please
Hi, I have a working query, but would like to see totals in it - could you advise whether that's possible? Query is below, and screenpic of results is attached. SELECT ddef.Deptname, chdt.CHANGEID "Change ID", CTDef.Name "Change Type", longtodate(chdt.Createdtime) "Create Date", priodef1.PRIORITYNAME "Priority", chdt.TITLE "Title" FROM ChangeDetails chdt LEFT JOIN PriorityDefinition priodef1 ON chdt.PRIORITYID=priodef1.PRIORITYID LEFT JOIN Userdepartment usd ON chdt.TECHNICIANID=usd.Userid LEFT JOIN
View all reports
How can I view all reports, including those created by other users? With SD administrator rights, I see only the records, that I have created myself. The problem is that someone had created a report for an employee who is now discharged and continuously receive notification that the message can not be delivered. is it possible to view all existing reports through SQL query, with a note which employee created it?
Report to include most recent conversation?
9.0 Build 9039 on PostgreSQL I've created a custom report showing all open tickets and included a few relevant fields; this works fine. The report is used in weekly helpdesk status meetings. However, I don't see a way in the GUI to select something like the most recent non-System conversation. That information would be helpful to be able to show what the most recent activity was on the ticket. That way in one report I could have RequestID, RequestMode, Requester, Subject, Description, Request
Query report that combines Problem and Request fields
Hi, We need to create a report that returns Problem and Request data based on the status of either being equal to a common status value. Is this possible? I've tried to write my own solution, which seems to logically work, but throws an error when trying to run - is it possible for an expert to troubleshoot for me or advise if what I'm trying to do is not possible? I've seen no examples anywhere where Problem and Request data are returned in the one report. The query follows: SELECT "prob"."PROBLEMID",
Create a report for worklog from last week
Hi, I try to create a report where it sums the worklog from all modules for this week so it shows likewise as attached picture without the status so it only shows the total time the technican have logged the week. We are using Version 9.2 Build 9205 PGSQL
Reporting on Reports
Hi, We've using 9120/MS SQL and I was wondering if you can do the following with the Reports : 1) Run a report to show when\who last ran the report (Default and/or ones we have created) 2) Hide specific reports so the landscape is smaller (It's quite crowded) 3) Remove specific default reports Any help or advice would be appreciated. Andrew
Report time-pending request
Dear all I has a report contains all uncomplete request (include Create time) Now i want to count from Create time to when report created to makesure how long request pending. In SD, just have field "Time Spent" count from Create Time to Close Time. Any idea with that? i use SD with MS SQL. Thanks Report
Asset Scanning Report
Hi all, I was recently tasked with managing ServiceDesk and other ManageEngine products at my job. So my question is: Is there a report that I can run that would contain a list of all the assets that failed to scan for a specific site/domain? The specificity of the domain may not even be relevant as, currently, we have only scanned one domain. I have no issues running reports but none of the parameters seem to display the assets that failed to scan.
Recreating the Request Summary graph from the dashboard
Just trying to recreate the Request Summary from the dashboard in the reports section, we want to be able to show it with a custom date range if possible.
After loading Password Manager in Chrome I cannot load Service Desk
Both PW Manager and Service Desk work alongside each other in Internet Explorer and also work separately in both Chrome and IE. However if I open up PW Manager in Chrome and then attempt to open Service Desk in Chrome the page does not load and it returns an SSL Error saying that it cannot get a secure connection but works if Password Manager was never opened. To be able to open Service Desk again I have to close the tab Password Manager was open in and clear cookies and site/plugin data. I have
Need time spent added to report for technican's tickets by category
I have report in SDP build 9121 which gives me technician's tickets by category . I need to add the time spent on the request to this report which I assume makes it a query. Attached picture is part of the current report and i need techncians time spent added to this. I want to be able to specify the technicians name or support group will work. Is this possible?
Reports : Can I create a Weekly Worklog Report AHEAD OF TIME?
We have shifted over to ServiceDesk+ recently and I am trying to re-create a personal workflow that has greatly aided me. We are currently required to log all hours worked in a Worklog. Prior to ServiceDesk+ I had a Google Sheet (think Excel for those unfamiliar with Google Apps) that I used to track every minute of my time. I have to do this as I am not exempt, but instead I am still hourly. What I was able to do in that spreadsheet was to see both my "already accomplished" hours, and I could plan
Completed Request by Date By Technician
Guys, Since upgrading to the newest version of Servicedesk our Completed Request By Date By Technician doesn't seem to work correctly. It only shows the results for the technician who is actually running the report. I've attached the query below and double-checked the filtering options but can't seem to figure it out. SELECT ti.FIRST_NAME "Technician",wo.WORKORDERID "Request ID",wo.COMPLETEDTIME "Completed Time" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT
Count of Request ID's
Ok Service Desk plus team, I have a new one for the great minds. I am using the following query to pull a report. What I would like to do is add a count of the request IDs to this report. Any ideas are appreciated. Following Query I am using. SELECT ti.FIRST_NAME "Technician", wo.WORKORDERID "Request ID", sdo.NAME "Site", scd.NAME "Subcategory", longtodate(wos.LAST_TECH_UPDATE) "Last Updated Time", qd.QUEUENAME "Group", std.STATUSNAME "Request Status", wof.UDF_DOUBLE2 "Technician timespent" FROM
Duplicate Columns in Technician View
Version 9024 In Technician View the default layout is showing the columns duplicated. When you go to turn them off you will see more. I didn't notice if this was in the previous version.
Report Inquiry
Good day, Is there a way to generate a report that lists all service requests of a single subcategory with its details? Example: We want to keep track of Leave Requests, so we need to generate a report that shows the Requester, Date From, Date To in a table.. Thank you in advance!
Simple Call Volume per Month line chart
Hi, I'm looking for some tips on creating a simple line chart that shows us how many requests our Service Desk has received per month. So we can get some sort of indication of a request volume trend. I'd also like to have this as a schedule report to be mailed to me monthly. I've been having a look at it today, and can almost get what I want by creating a custom Tabular Report. This generates a simple line chart of requests created, per month, but also includes details on all the requests that have
Add filter and column to aging report
I have the following MSSQL report that shows detailed ticket aging. I would like to have this filtered so that "Incident Type" is NOT "TASK". Also I would like to add a column for priority. Can someone assist? Here is the code: SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",cd.CATEGORYNAME "Category",wo.TITLE "Subject",ti.FIRST_NAME "Technician", std.STATUSNAME "Request Status",datediff(d,dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.CREATEDTIME/1000),'1970-01-01 00:00:00'),GETDATE())"Aging(Days)"
Category Query report amendment
Hi, Please could you amend this query to only look at active categories, subcategories and items that have been used in the past month and have a count down of count per regions please? select cd.categoryname "Category",scd.name "SubCategory",it.name "Item",count(wo.workorderid) "Count" from itemdefinition it left join subcategorydefinition scd on scd.subcategoryid = it.subcategoryid left join categorydefinition cd on cd.categoryid = scd.categoryid left join workorderstates wos on it.itemid = wos.itemid
zoho reports in servicedesk plus
Hi, Great job integrating servicedesk plus into zoho reports . With this I have made a wallboard showing request (with SLA status) per technician. I have two questions: 1. Is there a roadmap when problems, changes and projects will become available ? 2. Is it possible to include all worklogs and tasks in the export (now only those related to requests are exported) for I want to show open tasks and hours made on a wallboard. The fact that the related problem or change is not available doesn't matter
Reporting for a new Service Desk
Hi Support, We are setting up SDP for a new Service Desk, but I need to create some custom reports. Number of calls taken (breakdown by Mode) Failed Response SLA for Day/Week/Month Failed Resolution SLA for Day/Week/Month Average Resolution time by Category/SubCatagory Average Resolution time by Technician Even if you could point me in the direction of the field names required for these Queries that would be very helpful. Regards, Ben Louisson
Unable to log with AD credentials
[08:54:36:978]|[03-10-2016]|[com.manageengine.jobscheduler.JobQueueFiller]|[INFO]|[106]|: Starting job queue filler in the interval:20000| [08:54:36:979]|[03-10-2016]|[com.manageengine.jobscheduler.JobQueue]|[INFO]|[106]|: checkAndFillQueueFromDB: jobQueueSize: 0; jobInfoQueueSize: 300| [08:54:36:979]|[03-10-2016]|[com.manageengine.jobscheduler.JobQueue]|[INFO]|[106]|: JobQueue.size is less than JobInfoQueueSize. So going to fill from db if available in DB| [08:54:36:979]|[03-10-2016]|[com.manageengine.jobscheduler.JobSchedulerUtil]|[INFO]|[106]|:
report query - works in postgres admin, not in report writer
Can you please help me get this query to run in a query report? I am pretty sure it is the "(from_unixtime(chdt.SCHEDULEDSTARTTIME/1000) - interval '5 hours')" that is making it not work. Thanks SELECT chdt.CHANGEID AS ID, ctdef.NAME AS "Change Type", catadef.CATEGORYNAME AS Category, chdt.TITLE AS Title, ownaaa.FIRST_NAME AS Owner, ownaaa.FIRST_NAME AS Requester, (from_unixtime(chdt.SCHEDULEDSTARTTIME/1000) - interval '5 hours') as Time FROM ChangeDetails chdt LEFT JOIN SDUser ownsd ON chdt.TECHNICIANID=ownsd.USERID
Urgent new report projects
Good day I still have not received any answer but please, I need your help to generate a report containing the following,: 1) The Database is MSSQL 2) The version is 9.2 the build number 9202 the last version 9.2 the build number 9200 -Project's name -Project description -Project status -Total Percentage of project progress Project-owner -Comments Overall project -Date Expiration of the project -Tasks Project -Description Of the task -Task-owner -Task -status -% Advance task -Date expiration
Crystal Reports
Hoping to get the procedure for linking DB for Crystal Reports. brian.riehle@drs.com
What is needed to measure time spent on an incident?
Hi, My current SD+ configuration and work style is as follows: - new issues are assigned manually to free technicians by a coordinator - technicians update it's status as the work progresses While trying to measure time spent on identical issues by various technicians I do not have the time the technician actually spent on the issue, besides standard SD+ SLA KPI's. Does this require putting in additional field to the templates and manual clicking the time and date when work has started by the technician
Date format function removed from build 9203?
I was previously using the TSQL statement below to format the acquisition date but it seems like the FROM_UNIXTIME function is no longer found after I upgraded to build 9203. (dbo.DATE_FORMAT(dbo.FROM_UNIXTIME(resource.ACQUISITIONDATE/1000),'%d-%m-%Y %k:%i'),N'') "Acquisition Date", Can you please provide a way to format the date?
How do you stop reports from being sent out from ServiceDeskPlus
I have a need to stop the standard and custom reports from being e-mailed out. When I try to view the scheduled reports from the filtered options list, none of the reports appear. But the reports are still going out, it looks to be weekly. Thanks
Wrong scheduled report received
Another issue reported to me this since upgrading to 9.1 Build 9120!.... An admin in Europe has scheduled a daily report to be delivered to her, she received the report fine until this morning, although the report attached to the email had the right name, the detail was for our Asia Pac region. I will get screen shots of the scheduled reports sent to me (as I cant see anyone elses!) and add them to this article. Thanks Lynne
Licença
Bom dia ainda não recebi a minha licença e o site está me informando que foi enviando é t não recebi também nenhum arquivo informando a licença nem no corpo do e-mail nem em anexo. Quais procedimentos tenho que tomar para obter uma licença
Next Page