Add Notes to report field?
Hello, Is there a way to create a custom report to include the Notes field, so for example I would have a report with the following columns: Note --- Subject --- Requester Name --- Assigned To --- Group --- Status --- Created Date --- ID For the Note column, it would only need to display the most recent Note added or last note updated? Is this possible? I can't seem to find a way to do this or even a way to simply add the Note field as an option in a report. Any help would be appreciated. Regards,
Custom hardware report
Hi. Is it possible to create a custom report that would display a list of computers and the serial number of the monitor attached to them? It would be perfect if the report would generate the following list: - computer name - computer model - computer serial number - monitor model - monitor serial number For example: - sales1 | HP DC7900 | CZC814325 | HP L1706 | CNC4324356 -sales2 | ................................ Thank you in advance for your reply Adrian
custom report error
We're running 7512. When I create a custom report with the following settings, run fails with "Error executing SQL statement for : AdventNetReport." report type: tabular module: requests display columns: Request ID, Category, Subcategory date filter: Completed Time, Last Quarter advanced filtering: didn't set group by: category order by: category, subcategory summary type: Request ID, count
Query problem
Any tips on what I'm doing wrong here? Table schema is Requests: SELECT CategoryDefinition.Categoryname, WorkOrder.Title, WorkOrder.Description, RequestResolution.Resolution FROM WorkOrder JOIN RequestResolution ON WorkOrder.workorderid=RequestResolution.requestid Workorder JOIN WorkOrderStates ON WorkOrder.workorderid=WorkOrderStates.workorderid WorkOrderStates JOIN CategoryDefinition ON WorkOrderStates.categoryid=CategoryDefinition.categoryid When I run that, I get "java.sql.SQLException: Incorrect
Identify table / tables that contain fields used in a view.
Hello. I am trying to include the 'is leased' field on a report. However, I am not finding the field in any of the online schemas. Should I be looking somewhere else? If you go to assets...and review an active asset...you should see a yes / no field called / named is leased. Where is this field in the database schema? Thanks, Chuck
Response/Created/Closed Time Report
Dear Help, The following MSSQL statement below produces report 1. We would like it amended to produce report 2 please. It’s important however that the ‘Responded Date’ is not the automatic generated response from the application. It has to be a note or work log entry from a technician. Thanks for looking, Stef SELECT wo.WORKORDERID "Request ID",ti.FIRST_NAME "Technician",dateadd(s,wo.CREATEDTIME/1000,'01-01-1970') "Created Time",dateadd(s,wo.COMPLETEDTIME/1000,'01-01-1970') "Completed Time",dateadd(s,wo.RESPONDEDTIME/1000,'01-01-1970')
Request Reporting on Additional Fields
We have added an additional field to our request template and it gets populated for every request. When in reporting we are unable to see the additional field and are unable to report on it. How can we report on the additional field? Thanks, Chris
Closing a job from the resolution page
Service desk plus 7.5.0 Build 7513 We have a rule that requires a technician to be assigned to a job before it is closed. When closing a job normally, we get a pop up box to notify us if no technician is assigned. If we close a job from the resolution tab by using the drop down box at the bottom of the page, it will save the resolution text, but the job doesn't get closed - but there is no popup to inform you of the rule, or the failure to close the job.
interactive report
Is there a way to have teh en-user input a specific parameter into a query so as to get a report. It's like an interactive report, generic and then the user will just type in the specific asset they want to know about and then the report will run. Kieron
webinterface errors in safari
SD+ webinterface errors in safari (browser warnings, some positioning errors) but if changed useragent to firefox – all s ok
Attachments are not deleted?
I have found that attachments to Incidents/requests that have been deleted in ServiceDesk are still on the system. I have checked for attachments to deleted job numbers in (AdventNet\ME\ServiceDesk\fileAttachments\Request) storage area, and then searched in ServiceDesk Plus for the associated job number and nothing comes up but the attachment is still there! We have systems that send logs to our ServiceDesk and often these just need to be deleted, now that I have found that the attachments aren't
Query on all registered requesters
Is it possible to access the table where all possible requesters are listed? A regular report on changes would be very helpful to me since I could use this to check for deleted users to cross check the user management process of disabling/deleting accounts. Another report that would be useful to me is a report that lists requesters/user per site.
edit requester by technician
Hi, we recently upgraded from 7.0.0 to 7.5.0 (build 7500) With version 7.0.0 common technicians were able to add & edit requesters. with our current version (7.5.0) one needs admin rights to edit a requester... is this intended? /Tomas
We have been using the Authorizations functionality for some time and
We have been using the Authorizations functionality for some time and would like to report on this rtrending. I have scanned the tables and I cannot find anthing that is what I am looking for . Can someone please tell me where I can find this and if anyone has a base query to start with I would appreciate it.
Response timings
I want to know how to calculate response timings. I am assuming: created date = time ticket was log; responded date = time it was first updated (ticket assigned/updated for the 1st time). But i noticed whenever i created a ticket, my created date is equal to responded date. Please help! Thank you for your help in advance really :)
Admin reports
Hello, I am looking to create a two reports for internal auditing of ServiceDesk access. Having trouble doing this through the GUI report creator. 1. A report detailing "role" access to the system. Who is an Admin, Technician, etc. 2. A report detailing all groups and their members. Has anyone created such reports and have an MSSQL query to share? I would suggest these types of reports be included as canned reports. Many thanks, Shawn
Last updade report
I need a report that shows how many days it has been since either the worklog or conversation was updated by one of my technicians in requests which are not resolved or closed. Is that possible?
Where is IP address information stored in ServiceDeskPlus database?
I have been exploring the ServiceDeskPlus database schema looking for the tables where asset information is stored. The Resources and Component tables seem to be where most of the information that I am going to need to access lives and I continue to explore them. One hopefully simple question... Can anyone point me to places where IP address information is stored in the schema? Thanks in advance for any assistance.
How can I view task history?
Currently, to my surprise, Tasks for a Change do not get logged into the History tab. Is there an easy query to view the history of tasks? I am interested to view whether the time/activity logged within the task is reflective of the actual time that the activity in the task was recorded. Future feature: Add task history to the History tab.
Priority Ordering in Requests view
I'm sure this has been raised before but the priorities are listed alphabetically and not logically. So, Priorities High, Medium & Low are listed as [ High, Low, Medmium]. This isn't logical.
Reporting on "tickets handled in past x days"
I'm looking for a way to report on how many requests were handled by the department (perhaps by technician) in the past x days. Typically it will be within the past 7 days. I also want to be able to separately two numbers: Number of requests on which the technician did something (asked for more info, researched, did testing, etc.), but the ticket is still open. Number of requests on which the technician resolved or closed the request. I don't fully understand how and when RespondedTime and CompletedTime
Dashboard Request Graph Report
Where is the sql located for the dashboard graph showing requests inbound, completed & overdue? I want to expand the report to get trends on a larger range of dates by day than a week at a time.
Custom Due by Report
I need to create a scheduled report with the following The report should show All overdue requests Or All requests with no due by date and the current date and time is greater than the created date plus 48 hours I would like to have the following fields shown in the report Request ID, Priority, Subject, Technician, Request Status, Dueby Time It should be grouped by Site. Any help please?
KPI on intervention time
Hi, I would like to have a report on intervention time. I use custom report / tabular report / request then I select the fields request id / subject / urgency / priority / created time / completed time / responsed date I would like to have a KPI report based on the elapse time between the created time and the responsed date. The problem is as soon as you add a worklog or close the request, the responsed date is the last action date, but I need the first responsed date. Does someone can help me
Robo Task fails w/ localized AD structure
We are currently evaluating SDPlus 7.5.0 b7509 and found this issue. RoboTask can't access localized (i.e. Russian) AD objects. We have OUs and CNs in Russian, and change password task fails with: [Info] adsPath : CN=pupkin,OU=Service_users,OU=Users,OU=???????????,DC=test,DC=local [Error] ADsOpenObject failed in ResetUserPassword. Err code = 0x80072030. Err msg = There is no such object on the server. Directory object not found. [Info] Reset user password operation failed.There is no such object
Report for All Assets
How can I get a report of all assets including Asset Components?
Need Software list Vs. Workstation report
Hello, I am using SDP Version: 7.5.0 Build 7509 I want Report template for Softwares list installed on each Workstation. Amit
Assistance with Reports
hello, can I kindly request some assistance with some reports, its obvious to me these reports would be impossible to produce as a 1 click solution without using a query. I need a report to: 1. display the level of requests (Eg) the level of open un-resolved, newly opened, and closed requests over a month period. 2. Mean time to respond (Eg) Average request response times on a previous month basis based on (initial email response) 3. Mean time to resolution (Eg) Average time to closure on a previous
Announcement deleted after editing
Create and post a new announcement. Click edit to edit the announcement. Edit the description. Click Save. Announcement is deleted. v7509
Service Desk Crashed
Unable open Advenet Service Desk Plus unable to take backup C:\AdventNet\ME\ServiceDesk\bin>backUpData.bat Starting.... Active DB Server = mysql Database connectionProp : useUnicode=true characterEncoding=UTF-8 Database not started. Starting ......... Aug 1, 2009 5:51:53 PM com.adventnet.db.adapter.mysql.MySqlDBInitializer execute Command INFO: Command to be executed ..\mysql\bin\mysqladmin -u root --port=33366 -h loc alhost version Aug 1, 2009 5:51:56 PM com.adventnet.db.adapter.mysql.MySqlDBInitializer
Help with Aged Call
Hi, I have been asked to produce a report that listed all of the open\pending request and list the age in the number of days they have been open. I found where someone had attempted to this before, but I can not getting it working. Keeps returning blank screens. Our database is a sql server. Anyone able to help?SELECT wo.WORKORDERID "Request ID",wo.DESCRIPTION "Description",td.TASKID "TaskId",td.TITLE "Task Title",aau.FIRST_NAME "Requester",au1.FIRST_NAME "Task Owner",no.NOTESTEXT "Notes" FROM WorkOrder_Threaded
Custom Report Help
I am wondering if there is someway to make a report detailing how many copies of a piece of software are installed on a pc with a count for each day/month/year. The report would list all of our software and for example on July 1st we had 50 copies of office 2007 standard installed and july 2nd we had 55 copies installed ect...Can anyone help me make a customer report? Thanks, Dave
Strange Error in SD Plus - 7508 - Request added Successfully with RequestId:#####.But this request does not fall under your permitted scope. So you are not authorized to view this request.
Some Technicians have started to received the below alert when creating or deleting Requests and Changes. The alert appears to be false as they can indeed view, edit and delete the request or change stated in the error message. I am guessing that this is related to the site function, but all the config appears to be fine. Request added Successfully with RequestId:#####.But this request does not fall under your permitted scope. So you are not authorized to view this request. Has anyone else seen
Clock Stop Time
Hi, Does anyone know if it is possible to create a report that shows how long the timerhas been stopped on a Request for? We stop the timer by using the Status field but it would be useful to see this period of time in a report. Thanks, Paul
Report That List Requesters + Assets Associates
Can there be a report that will list all the requesters and assets associates with it? Mainly just workstations, alot of our users have two computers (notebook, desktop) and this would help us organize them. Thanks, Dave
$Description variable doesn't work in CAB notification
When a can notification is sent, we use the $Description variable to include the description of the change: However, when the email is received, no detail is included for the description, so it looks like this variable doesn't work. Can someone try to reproduce this and see if this variable is working or not?
Report combination on resolve time
Hello, I am looking for a report but i can not find him and i do not have the knowledge to create my own query. We want te see the time a request is resolved. Because the users are not very consequent to close a request. I would like a report per Priority like this: Request ID Requester Catagory Subject Status Creation Time Resolved Time Closed Time Then the sum of the requests on priority the max, min and average time between request time and resolve time. Im sorry for my english. I hope some one
why can ui run this in query analyser and not in the query window in reports???
SELECT resource.RESOURCENAME "Resource Name",resource.ASSETTAG "Asset Tag",product.COMPONENTNAME "Product",resource.SERIALNO "Serial Number",resFields.UDF_CHAR4 "Make",aaaUser.FIRST_NAME "User",deptDef.DEPTNAME "Department",resFields.UDF_CHAR5 "Model",regionDef.REGIONNAME "Region", reslocation.siteid "siteid" FROM Resources resource LEFT JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID LEFT JOIN ResourceAssociation
How do I do a call history report
I'm trying to build a report that shows who's allocated or picked up a calls within Service Desk. Any ideas as the fields within the built in reporting don't seem to hold this information?
how to a) create a copy of a standard report? b) cross the two modules Resources and Software in SQL?
Hello I would like to create a report based on the standard report 'Software Summary Report' of the 'Workstation Summary Reports' section. I.e., I want to create a list showing on which workstation is installed "Acrobat Reader" for instance ==> Filter on 'Software name' Is it possible to create a copy of the standard report 'Software Summary Report' and edit the copy? How? If not, how can I cross the two modules Resources and Software. This is not possible via the 'new custom report' function. Can
Next Page