postgres data export help needed
I need to bulk export requests with all the data which must include all the conversation history. I have looked through custom reports and analytics plus but i cant find the table/ field where i can grab this from. Our ME database is postgres. Thanks
Service Desk Plus MSSQL query Last Update Time
I'm wanting to see if I can get some help with a SQL query that can add a column showing the number of days since the request was updated. I found the following query below from the forums that filters the database by records. but cant seem to figure out how to make a calculated field that shows the number of days since update. Any help you can give would be greatly appreciated. Thanks Tony Blandin SELECT ti.FIRST_NAME "Technician", wo.WORKORDERID "Request ID", aau.FIRST_NAME "Requester", cd.CATEGORYNAME
[SDF-24799] Templates for Announcements
Hello, I was wondering if Announcement Templates are on the road map for future releases? Our organization likes to have multiple templates for outages and notifications for the general business. Thanks!
Site Usage
Our organization is a City with many physical locations throughout our municipality. Before we ever started using ServiceDesk we had already called each one of these locations Sites. This caused some confusion early on as we started setting ServiceDesk up and unfortunately was never fixed. By ServiceDesk’s definition we should only have one Site, our City name. But as things are each actual location we have is listed under Sites. After time we made a change to what data is found in the Office field
Exporting closed tickets to a separate database.
Good morning all, I wonder if you can assist? Our database is currently running high and we wish to keep it below the 10 gig threshold SQLExpress has. I have tried the following all with minimal to no success: shrinking the database data delete from aaaaccsession delete from auditrecord delete from recentitems delete from errorlog archiving all closed tickets older than 2 years. Can you please advise on what else can be done to reduce the size of the database? Is there a way to move all closed tickets
Python script for updating tasks
HI I have followed the instructions for installing this python script from this forum https://resources.manageengine.com/resources/resource/python-populate-request-details-in-task-title-and-task-description However, when it executes at point of creation I get the message "No tasks to update" I have 3 tasks within the template & a variety of fields in different formats, surrounded by different delimiters (in case I had missed something) but still get the same error. What am I overlooking here? (I
Waiting for Approval - status is changed to On Hold... How do I turn that off?
I am having the hardest time finding this. I could've sworn I could turn this setting off... I'm trying to turn off the setting that when you send something out for approval, the status automatically goes to On Hold... I can't seem to find how to do that, or if you can even turn it off... Thanks!
Business Rule - Run once / Run limit
Hi, We have a business rule to notify service management when the priority of a ticket is created as P1/P2 or edited to be a P1/P2. The problem is that whenever anything is edited in the ticket from then on the business rule runs every time. We only really need to be notified once. I think there are probably more use cases to imposing a run once or run limit to business rules. In the meantime is there a different way of achieving the behavior I've described above? Thanks in advance, Dave
[SOLVED] API v3 Field and Form Rules Script to get User Additional Field
We are working towards migrating our production environment up to build 11104 from 10513, and in doing so we will need to replace many of our scripts. One such script is a Field and Form rule to get a requester's room number and enter it into a field on the incident template. The room number is defined as a User Additional Field. Any assistance with this would be appreciated.
Spam filter not working for description field
Hi, In 10514 the spam filter for the description field criteria seems to be broken. I saw this fix in your portal: https://pitstop.manageengine.com/portal/kb/articles/spam-filter-not-working-for-description-criteria It says that it's compatible with 11001, but can it be modified to work with 10514 also? Thanks
Dashboard Widgets broken?
I've got a couple of the canned dashboard widgets that have stopped displaying information. Here is a screen shot: Any ideas?
ServiceDesk email in Distribution Group
We have a Distribution Group that we want the ServiceDesk email account to also receive emails from. I have added the email account to the Distribution Group but SDP fails to create tickets from emails that are sent to the distribution group. Is it possible to have SDP create tickets from emails sent to it by distribution groups?
Move Field Information on Database
We've had ServiceDesk for a few years. And we've built many Incident templates in it and in Service Catalog. In that time frame we've created a lot of additional fields in both modules that are similar or redundant. I'd like to perform a bit of clean up on fields that can be consolidated. But I do NOT want to lose information on forms that have been submitted and closed. For example I have four different date fields being used on four different forms. They are as follows. New Employee - Effective
Allow Non-login users to view solutions
this setting "Allow Non-login users to view solutions" dosenot works on servicedesk 1110.5
Create a custom report with Request Status
Hi all I would like to seek for help to create a report by Request Status The report will be look like the attached one from my existing Excel file. Requirement: 1. Group by Category 2. Count of uncompleted ticket for last week 3. Count of created ticket for this week 4. Count of completed ticket for this week (it should include those outstanding ticket from last week that may closed in this week) 5. Count of uncompleted task as of this week (or as of print date) 6. Percentage each category among
Catalan language
Hello, Any plans to add the Catalan language in ServiceDesk Plus? Thank you.
Giá của máy tính để bàn hiện nay là bao nhiêu?
Hiện nay, việc trang bị cho mình một chiếc máy tính để học là vô cùng cần thiết. Trong đó không thể không kể sản phẩm để phục vụ cho việc học công nghệ thông tin như máy tính để bàn trọn bộ. Vậy làm thế nào để có thể tìm được địa chỉ bán uy tín máy bàn
Report Error on Run
We're running into an issue with specific reports when using the Scheduled Start Time variable. We reported it already (Ticket #: 5919930) but have not received a response yet. If I removed the Scheduled Start time from the report, it runs. If I add the variable and try again I get a "Sorry an error has occurred" message.
Change permissions after upgrade
We recently upgraded to 10.0 Build 10013 IT Technicians used to be able to edit changes during the planning stage (and probably other stages) of changes. Now, once the change leaves the submission stage, the edit button disappears. Is there a way to make the edit button show up for technicians again? Here's the role configuration: Here's a screenshot as a technician: Here's a change I worked as the admin account. Thanks! Joanna
[RHEL 8] Upgrade to 10500 fails, and service autostart fails
Service auto-start fail: Followed the instructions here. When I reboot my server this is what I see upon running "Service status servicedesk" and the site is not accessible however the service shows as "active" status. Feb 23 05:28:39 ip-Addr-internal systemd[1]: Starting SYSV: Run the ServiceDesk-Plus program... Feb 23 05:28:39 ip-Addr-internal servicedesk[980]: Starting AdventNet ManageEngine ServiceDesk-Plus Feb 23 05:28:39 ip-Addr-internal systemd[1]: Started SYSV: Run the ServiceDesk-Plus program.
PGSQL database
Can someone help with a query report for a PGSQL database for the guidlines below? Response time - the time between ticket creation date and the first technician response Resolution time - the time between ticket creation and closure dates Average number of tickets created per day Average number of tickets closed per day
Unable to Edit Service Catalog Templates
We are on 11.1 Build 11100, MSSQL. Today I ran into an issue where templates in ServiceCatalog could not be edited. Specific issues below. - If I opened up a field I would not be able to edit any other field of the same type (example: single line) until I closed the template and reopened it. - Selecting the options "Requester can Set" & "Requester can View" only worked some of the time. Most times that change would not even save so the field would not show up under Requester view. - If trying to
Can I upgrade SD plus from B# 10512 direct to B# 11000?
Can I upgrade SD plus from B# 10512 direct to B# 11000? " Migrate from Build 10513, 10514 to 11000 Migrate from Build 11000, 11001, ... 11010 to 11100 Migrate from Build 11100, ... 11104 to 11105 "
Connecting two ServiceDesk Plus applications to one MS SQL database
Hi, is it feasible for me to connect two ServiceDesk applications running on different servers to one database. One ServiceDesk application does not receive any incoming requests but the other one does receive. The applications have different builds or versions running
[SDF-85272] Associate Multiple Incidents to a Problem from Request View
I just updated our SDP instance to Enterprise and I would like to start using the Problems feature. I noticed there is no way to associate multiple incidents in the request view and assign a problem. It would make sense to be able to do this so technicians can select multiple incidents that came in for the same thing. Going to the Problem module and then associating via search doesn't make the most sense. Neither does editing each incident individually.
[SDF-66047] Custom view in Requester login
Hi Team, How to create a custom view in requester login. Regards, Karthikeyan R
[SDF-64464] First Response - Set to complete on notification
Hi there, We have the below notification enabled, When this notification is triggered is there a way completing the first response SLA? For our organisation this means that a technician has taken ownership of the ticket and will be working towards a resolution. Thanks, Dave
SDP Mobile App - Questions
Hi, I'm testing the IOS mobile app for SDP before implementing it in my organization and have some questions. - When creating a new request, I can't find out how to select Group. There's only a choice for Site. Is there a setting to enable this (without first having to create the request and then go back and edit it afterwards)? - The request can be created without entering information in mandatory fields and field and form rules does not work. Is this correct? - If the above is true, the mobile
[SDF-85209] Additional keyboard shortcuts
A keyboard shortcut for 'link requests' would be really useful - this is a feature I use a lot :) Another thing I'd really like to see a shortcut for is for 'add new work log' . It would also be really handy if there was some sort of 'quick close' -- either a button or a shortcut -- as often people reply saying 'thanks' and a quick way to close those tickets could make things a bit faster.
[SDF - 38213]Request List Filter
Good afternoon. How to limit the list of filters for a specific specialist? Create your own filter, and remove the rest !?
[SDF - 85270] Resolution Attachments
HI, would it be possible to set the attachments in the Resolution as mandatory?
Error at update
Hello, I'm trying update my servicedesk to the last version for migrate it to a new server. I could apply the patch to update from 9117 to 9121 without problems. For appply this first patch i followed the next steps: 1 stop the app 2 run the backup script 3 run the update script 4 start the app When i try apply the patch to 9200 follow the same steps than before, but in the step 3, at 3 or 4 seconds of start, it stop with simple error message (without any description of the possible fail) and the
report for Roles and permission assigned in sdp?
SQL query for a report showing the list of Roles and permission assigned each in sdp?
Software Asset: Floating license
Hi What of the following type of license can i use to create a floating licence asset? thanks Stefano
Ticket creation for new users
Good Day We sometimes are facing the problem that someone, which is not already added as a requester, wants to create a ticket over the phone. In these cases the admin creates a user manually and afterwards the ticket can be created. The problem is, that regular technicians are unable to do this and therefore can not create the ticket right away. The best solution for us would be if technicians could also type in an e-mail-address during a ticket creation in the name field and the user gets added
[SOLVED] Forward Template
Good Day If I forward a Message from one of our customers, the message template "Forwarding a Request" is used. If I want to forward a Message, which I have written myself, no specific template is used. Fwd is added at the beginning of the subject but nothing else. How can I configure this specific template? Should it not be the "Forwarding a Request" template? Thank you very much for your help.
REST API: API authentication using loginName/pass to get Technician Key to ServiceDesk Plus
Hi, I'm trying to integrate with the API using the credentials to get the tecnician key to make requests. Does someone have a sample request? I searched the API docs but couldn't find anything. Thanks!
Requests caused due to this Change - Data Retrieval
Hi, 1. In CRs there is an option to link incidents which was caused by implementing the CR. Screenshot attached. 2. Can you pl let know how do we obtain report of such CRs. This would give a direct report of bad CRs whihc has been executed over a period of time/ for specific function. Regards Karthikeyan
Need help with a report
Hi There, I am trying to report on a couple of things. firstly I need a report that shows the number of calls raised within a given period by mode to the service desk. secondly I need a report that shows the number of calls that have been sent to each group from the service desk within a given period. I am as technical as a teddy bear when it comes to writing queries so any help would be appreciated.
Closing requests
Are we able to modify the fields shown when closing a request? The Desktop team leader has asked me if we can modify the ‘Has requester acknowledge the resolution’ to a drop down menu to have the option to select; - Verbal follow up - Email follow up - No follow up required – notification of request closure is sufficient
Next Page