Missing reports
Hi i have been creating a lot of reports and a number of them have gone missing. Also one had been changed to something totally different Only myself has been creating reports Thanks
Reports Module Error
Hey All, I have a few users getting the below error when using the Reports Module. For some it resolves itself, and for others it never does. I have the resolution steps: 1. Stop "Manage Engine ServiceDesk Plus" service in Services.msc 2. Rename the "Reports" folder under ..\ManageEngine\ServiceDesk. 3. Start "Manage Engine ServiceDesk Plus" service in Services.msc 4. Update the report settings by clicking on "Update" under Reports -> Custom Settings -> Update. 5. Run the particular Report. If the
Trouble creating a custom report
I am having trouble creating a report with all the Requesters data and information including the custom fields that I have created. Right now I have the below but I still need the custom ATTRIBUTES in the query SELECT aa.USER_ID,aa.FIRST_NAME "FullName", al.NAME "LoginName",al.DOMAINNAME "Domain",aacontact.EMAILID "Email",dept.DEPTNAME "Department",sdorg.NAME "Site",aacontact.LANDLINE "Phone",sd.JOBTITLE "JobTitle",aacontact.MOBILE "Mobile" FROM AaaUser aa LEFT JOIN UserDepartment userdept ON aa.USER_ID=userdept.USERID
Report on eMails received grouped by sent_to addess
Hi SD+ Team it would be great if you could help me creating a report for inbound eMails received in SD+. I'd like to get a report that lists all workorders (requestID only) grouped by the sent_to address that is contained in the original eMail. Thanks a lot for looking into this matter. Have a nice day Matthias
Getting Work Log Type From Archived Requests
How do i get worklog type from archived requests? Arc_ChargesTable table does not have a WORKLOGTYPEID field?
Report to show requets assigned to a particular technician with due day
Hi im looking to build a report to show what requests a technician has assigned and also the due date an priority Thanks Postgres Version : 9.2 Build 923
Survey URL Blocked
Hi Team, We have configured the Survey link however its getting blocked see the below error. "The link has been disabled to protect your security" Survey URL : <a href="http://MEM-P-TKT01:8080/sd/SurveyDetails.sd?surveyData=447a67a6048205f6637e1f36003e2813486f8c31" target="_blank">SurveyLink</a> We are trying from both OWA and outlook client its not working. Please assist. Thanks, Sachin
problem with due by time
Hi all i have the following query, but when the query runs the due by times shows as 1482419785979 any ideas how i can convert this to the a format such as 12/01/2017 Thanks SELECT ti.FIRST_NAME AS "Technician", wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", ti.FIRST_NAME AS "Technician", pd.PRIORITYNAME AS "Priority", wo.DUEBYTIME AS "DueBy Time", std.STATUSNAME AS "Request Status" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID
Project ID linked to Request
I need to be able to generate a report where I can link Requests that have a Project Assigned and visa versa Project Report should include the following fields from the Project Module Project ID Request ID (of Associated request) Title Project Type Project Code Status Priority Owner Schedule Start Schedule End Actual End Projected End Estimated Hours Actual Hrs Estimate Cost Actual Cost Also, the Request Report would need to return the following and include the Project Information that is Associated
Count of tickets resolved / closed by individual, and which group they were resolved
Morning, I'm looking to build a report whereby it does a count on the number of tickets resolved / closed by and individual, and also a count of which group they were in when they closed the tickets Thanks
SLA Violted Current week
Hi I'm looking to build a report to show the number of SLA's violated for the current week Postgres Version : 9.2 Build 923
Request Module - Estimated Effort
Hi Can I please have some assistance creating a report which includes estimated effort with-in a request ? As Estimated Effort does not seem to be an available column. Am running postgres sql I would like to report on Request ID, Owner, Title, Scheduled Start Time, Scheduled End Time, Estimated Effort. And filter Category is "Project" Request Status is "on-hold","open","None" Grouped by Technician
Generate report by technical assistance groups
Hello, my name is Ezequiel I am looking for a report that shows the account of tickets made per month of a technical assistance group. Particularly the Help Desk group. I would be grateful if anyone could help. Thank you.
Difference between two dates in days
Hello I have the following query: select qd.QUEUENAME "Group",wof.UDF_CHAR5 "Weekly Meeting",qd.QUEUENAME "Group", ti.FIRST_NAME "Analyst",wo.WORKORDERID "Request ID",wo.TITLE "Subject",N.NOTESTEXT "Notes Text",wof.UDF_CHAR4 "Vendor_Name",aau.FIRST_NAME "Requester",std.STATUSNAME "Request Status",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.DUEBYTIME) "DueByTime", longtodate(wos.last_tech_update) ,longtodate(N.NOTESDATE) "Notes Date" FROM WORKORDER wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID
Daily Work log Reports between modules
Good afternoon, Currently we track technician time mostly on incidents. We want to better utilize the projects and changes module, but the biggest thing that keeps us from doing that is a easy way to keep track of daily time. At the moment time is not added across the different modules in service desk. Below is a screen shot of the lay out of the report we use, can we get a MSSQL query that looks similar to this where it will pull work logs from the changes and projects modules and add total times
Report to track incidents progress
there are many questions in the forum regarding timespent on the requests, however none of the provided reports /custom report actually worked with v9. in short we need to find out how much of time each technician spent working on ticket (since assignment to him till he push it to other queue - assign it to different team) how can we get report for this and to output sum for each technician for MSSQL thanks for your usual support
Report to show number of tickets closed / resolved by site
Hi im looking to build a report which shows which technician has closed / resolved tickets on each site Thanks Postgres Version : 9.2 Build 923
Report to count number of tickets open for each requester
Hi im looking to build a report that does a count of each open ticket per requester Thanks Postgres Version : 9.2 Build 923
Report to show count of tickets in a particualr group
Hello I'm looking to build a report that will do a count on the number of open tickets assigned to a particular group Thanks Postgres Version : 9.2 Build 923
Add task title to Query
Hello how i may add the "Task title" to the below query? select top 50000 "ti"."FIRST_NAME" AS "Assigned Technician", "wo"."WORKORDERID" AS "Request ID", "wo"."CREATEDTIME" AS "Created Time", "sdo"."NAME" AS "Site", "ct"."TIMESPENT" AS "Time Spent", "rctd"."FIRST_NAME" AS "Time Spent Technician", "ti"."FIRST_NAME" AS "Assigned Technician", "ct"."DESCRIPTION" AS "Time Spent Description" FROM "WorkOrder" "wo" LEFT JOIN "WorkOrderToCharge" "wotoc" ON "wo"."WORKORDERID"="wotoc"."WORKORDERID" LEFT JOIN
Custom Query Not Running | HELP
Hey All, I am looking to setup a query that will return the following information: All Technicians Names All Technicians Email Address I have been trying a few different query's and for some reason none of them are running, or they are returning errors. Any help would be great! Thanks! Jeff Day
whole report of workstation changes
Hi Dears I need a query report to see all changes of the workstation from the first time that is scanned. i need to determine the periodic date for this changes. for example show me the changes from .... date up to .... date im using servicedesk plus version 9.1 MSSQL So Thanx
Request collaboration and notification bell doesn't work
Dear developers! Please help me. I have problems with request collaboration it doesn't work. I'm already try all known solutions but it doesn't help. Server.xml is ok.
Problem creating backup and upgrading
When I run the backup and export the log from the bat file I get this error: Error = *Invalid object name 'ServiceReq_302' .* Query - SELECT max(WORKORDERID) FROM ServiceRew_302 ERROR = *Invalid object name 'ServiceReq_302' .* I have checked the SQL database and no table exists for ServiceReq_302 our servicedesk client is running fine however it is several versions out of date and I was looking to upgrade it. I can't upgrade it without backing up the database because it is on a separate server and
Asset module is getting wrong model for Lenovo workstations "ThinkPad T430 (23498R7)" by Agent
Hi Team One of our customers is reporting that SDP is showing wrong model, as you can see in first screenshot, Correct model is ThinkPad T430 (23498R7). We perform a test executing the ae_scan.vbs and the xlm gets the correct data, I think the Agent is getting the wrong data, I'm attaching the xml result from ae_scen.vbs.
urgancy
In the reports tab, how to add more columns in the "Available Columns"?
Report to show how many new requests assigned to a certain group for last week
hi all I'm looking to build a report that will show me how many new requests were created and assigned to a particular group for last week Thanks
how many long duration servicedesk plus record the asset's log changed?
Hi Dears I want a whole history change of some workstation from the first time that system is recorded in the system, but search when i search a detail of this workstation from the web of servicedesk plus it has just return a 15 day details and when i search it in DB i can just see the 1 month recently history of it. is servicedesk plus record all of the changes from the first or just a recently month? if the answer is yes how i can access the history of some workstation.? i need a query to access
Java error when running Query report - string index out of range
I have a number of Query reports that I created earlier this year. The queries themselves run without issue in SQL Server Management Studio, other than the use of LONGTODATE. But the reports error when I run them from within the SD Reports module. This error is displayed - java.lang.StringIndexOutOfBoundsException: String index out of range: -1. Has anyone else gotten this error? We recently upgraded from 9.2 Build 9229 to 9.2 Build 9235. I don't think that this error came up until the upgrade
Printable Service Request catalog.
Is there a way to print out my service catalog? My boss would like a copy to show to people on what we are doing and to what it looks like. Please let me know if anyone has had this request before. Colby
How long time have been spent by every support group?
Our support technicians are divided Tier 1, Tier 2, Tier 3 teams, when end user call helpdesk (SDP), our T1 support techincian will remote support firt, if can't fix it will flow to T2 support team - on site support. if still can't fix it will flow to T3..., so many requestments need mutil support team solved it, and I want to check every team's time efficiency every day. need the reporting include, how to generate the reporting? Requestment ID end user Spent time
To be assessed SLA breached
Evening all, I'm looking to build a report, so that i can view the to be assessed which have % of the number of requests that have had a 30 minute SLA breached. This would be for a specific group servicedesk. If possible can i set it for the current week Thanks
Total count on a query
Hi all, i have the following query but would like to place a count of the total number of tickets resolved. What would be the best way to achieve this please. Thanks in advance select MAX(aaa.first_name) "Resolved By", COUNT(Distinct workorderid) "Count of requests" from workorderhistory woh left join aaauser aaa on woh.Operationownerid=aaa.user_id where (operation='Resolved' or operation='CLOSE' ) and ( aaa.first_name like '%tech1%' or aaa.first_name like '%tech2%' or aaa.first_name like '%tech3%'
Projects - Query Report request
Hi, We are about to start using our Projects module fairly extensively, due to the lack of being able to associate a purchase order with a Project we wish to be able to report on associated Service Requests that have associated Purchase Orders to essentially have a total cost of each Project (I do realise there is an 'Actual Cost' field available however this is a static field). Fields required would be from Project Module - Project ID, Title, Status. From Purchase module - Total Price where PO
Report Feature Requests
1) Ability to alphabetize/sort the Report Folder List 2) Ability to make nested folders 3) Granularity in security permissions to view/edit/create/delete to the report folder level 4) Ability for the filtering to be customized and run by technicians who do not have the ability to edit the reports. Minimally it would be nice if date ranges could be set without requiring report editing permissions Under the current model too many people require reporting editing permissions-- if its this open you end
Adding Notes Column to existing reports
Hi I have a report I have an existing report that I would like to add a column for for notes. Using postgresql please see below for existing report. . SELECT cd.CATEGORYNAME AS "Category", wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", cd.CATEGORYNAME AS "Category", scd.NAME AS "Subcategory", wo.TITLE AS "Subject", wotodesc.FULLDESCRIPTION AS "Description", urgdef.NAME AS "Urgency", ti.FIRST_NAME AS "Technician", pd.PRIORITYNAME AS "Priority", std.STATUSNAME AS "Request Status",
Reporting on Conversations
Is it possible to run a report on the number of outgoing conversations (replies) that a technician makes?
Custom Query for Closed / Resolved Previous week
Hi all, i have the following query which works for the resolved but i would also like to include closed What would be the best way to incorporate both resolved and closed in to the report Thanks in advance select MAX(aaa.first_name) "Resolved By", COUNT(Distinct workorderid) "Count of requests" from workorderhistory woh left join aaauser aaa on woh.Operationownerid=aaa.user_id where operation='Resolved' and woh.OperationTIME >= <from_lastweek> AND woh.OperationTIME <= <to_lastweek> GROUP BY aaa.USER_ID
Query Report - Matrix Format
Hello, Is there a way to create a matrix report based on a custom query defined by the user? Specifically - I have created a query that provides the output below, but I would like to have the year as the column headers and the count by product type below it. Thank you, James
SLA Reporting - Actual Ticket Open Time
Hi there, I need to know the actual time the ticket was open and with the technician. I want to exclude the waiting and on hold times and find out the exact time it was with the technician. Any help in getting this information from the reporting would be appreciated. Thanks and Regards, Augustine
Next Page