Total count on a query
Hi all, i have the following query but would like to place a count of the total number of tickets resolved. What would be the best way to achieve this please. Thanks in advance select MAX(aaa.first_name) "Resolved By", COUNT(Distinct workorderid) "Count of requests" from workorderhistory woh left join aaauser aaa on woh.Operationownerid=aaa.user_id where (operation='Resolved' or operation='CLOSE' ) and ( aaa.first_name like '%tech1%' or aaa.first_name like '%tech2%' or aaa.first_name like '%tech3%'
Projects - Query Report request
Hi, We are about to start using our Projects module fairly extensively, due to the lack of being able to associate a purchase order with a Project we wish to be able to report on associated Service Requests that have associated Purchase Orders to essentially have a total cost of each Project (I do realise there is an 'Actual Cost' field available however this is a static field). Fields required would be from Project Module - Project ID, Title, Status. From Purchase module - Total Price where PO
SPM/IPAM Setup
I am trying to set up the SPM/IPAM since I have the licensing coming in sometime today. The issue I have is this. There is no way to add items to groups that are not listed. Then what is the proper way to configure SPM/IPAM to start getting the detailed information and start producing reports. Daren
Is anyone experiencing issue with updating the offline patch DB process
We've implemented Desktop Central 10 on server 2008 Std R2 in a standalone network. We are experiencing the same issue. Little to no problems with previous application version in same scenario. "I have Desktop Central 10 installed in a closed network with no access to the Internet and have followed the steps here: https://www.manageengine.com/products/desktop-central/help/configuring_desktop_central/patch_management_for_closed_network.html. When I try to update the Patch Database in Desktop Central
Netflow Analyser Android app - doesn't connect to server
Hi, I have Netflow Analyser running on a server with a fixed IP. When I open the http page via my mobile phone, it works fine. If I try to connect via the Android Netflow Analyser App, I tried to connect but then nothing happens. If I enter a wrong IP or Port, I get an error message from the app. If I enter the right IP and Port, there's no message at all. So, the issue seems to be at the authentification level. Even tough the username and password is correct. What could it be? The app is communicating
Netflow Analyzer Traffic Auto-Refresh
How do I configure Traffic to auto refresh. I know in older version, 9.0, I was able to do this but cannot figure out how to setup in newest version, 12.0. Thanks,
creating support group
Hi guys, I've created a group within our helpdesk using support group to carve off helpdesk cases for a different group. question is right now we have a notification rule that gets automatically sent to the user from the main helpdesk. Is there a wayto send out a different one based on the email address it comes from? for eg. helpdesk@servicedesk.com gets a specific automticaly response helpdesk-different@servicedeks.com gets a different email
Best Way to inventory ESXi Standalone Systems.
What is the recommended way to inventory an ESXi Server (5.x & 6.x) that is standalone (not part of VCenter or VCenter Cluster). We have tried the linux script. but are unable to import the XML file. We need to get our NON-VCenter ESXi nodes into our Asset Management/CMDB for tracking and ticketing. This is a bit of an issue for us. We have also tried by network scanning and using network scanning of AssetExplorer as a distributed scan. The ESXi nodes don't show up and are not imported.
Issues with Mozilla Firefox
Hello, We have an issue with creating new requests, the issue only happens with Mozilla Firefox, if we try to create a request and the requester has a special character in their name (á,é,í,ú,ó) it gives the message that the requester does not exist. Any ideas? @Database Name = PostgreSQL@ @Database Version = 9.2.4@ @Current Build = 9235@ @32 / 64 bit installation = 32@
Planned maintenance of our US Data Center
Dear Customers, Earlier this year, we made a decision to set up a new US data center with greater bandwidth through upgraded WAN links, better and powerful application and storage servers with sufficient head room for future growth. In September, we tested this new US data center successfully, by switching and serving all our apps from the new facility, before we switched back to our primary data center. The test was accomplished with minimal service disruptions. Please refer to this related post.
Advanced Search Condition on Dates Needed
We have a lot of Date fields as part of our SDLC process and I have bumped into this a few times but for date fields I could really use a condition that is "None" or "Is Empty" On the pick lists you can choose "None" when needed but for a date I can't evaluate the field for an Empty/Null Condition (Attached Pic for reference)
Login Name for AD users that were imported
I need to have the login name for imported AD users to accept the UPN and the email address both and link to the same requester. Currently, you can authenticate with the email as the login name but it doesnt link to the same requester as UPN and creates a second requester.
Manual AdAuditPlus an clustered DataOntap version 9.0??
I wonder if there are any manual how to configure NetApp Filer with clustred DataOntap (cDot) version 9.0? The manual in the program is not for cDot since the cifs options dont apply to cDot 9.0. I also wonder how AdAudit Plus knows which user to use on Netapp? I have tried doing it according to different manual I have combined but I only get: "Error in getting Shares, Access is denied - Error Code:5" Hoping there is a much newer manual! Thanks /Catherina
Standart and custom variables in mail/sms templates
Good time of a day. Can I use e.g. Technician Mobile Phone number or custom field value variables in mail/sms template like i use $Title, $RequestId and other? For example: Ticket registration template Dear $RequesterName! Your ticket was added. Engineer who will solve your ticket: $Technician (Mobile phone: $TechnicianMobilePhone) Is this possible? Best regards, Alan
Project feature requests
1. Ability to copy an existing project to a new one. 2. Projects list - be able to just see my projects and define views similar to Requests. 3. Make the "Priority" list different from Requests. 4. Clear out date fields. Thanks.
Service won't start
Hello, I did an upgrade to EXC Reporter Plus to version 5.1.6 and then i wanted to upgrade to the last version 5.1.7 , but i got an error witch you can see. I wanted to return to previous version, but I am geting an error that update was corruptued, did restore of backup I made before update, but service wont start at all, well it starts for 10 seconds then it stops. (I have the same update error with OP Manager, but servers works fine, just won`t do the update) Can you please help me? Kind regards,
Report Feature Requests
1) Ability to alphabetize/sort the Report Folder List 2) Ability to make nested folders 3) Granularity in security permissions to view/edit/create/delete to the report folder level 4) Ability for the filtering to be customized and run by technicians who do not have the ability to edit the reports. Minimally it would be nice if date ranges could be set without requiring report editing permissions Under the current model too many people require reporting editing permissions-- if its this open you end
Styles in solution editor (HTML or HTML-like)
We are trying to get some consistency of style across the solutions that are shown to requesters in the self-help portal. I was expecting that, as it is shown on a web page, you would be using an HTML editor that allows the selection of heading tags for solutions, but it appears that it's just rich text. Although a proper HTML editor would be best, the key requirement is for some simple pre-defined styles so that headings of several different levels (complete with appropriate top and bottom padding)
Reports
Require a way to setup filters and parameters in the Reports. Right now there is no way in the ServiceDesk Reports. Unable to integrate to ManageEngine Reports or Zoho Reports. Would like to be able to select Users in the Report showing Assets by User.
lending assets to users on a temporary basis
Hi What will be the most efficient way that we will be able to lend out i.e. laptops to users and there should be a record that its borrowed out and also when its due back to the IT department both user and tech should get a email, or just tech either or. Thank you
On behalf of - Param set to "Department" - user cannot see requesters from the Department assigned
Dear all, We have activated on behalf of functionality with parameter set to department, and identified that users cannot see any other colleagues in their department, even if several users belong to the same Department from the AD extract. It's simply blank, and changing department name in the CI tab doesn't do the trick. Another question I have is if the Managers of a department are also included. Most of the times, people open tickets on behalf of their Managers. Kind regards, JS
PMP timezone
I installed PMP, I found the time of audit log is using GMT instead of my local time. How can I change it to my local timezone (HKT GMT+8)? Thanks!
Does PMP supports SP initiated SSO or IDP initiated SSO
Hi All, Am using Password manager pro as service provider along with our Identity provider. When I tried SP initiated SSO , it got failed and in logs its showing "" response from the idp is expired. please check the pmp server time "" . After that I checked my IDP time and PMP Server machine time and both are same. Still it is showing the same error. And am having one doubt that it supports SP initiated SSO?
How can configure NCM
Hi, I recently made the upgrade to version v12.2 of OpManager. I would like to know how configure the credential for backup Cisco configuration on NCM. I need the parameters for TELNET / TFTP Protocol on "Apply Credentials" Options - Primary - Additional I try but not work. Thk soo much
Using Desktop Central for remote control within Service Desk Plus
I thought integrating Service Desk Plus with Desktop Central caused it to automatically use Desktop Central's remote control but that doesn't appear to be the case. We want it to use Desktop Central for all remote control. It does work if we click on the Desktop Central toolbar, find the workstation and get control, but we really want our technicians to be able to get remote control directly from the link on an incident or request.
Monitoring files older than x time
Hi I use manageEngine Applications Manager 12. We have a directory on a windows server where files are being placed any time of day. These files are moved when they have been processed so the directory should always be empty. Files in the directory should never be older than xx minutes. Is it possible to monitor and get a warning mail when the oldest file in the directory is older than 15 minutes from current time? I have tried this with Custom Monitor, File / Directory Monitor but have not succeeded.
Cannot integrate ServiceDesk Plus with OpManager
OpManager version: 11500 Servicedesk plus version: 9103 I'm using self-signed certificate for OpManager and 3rd party valid certificate for Servicedesk plus both running https. I followed this article to set up the integration; but I encounter an error asking to check if ServiceDesk service is running Please help me get the integration working. Regards, Alireza
SDP&SalesIQ
Hi,Are there any options for the integration of SalesIQ to ServiceDesk Plus? Thanks!
Need a AIX Agent to collect Asset data
We are trying to create a AIX Unix extraction that will send server data to our ServiceDesk Plus server like we do for all Windows and Linux computers but have not been successful. Do you have a AIX agent in use that may have been created and or used that I can not find within SD? If you do not have an agent I need help to troubleshoot why it is not collecting data even though it seems like it did send it. This is where it's sending xml file: hostName="TXBMEFTWP01" portNo="8080" protocol="http"
Adding Notes Column to existing reports
Hi I have a report I have an existing report that I would like to add a column for for notes. Using postgresql please see below for existing report. . SELECT cd.CATEGORYNAME AS "Category", wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", cd.CATEGORYNAME AS "Category", scd.NAME AS "Subcategory", wo.TITLE AS "Subject", wotodesc.FULLDESCRIPTION AS "Description", urgdef.NAME AS "Urgency", ti.FIRST_NAME AS "Technician", pd.PRIORITYNAME AS "Priority", std.STATUSNAME AS "Request Status",
Disable the Description Field
Hi folks, Some time ago I submitted a feature request to be able to have a field that was just a label, allowing us to put any amount of text onto a form. While I await that, I'd like to use the description field for that purpose. The idea is that the description will hold a list of policies ending with "By submitting this request you agree to the policies above." However, I'd like to disable the Description field from being edited via the Field & Forms and Is this possible? Thanks, Adam
Is it possible convert an incident to a Service Request automatically?
I known an incident can be changed into a service request by click a action in the request detail page. My question was: Is it possible convert an incident to a Service Request automatically? For example： When incident request‘s category is "hardware fault", then convert this incident into a service request with the template named "Hardware replace apply". Thanks
Unable to assign a ticket to a technician when i am in the ticket.
I am unable to assign a technician when im inside the ticket. The groups and technician selection popup box comes up fine, but i am unable to hit enter to accept. this is happening in IE, Chrome, and Firefox. Any suggestions? -shane
Requester does not exist
Hi, there is a problem when user want's to create request: Requester not found. This happens only when the user name and last name is spelled with Cyrillic letters(with space or without the first name and last). Please see the attached file. SDP version: 9.2 Build 9235
Worklog Report across all modules with Account
Hi, We need a report that provides all worklogs from all modules (requests, changes etc.). We have found reports that do more or less what we need from other forum posts, but they do not include the 'Account' field which we require as we use the MSP edition. Does anyone have an MSSQL query that will provide us with this information? The columns we would need would be as follows as an example: Module ID Module Account Title Created Time Technician Time Spent 1 Request Company Remote session with customer
Service Desk MSP
Hello, You have two mobile apps for ServiceDesk+ and for ServiceDesk MSP In your mobile app for SD+ you have a TASKs module, but there are no such module in mobile app of SD MSP version. Why? For MSP companys it is very important for filed engineere to see and edit tasks in mobile app. Is there are any possibilities to see/edit tasks in MSP version on mobile devices? Thank you
Business Rules are not being applied to a custom Request Template
We have created a custom Request template. None of the business rules that we use work on requests submitted with this template. How can this issue be resolved?
ServiceDeskPlus: Windows or Linux VM
Hi, I'm going to deploy ServiceDeskPlus on new virtual machine (HyperV) What is the best OS for this application or it does not matter? Thank you
Inventory shows wrong software
Hi, Few days ago I installed a new sw on my workstation and uninstalled after 10 minutes, but it stuck in the inventory. The inventory scan not remove it either. Have you any idea what's causing the fault? How can I remove the wrong sw data? Regards, Ferenc
Manage IT assets
Hi, i have a question about how to manage it spare assets like cpu, hdd, psu, mb, etc in servicedesk plus. how import and manage and monitor them in SDP? thanks
Next Page
