Report Filter Value List Only Shows 86 Users
Currently, my requesters list is showing 92 users (this is after going through and cleaning out all the random email addresses from vendors that send to our ticketing system and all the extra user accounts from AD that are added because your system still can't be told what user groups to pull in). We've set up a report that we can use to print out a page that displays assets that are attached to a specific user. However, when we go in to edit the report, scroll down to advanced filtering, and click
I can not search for a request after the upgrade to V7.6.1 B7605
I can not search for a request after the upgrade to V7.6.1 B7605. The search gives me 'No request found in this view.' Regards, Hassan
Scheduled reports issues (.pdf blank, .html not showing logo)
We are trying to produce a scheduled report to send to automatically send to our business partners, but we can't seem to get it working right when we schedule it. When we generate once, everything looks fine. When we schedule .pdf version, the .pdf attachment is blank. When we schedule .html version, we get data, but the logo we use does not come through. What information do you need from me to help us figure out this issue?
Report outlining categories and respective SLA agreements and escalation definitions
Is there a way to pull this info into a report in the software (by doing a query)? We need to have a "mapping" of the categories, subcategories, items in consjunction with the respective SLAs (including escalation response times and escalation responsible individuals).
Report on Workstations without PO
Hi! SD 7.6, MS SQL Please, how modify this reports to add users name to workstations? select WORKSTATIONNAME from SystemInfo where WORKSTATIONID NOT IN(select distinct WORKSTATIONID from SoftwareInfo sinfo LEFT JOIN SoftwareList slist ON sinfo.SOFTWAREID=slist.SOFTWAREID where SOFTWARENAME='symantec endpoint protection client') GROUP BY WORKSTATIONNAME Change 'symantec endpoint protection client' to soft you needed.
SD+ and external reporting/BI tools
Hello, I'm working on some dashboards to create real time reports directly from the SD+ database. I'm using Tableau for this, but anyone with experience from other tools or knowledge of the database layout should be able to help me. One of the first things I run into is that I have WORKORDERID entries which are not returned when I use the internal SD+ reporting tool, but that are included when I query the db directly. It appears that all these entries are replies or forwards on messages that already
Help with this Report Query
I am trying to generate a custom query report that groups Requests by Template ID and Status. I am new to MySQL, so any help is appreciated. Below is my attempt. SELECT rtl.templatename "Template Name",std.STATUSNAME "Request Status",wo.WORKORDERID "Request ID",mdd.MODENAME "Request Mode",dpt.DEPTNAME "Department",ti.FIRST_NAME "Technician",sinfo.WORKSTATIONNAME "Workstation",std.STATUSNAME "Request Status",longtodate(wo.CREATEDTIME) "Created Time",wo.TITLE "Subject" FROM requesttemplate_list rtl
Asset Report
I would like a Custom Asset Report including the Asset Name, User, and Resource Type. Would this be possible?
different results between flash and matrix report
I have different results between flash and matrix reports. What is the Problem? The Query of the matrix report (result is in the attachment)is the following: SELECT wo.CREATEDTIME "Created Time",sdo.NAME "Site",wo.WORKORDERID "Request ID" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID 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
First Quarter Report
Hi I need your help to make the first quarter report by Category and I need to change the date as well The report will be like this Category | Open | On hold | Resolved | Close | Not met SLA | Closed within SLA And another report by Technicians and I need to change the date as well Technicians | Open | On hold | Resolved | Close | Not met SLA | Closed within SLA Thanks
Total Asset By User Or department
Is there any way to get the report of all asset attached to the partuclar user or department. Like i want to check this indivisual user having homany asset for example printer scanner workstaion or any other non it asset. Please let us know.
Simple survey report
This query will provide a quick numeric snapshot of your survey results by question. So, if you have 4 satisfaction levels you will receive back a number from 1-4, with 4 being a perfect score. SELECT sqdt.QUESTION "Survey Question",round(avg(sadt.RATING),2) "Average Rating" FROM SurveyPerRequest spr INNER JOIN SurveyPerRequestExt spre ON spr.SURVEYID=spre.SURVEYID LEFT JOIN SurveyDetails sdt ON spre.SURVEYID=sdt.SURVEYID INNER JOIN SurveyQuestions sqdt ON sdt.SURQUESID=sqdt.SURQUESID LEFT JOIN
Asset Report
Hi I am after generating a report but cant seem to get the information using the wizard as i want the service tag including. I would like a report that shows the following for ALL assets not disposed of. Resource Name Product Product Type Asset Tag Serial Number Service Tag User Department Any assistance greatly appreciated. Regards Mike
Parameter Query in reports
Hi, I would like to run a report using the Timespent module but use a parameter query to enable users to select a date period using a prompt before running the report. Is this possible?
Report Request - All Activity in a day
Hello - Hoping someone can help. Has a query been created, or could one be created to track all activity in all tickets in service desk for the current day? This is a report I have to run at the end of each day - this should include everything, ie new tickets being open, ticket assignments, notes being added, tickets being resolved/closed/assigned, etc. Thanks in advance.
Request for Report
Hi, In SD 7.5 I need to draw a report showing computername+last login (user). It' doesn't seem that the "last logged in" field can be chosen when designing a custom report. How would the Query be in MySQL? /Regards
'Location' field query
I'm trying to use the Query Editor to produce a report that includes the 'Location' field for an asset but I can't seem to find the right combination of table and column names to produce the output desired. I keep getting errors similar to this one in the 'Log' field: The column prefix 'locationDef' does not match with a table name or alias name used in the query. Can anyone help me by defining the correct table name, alias name and/or column prefix to allow my report to run and give me the 'Location'
Report for Resolved/Completed Tasks Today
Hi! I wonder can I make sheduled report that will display all requests, that have been resolved and completed today It is necessary for IT Director to view not only completed (because not all requesters will close their requests) but and resolved requests. Thanks for you support
Report Request - Help Please!
Hi, I need to create a report as follows. Any help would be appreciated: Format – csv Requirement - The number of incidents open for the month, broken down by category, sub category and item and grouped by Team. Frequency – This needs to be produced each week on a Thursday morning at 9am. So for example 1st – 7th march 2010, then 1st – 14th March and so on and so forth until the end of month is reached. Any help would be much appreciated, because my SQL knowledge is not great. We are running ServiceDesk
Help with a report for Outstanding calls for a given date.
I am fairly new to Service Desk reporting and require some help please. I am after a report that will show me all the outstanding calls, (Not Closed) for a given date for a particular group. Basically this. For the 1st December 2009, i need all the outstanding calls for the Service Desk group. I cannot see how to do this in the wizard. Please help.
Shutting down a domain server (to use a new named one) caused problems
We had cause to change the domain server for one of the windows domain. Once SD+ had started it's daily scan, we noticed that it hung, and we could not gain access. if we re-booted, we could gain access for a short time, and did have time to change the domain controller it needed to use for the 2nd windows domain. We continued to have issue for some time, before it finally came right. The issue seems to be that if a domain controller is not found when it starts it's scan, it does not fail gracefully
Custom Report Help
Please could someone help with a custom report. I need to report on Resolved Time, as well as Closed Time but this isn't shown anywhere. Could someone provide the query that will show the following information:- Ticket ID Requester Technician Priority Category Sub Category Group Status Created Time Resolved Time Completed Time Thanks, Paul
Descriptions and resolutions disappear when saving or closing
I have had many users complain and experienced the problem myself where a description or a resolution disappears when saving or closing a request. I am on 7603 but have had the issue on previous versions. The issue seems to happen more frequently since upgrading to 7600. Has anyone else had this issue?
Software Changes Audit Report
Hi Is it possible to get a report that tells me what software was installed or removed during the last 12 months. Regards Mike
Holiday Reports
Hi, Do you have any up to date query reports for holidays. Specifically looking for a report showing dates booked for each technician, but any other holiday reports would be welcome. ServiceDesk 7.6.0 Build 7602 Thanks Mark.
Reporting on re-assigned/escalated tickets
Is there a way to do a report on a re-assigned and escaleted ticket? I think this would be a handy feature - considering that most requests can be potentially be worked on by one tech for the majority of the time and then would have to re-assign it or escalate it. The original tech should have some metrics measured on his/her input on that ticket.
Attachements go blank after duplication
We recently upgraded to 7.6.0 Build 7602, and have noticed that when we duplicate a ticket that has an attachment, the attachment is blank on the new ticket. I searched Known Issues and did not see this.
Request additional fields query report
I made 3 additional fields for a form as a number type. I need to extract data from those fileds in order to make a report that calculates something. How do I know the name of those fileds in the tables? Or how can I make this kind of report? Please advice. Best Regards Denis M.
Request loses group and technician when Request Status changed via Edit Request from filtered view
If we are viewing our tickets in a filtered view (that is, a list of Open Requests, Pending Requests or some other custom view) and check to select the ticket then click the Edit Request button at the top, then only change the Request Status, the request loses Group and Technician assignment. If you look at the screenshot, this is what we see in the history tab, making it appear that the Technician actually changed those fields when in fact ONLY the Request Status field was adjusted. Let me know
report request
Hi guys, I need some help with a report I would like to have a report for MSSQL that looks like below. I think the bigest problem is the fact that I want to use the resolved time and NOT the closed time to generate this report. ------------------------------------------------------------------------------------------------------------------------------------------------------- Resolved requests per month per level jan feb total prio 1 5 10 15 prio 1 < 4h 2 6 8 prio 1 < 8h 4 9 13 prio 2 10 20 30
Reply templates
Our default reply template from a request is configured to pick up details from the ticket itself such as Requester Name and Technician. I've based my other reply templates on this same logic but instead get the $Requester and $Technican in the reply rather than the value. Can't the custom templates also pull information from the request?? Jennifer
Costing Report with Sub-categories
Morning all, I have been using the below query to report out a list of all IT/Non-IT assets including the cost. However I need to edit it to show the different sub-categories of assets. Eg. Show whether a workstation is a Laptop or Desktop. Show what is a server, what is a router etc. Then when I export the report to excel, I can filter via category for ease of use. Database is: MySQL Any help appreciated! Query below (Which i grabbed off one of the many reporting threads anyway :) )
Asset reports showing warrany expiration date
Is there a report or can one be made that shows the warranty expiry date for all laptops. The field is in the assets but I don't see a report or custom reports option to show this.
When opening a ticket then the wrong ticket opens (always same wrong one)
When opening a ticket that's new, when you click on the link in the list view then it always opens ticket 116 (which is closed). If the ticket was assigned, then it opens normally. Removing part of the URL that opens seems to help (stripping the query string all the way back to the ticket number). This is an issue occurring on Firefox and Chrome, but does not seem to affect IE.
Assigned to Technician notification not going to everyone
We recently upgraded to 7.6.0 Build 7602, and several technicians are reporting that they are not receiving a notification when a ticket is assigned to them. As I am receiving notifications, and have verified that this option is selected in the Notification Rules, I'm unsure what to do to correct this issue.
Need to be SDAdmin to create Custom View or View Reports
Hi, We have found that you need to have the role of SDAdmin in order to create Custom Views or view Reports. If you do not have the SDAdmin role an error will be thrown when saving the Custom View and when viewing a report. Steps (without the SDAdmin role): - Create custom view button - enter filter details - save - error Or - Reports tab - select report - error I know this is not environment specific as we have tried IE7, IE8, Safari, and Firefox on Windows and Mac machines.
Report request please! - Requests not updated for 8 hours
My SQL query skills are not great and therefore I'm wondering if someone can help with the report below. I need to create a ServiceDesk report to report on all open requets that are allocated to a group and technician, but have had no updates for the past 8 hours. The report results need to be grouped by 'group'. Any help would be much appreciated. Thanks,
2 approvers - only 1 can approve the other gets only reject button.
Hi, When i making a PO and selecting 2 approvers at least the first one send the approval and when the second one logins to see the PO he can see only the reject button. We need at least 2 approvers to complete the PO and make it approved. Regards, C.K.
Report of SLA's as configured
I need a report of the SLA's as they are configured within the system. Looking through the database it seems the SLA's are stored as parts of SQL select statements that are controlled by the master SLA table. If someone can advise how all the tables hang together underneath the main SLA table I'd appreciate it, if there is a SQL statement to extract it all that would be perfect. Appreciate the help ASAP please so I can check the setup of our SLA's are as required, as they are more complex than I'd
Hardware Summary Report (Workstation summary reports)
- Can I customize this report? Edit the layout, change the font, color... - Can I add another data to this report? I see only Memory Details, Network Details, Disks and Drives... I want to add Video Card Name, Video Card Memory, Sound Card Name, Last user login to this report! PS: Version 7.6.0 Build 7602
Next Page