Custom query report
Can you help me with a mysql query for searching after all solutions that haven´t been updated the last 6 months or the last year. This is because we want to review the solutions and see if they are still valid. Some kind of reporting on solutions would be nice in the reporting module. Regards Stefan
Duplicate Users
Are user accounts being created based on the E-mail ID and are these suddenly case sensitive? I am suddenly getting duplicate users being created (who have existing accounts in the system). This is going to become a nightmare to manage if this is the case! Further investigation into this would suggest that it is based on the username rather than the E-mail. I have changed the case of an E-mail Address and a new account was created. The difference was that the username for the original account was
E-mail Spam Filter
Seems that the Spam Filter isn't working the way it used to... While new calls aren't being created, existing tickets are being updated. This means that Auto Responders and Out of Office mails are updating tickets when we wouldn't want them to. This can cause a problem with looping!!!
SDP 8.0 Firefox Compatibility
SDP 8 Doesn't look right in FF 3.6.12. Looks fine in IE8 but not FF which has been fine up until 5 minutes ago when I upgraded. See attached screen snips for confirmation
Help with simple report
I created a report that does the following: Show me all of the assets that have a resource state of "Disposed" It works great, but now I would like to be able to filter it out by the Resource Ownership History. his is where the actual date(s) of this asset are tracked. What I would like to be a ble to do is run a report that shows me all disposed assets from a selected date, to a another selected date. Ex. Jan. 1, 2010 to current. Any help on this? Below is the query code for what I have
Report Request
Hi, I need a report that contains reqID + time spent on every status until resolved ex. workorderid status time on this status (hrs) 1 open 10hrs in progress 1 hrs authorizing 2 hrs deploying 4 hrs Using SPD 7.6.0 Build 7611 with MySQL DB
Custom Weekly Ticket Report
Hopefully someone can help me out with this. I currently have two weekly scheduled reports. One listing tickets closed during the week and the other report listing what tickets are currently open and on hold. Is it possible to combine the two reports into one? The report needs to contain a sort of snapshot per se of what tickets are currently in the queue, open and on hold and any tickets closed during that specific week. The fields to include in the report are: Requester Creation Date Request Status
Re-`install SDP Error
I am trying to install OpManager. I previously was using the free version. I ran the uninstall from the Control Panel. Now when I go to re-install OpManager I get a message saying 'do you want to uninstall opmanager?'. I reply yes, then get a message telling me that the OpManager service is being removed. The process runs to completion. I then try to run the installer again, and get a message asking me if I would like to remove Opmanager. I then get a message saying the service is being removed.
Users - Technician List - Deleting a member from site deletes from all sites
Hello, I am working with the demo SDP 8.0 beta and I have created three seperate sites and have all set as custom for their settings. In the Users - Technician list, I am able to choose association pull down menu and all are customized as they should. As soon as I say delete a technician who is in multiple sites, it deletes for all of those sites and not just for the one I have selected please help
Modify sample KPI report
Can someone modify this repor ? I'd like to use "lastmonth", "lastquarter", "lastweek", etc. select count(a.workorderid)"Total Request Count",SUM(a.isoverdue)"SLA Violated Request Count" ,sum(!a.isoverdue)"SLA Not Violated Request Count", (sum(!(a.isoverdue || a.ispending)) /count(a.workorderid))*100 "% Calls Closed within SLA" from (select wos.*,sd.ispending from workorder wo inner join workorder_threaded wot on wot.workorderid= wo.workorderid left join workorderstates wos on wo.workorderid
Report requirement
We would need report in servicedeskPlus for requests with no updates from past 1 or 2 or 3 or 4 or more days. No Updates means if there is no worklog, no conversation added then that request should be part of the report. Regards Santosh Giranje
MySQL Query - Assign Time Taken > 4 Hours
Hello, I need to create a report for a KPI we plan to implement on our service desk, but I am having a problem getting the exact data I need. I found a MySQL query on this forum that is almost correct but I dont know enough about the table structures to change the statement myself, please can someone help! :) What I need is to change the where clause of the statement below to only show requests which have a pickup time greater than or equal to 4 hours, but also keep all the being pulled the report
Report
Hi, Would it be possible to show the tickets list and group of conversation followed via mail?. for example: ticket 1 Object "problem X" open in date 1.1.2010 12:00 - closed in date 1.1.2010 14:30 -date 1.1.2010 12:00 Administrator to Person A - Subject 1 -date 1.1.2010 14:00 Persona A to Administrator A - Subject 1 -date 1.1.2010 14:30 Administrator to Person A - Resolution ticket 2 Object "problem Y" open in date 5.1.2010 12:00 - closed in date 6.1.2010 16:30 -date 5.1.2010 12:00 Administrator
Report needed
Do you know if there is a way to report on incidents that were resolved by a technician, but then re-opened by the requester? Thanks in advance
How many people have what roles?
I'm trying to determine how many people have a given role. For example, how many people have the SDAdmin role in my instance of SDP. So far I've built this: SELECT * FROM AaaAuthorizedRole aar LEFT JOIN AaaRole ON aar.ROLE_ID=aaarole.ROLE_ID LEFT JOIN AaaUser aau on aar.ACCOUNT_ID=aau.USER_ID WHERE AaaRole.NAME='SDAdmin' But the problem is, the results don't list my user account which I know for sure has SDAdmin rights. Am I looking at the wrong table? Is there another table that deals with Technician
MS SQL Schema Map?
Has anyone mapped out the full Schema of SDP 7.6 in MS SQL? This would be incredibly useful for generating my own reports. At the moment, I'm trying to track down the creator of a Change ticket (different from the Requester and Technician.) Thanks!
TimeSpent Report by Technicians
Good day. How can I get a report which indicates time spent by every technician worked on specific request? For example, a techician worked on a request, then the request was re-assigned to another technician,etc, i need information about every technician (how many time he spent) worked with the request. Thank you
Amount of Calls per hour in a day
Any chance you can suggest how we get a report with this information so that we can see the peak times for calls during the day? This will help us to make sure we have the correct amount of cover available. Many thanks
Report: Software and where it is installed
Good Afternoon, One of my Managers is interested in creating a report that will show where managed software is installed. For instance, Lets say we have 3 systems that have Visual Studio 2010 installed. THe report would look something like this: Software Manufacturer Purchased Installed Max Used System Installed On Visual Studio 2010 Microsoft 3 3 3 Laptop1, Laptop2, Laptop3, Is this possible? Thanks. ~James Murphy ServiceDesk 7.6.0 Build 7608
SDP Create Time Report: Using specific times
Is anyone able to help, have been tasked to provide a twice daily report showing generated requests created in a 12 hour window. First from 07:30 ending at 19:30, the second 19:30 to 07:30 the following day. Advanced matrix doesn't allow so now looking at query editor which is beyond me.
MSSQL script needs assistance please
I have a mssql script then when run on the sql server against the manage engine tables produces the results that I require, ie the top ten callers for the period specified. When I try running this directly in ManageEngine I get query errors returning, can someone please take a look at the query and advise what needs to be in place to run the query in ManageEngine please. SELECT top 10 aau.FIRST_NAME "Requester",max(dpt.DEPTNAME) "Department", count(aau.FIRST_NAME) FROM WorkOrder_Threaded wot
End of Year reporting: please help adjust query
I have a working query that shows me the total# of Request and whether they met the SLA for the running and last quarter. I want to get this data for all of 2009, on a per month basis. Could someone show me how to adjust this to given me January, then Feb, March, etc? Thanks, SELECT COUNT(wo.WORKORDERID) 'Total',(SELECT COUNT(wo.WORKORDERID) FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN WorkOrder_Threaded wot ON wo.WORKORDERID=wot.WORKORDERID WHERE wot.WORKORDERID=wot.THD_WOID
MSSQL query Report
Report for percentage of completed requests by group,level and technician
Monthly KPI report
Hi, I've been trying to update our Monthly KPI report, along with a Last Monthly KPI report that I created. Unfortunately the report as it stands is combining the current months totals with last years totals for the same month, so I've been trying to fix that. Here's the Query that I've been using, but all I receive is an ajax error: select count(wo.WORKORDERID) 'Total', (select count(wo.WORKORDERID) from WorkOrder wo left join WorkOrderStates wos on wo.WORKORDERID=wos.WORKORDERID left join
Man Hours Logged for Entire Year Report
I have a group called "Help Desk" that I'd like to run a report for the total Work Log hours entered for the entire year for all technicians. The problem is I have some techs that have moved on to other teams in IT and aren't in the Help Desk group anymore. Is there a report I can run that will capture time entered against that group regardless of current group membership?
Report Needed Please
I am in need of a report that shows all requestors and technicians with the following fields: login name email address full nameThanks for your help!
Query for request which was overdue before due time changed
Hello, We have such problem when HD workers changing due time after request starts to be overdue, and we cant see this requests in overdue report becouse of this. How can we make a query, is it possible?
Help with a MySQL query
I could use some help with a MySQL query from the SD+ Support crew. I would like to... Add a "Request ID" column as the first column in this report Change it from "Requests Completed Last Week" to "Surveys Completed Last Week" Below is the query as it stands today. Please reply with any an updated query including the changes I've described above. SELECT MAX(wo.TITLE) "Subject",MAX(aau.FIRST_NAME) "Requester", DATE_FORMAT(FROM_UNIXTIME(MAX(wo.CREATEDTIME)/1000),'%d-%M-%Y %k:%i')"Created Time",DATE_FORMAT(FROM_UNIXTIME(MAX(wo.COMPLETEDTIME)/1000),'%d-%M-%Y
Changing the title of a report
I have a custom report that I use on a daily basis but the title is 'untitled'. How do I change this so it is something useful? I am using mysql as the database. Thanks Shaun
[Resolved] Reports : Export XLS
Hi, I updated my version of ServiceDesk Plus to the version 7608. But I noticed two things : some of my reports programmed have gone and I can't export my reports in XLS format (other formats works). The pdf document attached is the error generated by the Help Desk. Any Ideas ? Regards Bast
Requests with no notes added in last 7 days
Hi Could someone provide me with a report that shows me the requests that have had no notes added within the last 7 days. RequestID - Status (Open, On Hold, Awaiting 3rd Party) - Technician. I am using MSSQL and on v7604. Thanks Mike
Query
Hello! I need to write a query that displays the list of applications last week, closed more than once select woh.workorderid 'Application', aaa.first_name 'Specialist', aaau.first_name 'Requster', WO.Title 'Title', count(*) 'Count closes' from workorder_threaded WOTH Inner JOIN WorkOrderHistory WOH ON WOTH.WorkOrderID=WOH.WorkOrderId left join SDUser SDU ON woh.operationownerID=SDU.userid left join AaaUser AAA ON SDU.UserID=AAA.user_ID left join workorder wo ON woh.workorderid=wo.workorderid
Custom Report - Number of days open by SLA?
Hi, I'd like to create a series of reports showing the date it was created, the date it was closed, and calculate the number of days/hours it was open for each SLA we have set up - I need this to ensure our average closure rate (days/hours) is being met against target. Anyone know how to do this - looking at the raw data, the date/time fields are in a numerical format. Thanks
Report to show reopened ticket
Hi all, I like to create a report that shows all reopened tickets by the requester. (We want to know how often we didn't provide a correct solution on the first try). Any hints how to get this? Thanks, Alex
Custom Report Request - Calls Logged By Time
Support Im hoping you can help me, im looking for a report that will give me a hourly summary of the number of tickets raised by the hour across the week, so that staff can be rostered for the times the calls most require it. Ive attached a snip of the sort of report im hoping to generate, any help would be appreciated. Cheers - Ben
Timespent Report
Hi, I am after a query report as shown in the attachment. I have tried creating my own sql query with little success. I also need the option of adjusting the date range to suit my needs. We are running the mysql backend. Many Thanks Shaun
Report for requests that had been closed the same day they had been created
Hi all! I need to find out how many requests had been closed the same day they'd been created. Is there any hints how to get this? Thanks in advance!
Report of requests re-opened by users
Hello! Is there any possibility to make a report of requests re-opened by users? Regards, Evgeny
Need a query
Could anyone help me querying a specified software I'm trying to get a report who shows all workstation which has "J2SE Runtime Environment 5.0 Update 22" Within sites
Asset scanning status report
I have the following Query report that provides me with the last scan date and scan status of each item in ServiceDesk. What would I need to add, in order to include the Resource State of that PC? This would be very useful for auditing. We use MSSQL. Thanks. select systeminfo.workstationname "Workstation Name", "Model",dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (audithistory.audittime/1000),'1970-01-01 00:00:00')"Last Scanned on", audithistory.auditstatus "Scan status" from audithistory
Next Page