Query - SQL error? (postgressql)
Hi I'm working on a query, but have hit a wall when only halfway there. Can anyone tell me please why this works: SELECT aau.FIRST_NAME AS "Requester", COUNT(*) as "Total" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID WHERE (wo.ISPARENT='1') GROUP BY "Requester" But this: SELECT aau.FIRST_NAME AS "Requester", COUNT(*) as "Total" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
Talk ITSM : Free training on ServiceDesk Plus | August
A completely free, 2-part webinar series that will help you get hands-on with the different modules of ServiceDesk Plus. Attend the complete series to optimise your IT help desk operations. Register just once to enroll in the 2 parts, scheduled for the 9th, and 16th of August in three different time zones. We'll send you separate links to join the sessions before the scheduled date. Part 1: Start your service management journey About: Broad overview of the product and basic helpdesk configurations.
One more report request, time to resolve
MS SQL, build 2016 Stats for Incident Requests + Service Requests Time to resolve by technician, by year/month Resolved under 10 minutes Resolved under 30 minutes Resolved under 60 minutes Resolved over 60 minutes Total resolved Month Technician 10min 30min 60min 60+ Total Resolved This one is tricky. I had it with our last system which is my management wants it now. Help is appreciated. Thanks
Business rule not executing
Hello, We have 5 business rules, every rule is working except this one. This is the first rule that is executed. This is the rule: When i'm check the System Log this is the "info" message DataObject for Notification: <WritableDataObject> <Tables> [AaaUser, NotificationContent] </Tables> SelectQuery Object: Select columnNames=[NotificationContent.NOTIFICATIONCONTENTID, NotificationContent.NOTIFICATIONTYPE, NotificationContent.SUBJECT, NotificationContent.CONTENT, NotificationContent.ISENABLED,
Update to 9223 succeeds but leaves SDP unusable
Hello, Just wondering if there is a known issue around updating from Build 9218 to Build 9223, where-by the update works, but the interface becomes unstable. Has anything been reported as yet? If not, I will log a call. We have tried the update three times with the same outcome everytime. Cheers, Ben
setting order for display of Incident templates.
Hi - ability to sort Incident templates, would be good to move them around somehow. I can't work out how to do it, so if there is a way at present, let me know
Report for Tech Availability
Hello, Is there a report that could be generated to show the Technician Availability for the current year? We are running Version 9.2 Build 9217 with MySQL Thanks, Ralph C.
Report stats for a specific group
Would it be possible to get a report with the following: Month request resolved Technician is part of a group called "Service Desk" Want a count of FCR calls, non FCR calls, total calls resolved per technician Calls resolved from start of year to current date or from "start date" to "end date" if it's easier Sorted by Month then Technician So something like Month Tech FCR Non-FCR Total Calls Possible for a MS SQL with build 9216? Also possible to be prompted for date parameter? Thanks
Field/Form Rule Help
I have a need to take a custom date field and force that to be the duebydate I thought this might work as a "form load" option but its not working -- any assistance would be appreciated var x=$CS.getValue("WorkOrder_Fields_UDF_DATE6"); $CS.setValue("DUEBYDATE",new Date(x));
Asset CI's
When I'm in the CMDB and moving assets around the CI categories, I came across an inconsistency. Under the CI called Workstation, I created 2 sub categories called Laptop and Desktop. When I'm attempting to move the laptops into their own CI, my CI names are not listed. Did I create the categories wrong? Please see the attachment.
How to get unaudited workstation api
I want get unaudited workstation by rest api. help me. Thanks for all.
Unknown User
Hi, We have some users in with unknown user problem and these users are imported from the AD, I tried to clearing browser cache and cookies and rename the Extracted Folder under SDP-home/application option. But no luck, i have been facing this issue since after the windows updates it seems. Please kindly provide an answer as users are frustrated with this issue. Shamseer
Assets scan site import issue
There seems to be an issue with site not being set after assets scan, both using the script and the agent. The Site value is properly set in the script and manually added to the agent's registry. The xml file being generated does contain the proper site information, so it is probably an xml import based issue. I am aataching server logs, script and inercepted xml file. Hope I can finally get some help with it as I've been battling with this issue since march. Am I the only one? Thank you in advance,
Delete all requests for specific group(s)
Is it possible to delete all requests for a specific support group? Deleting 250 request per go when a group has some 10000 requests assigned to it is very laborious. Thanks.
Script to "Add New Request"
Hello everyone, I am brand new to scripting in general and am struggling quite a bit with creating a new request based on another request being submitted within Service Desk Plus. I have a New Hire Request template setup and have a few check boxes for hardware items. I've setup a Field and Form Rule for when the "Laptop" checkbox is checked to execute a script. I would like this script to create a new request based on another template. I am at an utter loss on how to create the script to fulfill
I am New to Service desk plus want to restore my old backup file
Want to restore technicians requesters and my settings back . Please help how to restore . My Version : 9.2 Build 9223 My Old Version is 9018 Is this Posible
Preventive Maintenance Tasks
Hi, I was wondering if anyone has come across a problem in Preventive Maintenance Tasks where the "Priority" field is blank and when the Task is created it doesn't pick up the Priority you want (and therefore the SLA) ? We've created an incident template we want to use for our Preventive Maintenance Tasks, Added a Priority for this and it appears fine there, but when viewed and created the Priority is incorrect when the Preventive Maintenance Task is created. Do only Task Templates work correctly
Role Permission - Linking Requests for MIs
Hi, We're working on our process for major incidents, and was hoping to use the request module more effectively to link parent and child tickets with 1 being denoted as the major incident and the other related incidents put as child requests underneath this. We have found that this causes issues because depending on where you link the requests from, you can make parent reference requests into children. We still want to progress with this approach, but wanted to limit access for users to be able
search broken - solutions and requests
We're having issues with search solutions - results are empty requests - results are partial. only a few show up. This was working fine before 9209, i applied 9213 hotfix last night and the problem still exists. Any ideas? Thanks
Change Template - On Field Change rule not working
Running Ver: 9221 Under Changes Module, 'Field and Form Rules', 'On Field Change' I set the settings as shown in the attachment and when creating a new change and it doesn't work. (Needed condition is item = xxx) I have tried many other settings in the custom script, with the defaults suggested by the program so that is not the issue. Script = $CS.setValue("TITLE","Software Update: Adobe Flash"); Let me know if there is a way to fix.
When does the Active Directory Automatic Import occur?
I have scheduled an automatic import of the Active Directory information, to occur each day, but I don't what time of the day the import is initiated. We automatically sync our Active Directory from the HR system at 5:30am and I would like to schedule the import after that, say at 6:00am. Best regards Dave
Change Management - Custom Triggers
Hi All, I am currently attempting to implement a custom trigger on Change Management to invoke a powershell script to send data externally when a change is created, and when it's workflow progresses. I have managed to get the RFC approvals down fine, however the "Edit" action does not seem to trigger as the workflow progresses. Is this by design, a bug, or am I missing something? My trigger is as follows: Change Custom trigger: - Execute when change is created and edited - Criteria is any Change
After Upgrade to 9218: SDP Notification: ERROR : Mail fetching process stopped
Hello Together, After Upgrading from 9215 to 9218, the mail fetching isn't work. Following error message: Product Name : ManageEngine ServiceDesk Plus Build No. : 9218 System Error Notification An error occured while processing email with subjectOfMail : test messageid : . Mail Fetching process of ServiceDesk Plus was stopped. Please delete the mail from mail server and restart mail fetching process. Can anyone help me? BR, Rico
hidden community module
Hi, we need to hidden community module from our technician , is there any way to remove we using 9.2 Build 9218 . thank you
Unable to add new incidents
We're using version 9223. We had this problem with 9220, but thought upgrading to 9223 would hopefully fix the issue. We are no longer able to create new incidents or service catalog requests. Whenever we create a new incident, we get automatically redirected to the Requests page that lists all open requests, and the incident is not created. At the top of the page, there is a blank message window with a red X--I've included a screenshot. We've opened a ticket with support (#7455702) and nobody has
How to update head for Department use API
Please help. How to update head for Department use API ? Thanks
Status change comment & Scheduler
Is there any way to make this mandatory just when changing the status to on Hold? I know in the Self Service Portal settings you can change the setting for 'Status change comment mandatory for request' but this enables the change for all status changes.
Asset Scan Audit Behavior?
With SDP, is there no option available to Automatically remove an asset that is not scanned in X number of days? I have things appearing in the asset list that was retired long ago and are still using up an asset license. Why are these not removed after not being detected on the network or at least being move to in storage to free a license? This should be a feature in the asset scanning instead of having to spend more $ on the Asset Explorer software. Thanks Jason
SQL Query To Find Resolved Tickets Without Worklog Details
Hi all I'm trying to create query finds all missed worlog details. I need to ensure worklog details is exist before close "resolved" tickets. Thanks a lot
Unable to update Employee ID using Active Directory Import
I am using the Import from Active Directory to populate/update our requestors. Everything works fine except for Employee ID. I tried creating a UDF named Employee ID and populating it from the AD property "employeeID". This field does populate correctly but there is another Employee ID field in the Requestor record that is not updated. I can't seem to find a way to remove the other field. Please help. Dave
How to copy all data from SDP 9.1 to 9.2
Dear Support, I am using free version of 9.1 SDP and now i have installed new SDP 9.2 in other computer, I want to transfer all data including, users, technicians, sdp configuration and assets to newer version kindly explain the procedure.
Content Variables
Hello Is there a way to edit the content variables? Specifically the $RequestLink variable. regards Kate
New problem after update from 9208 to 9213 with Issue Catalog
Hello We only have the default request template in the incident templates. In build 9208 (and also before) there wasn't a dropdown box for the issue catalog if there was only one incident template. In the left of the service catalog dropdown box there was only a button "New Issue" and not a dropdown button. If I click on this dropdown button it appears an empty template page. That is not very useful for our customers. Could you please change it as it was before. Regards Markus
Change Management: Is it possible to block out dates on the Calendar?
We actively use the Change Management feature. We would like to know if it is currently possible to block dates on the calendar so that when technicians are submitting change request tickets that they are prevented from selecting dates that have been blocked. If this is not possible, can we make this a feature request? Thanks, Adam
Creating a dynamic picklist using an already existing picklist of values
I have an issue where im trying to populate a picklist with options, depending upon the value of another separate picklist that already exists. I saw the dependency example in the JS how-to, but im not sure that scenario is the best solution for what I am wanting to do. However if that is not the case, i am more than willing to learn or make it work. First things first, my MFH-Location dropdown has about 50 options for location, so based on that result, i need to populate the UDF_CHAR4 field with
Passing parameters to Scripts
Hi everyone. This little monkey has me confused. I'll lay out the scenario so you get the jist of what we are trying to do. You'll have to bear with me as I am still trying to work on the lingo :) I have a piece of software that will deploy software via the commandline. I am trying to make a customer trigger (or something to that effect) that will start this deploy process when a user opens a request. For example, a user opens a request for a java update to be installed. I'm having troubles
Service Catalog Form Rules
Is it possible to use a rule on Form Submit from a Service Request to open another Service Request? Example: If I add a check box to my form in the Service Request then have a rule that when it is submitted and the check box is checked I can have different Service Request open to be filled out. Chris Trauner Network Analyst
ServiceDesk Plus 9223 Released
Dear Users, SDP 9223 has been released and can be downloaded from the URL below, https://www.manageengine.com/products/service-desk/service-packs.html Issue Fixed in 9223 : SD-63861 : Custom Header Image gets corrupted while migrating to 9222. Please refer to the below link for the steps to install the patch. https://www.manageengine.com/products/service-desk/service-packs.html#sp Regards, Edwin Vasantha Kumar Servicedesk Plus Team
Location as an Asset Consideration
I have a campus environment (multiple buildings located in one site). I am considering adding each building and room number to the CMDB to allow for assets to be related to a location. It would be great to be able to have a series of dynamic drop downs that reference these locations so that location can be managed from a single location and not a custom drop down list that needs heavy management. Has anyone been able to achieve this? If so, how?
Mail Fetching status monitoring
Hi Support, Is there any way to monitor 'Mail Fetching status' for incoming and outgoing mail ? Via API/powershell/etc ? Sometimes it stopped working and you find out that after a week. Also how to start/stop mail fetching via API/powershell ? Thanks
Next Page