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
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?
Next Page
