[SDF-28875] SQL results with clickable ticket ID
Hi On some of the reports the results include a clickable/hyperlink to the URL that opens the ticket when you click on it. How can I get that in an SQL query format? So that when I query the servicedesk DB one of the columns has a link to go directly
Report Needed - Request and Task
Hi Is there a way to get a report that shows both the completed requests and completed tasks on the same report?
Error when requester wants to close request by closing link in email
Hi Friends. When request status is "Resolved, waiting for test by Requester" an email will be sent to requester that contains Request closing link. BUT when requester wants to close the request by that link ,this Error message will be shown: Close Operation
Elasticsearch monitor requirements
Hello, My customer wants to create a dedicated user to monitor their Elasticsearch cluster and they want to give this account the minimum access rights possible (i.e. not an "admin user"). I've seen this article on the FAQ but nothing is specified for
How to create custom naming formats creating or modifying users with ADManager Plus?
A major hiccup that organizations face when they switch from manual user provisioning to template based or automated user provisioning is configuring the logon names in the format that's being used in the organization. This is important not only to ensure
[Term of the Day]: SOAR - Security Orchestration, Automation and Response
Term of the Day “Security Orchestration, Automation and Response” Definition — What is SOAR? SOAR stands for “Security Orchestration, Automation and Response” it’s the set of technologies that allow businesses to collect security threats (alerts) and
Browser Tab Icon
Hi Can you guys please add the ability to add my custom icon to the BROWSER TITLE. Under Admin, Theme. I see I can now add the custom Title to the browser tab - but I also need to add my icon. Irs great that we can now change the title in the browser
Mass Update JIRA Link
We are in the process of merging two JIRA accounts that our company uses. We would like to be able to mass-update the service desk tickets with JIRA links to the account that is being merged. Is there a way to do this ?
Adding a Gateway Server
Just a question in regards to the gateway server. We are looking into add one, will we have to re-push all of the clients in the field back out or will they auto update themselves? Also, if we need to change the FQDN, how will this affect the communication
Can't open existing configurations to the details screen
Ok, we have been running Desktop Central for several years, so I don't think I am a noob. This method has worked in the past, up until a month or 2 ago. So when a new patch comes out, I'll pick on FireFox. I'll download the FireFox patch. I'll create
Two Year old patch suddenly appearing
Microsoft ASP.NET MVC Security Update MS14-059 (KB2993939) Suddenly appearing for 2/3rds of our computers, Windows update does not seem to think this is a required patch. Please look into this.
Change: Close tab
Hello, Is it possible to lockdown the close tab at the end of the Change workflow? We don't want the people that generally submit the changes to be able to edit this.
Enable Two-Factor Authentication?
We currently utilize SD+ MSP, but we are wanting to lock logging in down further with Two-Factor Authentication. Is this possible?
[Term of the Day]: RACI chart
Term of the Day "Responsible Accountable Consulted Informed" Definition — What is RACI chart? A RACI model or matrix, also known as a Responsibility Assignment Matrix (RAM) is a way of defining roles and responsibilities for a specific task or activity.
Auto number a field
Hi, I would like to know if it is possible to set a field to auto numbering (e.g. access tag) with a specific type of rule. For example, 04(Fixed)0001(1st good received in November)20(Year)11(Month). Thank you very much
What is the SQL syntax for this? This week.
HI I am trying to compare data using a servicedesk report and directly from SQL. What is the tsql syntax for this: and wo.CREATEDTIME >= <from_thisweek> AND wo.CREATEDTIME <= <to_thisweek>
REST API v1 compared to v3 (for 'Add Change')
We have recently upgraded to 11.1.0 Build 11130. Prior to this update the v1 Change API were working a treat; whilst we were told they would still be supported the API have stoppped working (a seperate support ticket has been logged for this). I've looked
How can a resource be added/updated/deleted without having to go to the service template?
I am trying out the "add resource" feature in a service template and I was wondering if there is a way I can manage the resource(s) without having to go to the actual template. It would be easier to manage all resources in one location than having to
Patch deployment/replication speed crippling networks
I am trying to understand Desktop Centrals patching/replication speed settings. We have some smaller sites we manage that have 5, 10 or 15MB bandwidth pipes going into them. Our replication policies are set to over night at either 64KBps or 1MB. Problem we're having is even at 64KBps, pushing software or patches to a site is killing the network. This caused a major issue this past Friday and knocked out an entire site. If it's pushing at 64KBps and a site has a 10MB broadband connection, why does
Desktop Central Endpoint Security Add on - random login on my network
I enabled the Endpoint Security Add on a few days ago. Today, out of nowhere, I got a login failure to a raid controller on my network from the Desktop Central server's IP. 1 single login failure (I think it was a failure!). My question, is there
Change asset icon
Hi In Asset Explorer, is there any way to change the shown icon, next to the name of every device ? It seems like it's being added when scanned, but we do have some devices, that are added manually, or the icon is incorrect, and therefore would like to
Restore takes long time.......
restore takes more than 60 minutes, last output of restore.bat: Nov 23, 2020 12:32:14 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer isServerStopped INFORMATION: isServerStopped method returning status ::: true Exception in thread "Thread-5"
[SOLVED] Escape Sequences do not work as intended
Hey there I am trying to add a note to a request via the API: '{base_url}/api/v3/requests/32435/notes'. Headers and Content-Type all set up correctly. When trying to send this input data: { "request_note": { "description": "My Note\nFor you" } } it get
[Term of the Day]: Zero-Day Attack
Term of the Day “Zero-Day Attack” Definition — What is a Zero-Day Attack? A Zero-Day Attack, also known as a zero-day exploit or zero-hour attack. It occurs when hackers exploit a vulnerability in hardware or software or firmware that is unknown
Upgrade assistance and final call to upgrade your ServiceDesk Plus to the latest version
Dear users, Thank you for being a valued customer of ServiceDesk Plus. This post is a kind reminder that our support is not offered to customers with builds more than a year old, according to our support policy. We are pleased to provide upgrade assistance
Service Desk Standard - Server wont start
Fresh install on windows 10. I ran the installer and when I try to start the server it hangs at the very end on Server Started. when I try to pen the web client it reports the server is not running
screening requests to certain people/job titles
Is it possible to hide certain service request types from most users and only show them to certain users? Use case: My client wants User Management (add user, change user, terminate user) service catalog requests to only be visible to Managers.
SQL query to list users / values in manually created user group
Cheers! I am trying to find an easy way to list all values of a manually created user group in servicedesk plus. We created a user group that contains email IDs of various users and used it to limit access to certain request templates. Now I need to
[Term of the Day]: Data Protection Officer (DPO)
Term of the Day "Data Protection Officer" Definition — What is a DPO? A DPO is considered to be an enterprise security role to help an organization to ensure compliance with personal data protection laws such as CCPA, GDPR and PDPA. His primary role
Reports missing since license downgrade
Hello, Since recently downgrading our SDP (10.5 Build 10514) license from Enterprise to Standard, a bunch of reports are now missing from the Reports page. Reapplying the old license makes the reports return again but as soon as the new license is applied
Problem with decimals to convert timespent to hours
Hi! In a custom SQL query, applied the formula to_char(round(((TIMESPENT/1000)/3600),'99.99'), the report display number .00 instead of 0.5 (30 minutes). The field is 1800000, then (1800000/1000)3600 = 0.5 in my calculator :) I tried (TIMESPENT/1000)/3600
Service desk plus not showing reports
Good Day I am failing to generate an asset audit report, I have tried renaming the report folder to report_old but the issue still persists. Message Dear user, Unable to generate the report you have scheduled, So please contact your Administrator [OR]
Query
Hi, Please provide Query for below columns: ID Created Date Request Status Response Time Time Spent By per Technician Time Spent by per Group Total of Time Spent Technician Group Close Date Requester
Number and name of computers on which software X is installed
Hello I would like to have a report that shows me on which PCs the different versions of software are installed. Similar to: SQL2014 PC1 PC2 SQL2016 PC3
Need script
hello i need a script for merging two requests with a common field along with open status
Is there an Oncall software that can be integrated with ServiceDesk Plus
We would like to enable pager duty or oncall duty for technicians while they are oncall and also alert managers of any critical system down. Is there a way that we could integrate ServiceDesk Plus with an Oncall system. Thanks John
Report about preventive maintenance tasks
Hi team, is it possible to extract a report about preventive maintenance tasks? Thanks in advance
APM Service account lockout
Dears, I am using a service account (SVC-631) for WMI discoveries. The problem is that after a few minutes, this account will be locked and all windows servers that are discovered with this account will have an error (Authentication failed. Kindly verify
Select users that will recieve emails of "Password Expiration Notification"...
Hello, Here at my campany we are happy users of ManageEngine OpManager. I was browsing other products and I found ADSelfService that will help me with notificating users of expirating passwords. Installed and notice that it have much more functionalities that i dont need, i only really need email notification of password expirations. So , the free versions is more that enouph for us, as we have less than 50 users that logon on Domain that have the policy for password expiration active. My Questions
Request a PMP agent key via API
As the PMP agent requires an agent key every time it's installed/updated it would be nice to be able to obtain a key (one time or limited time) via the API. This allows for automation.
Next Page