Report SQL Query
Hi All, Please can I have some assistance below. We need to amend the below query to show contact details such as phone numbers against the "Last Logged on User" and NOT the "User". Any help would be mostly appreciated! SELECT MAX(workstation.WORKSTATIONNAME) "Machine Name", MAX(workstation.MODEL) "Model", MAX(workstation.MANUFACTURER) "Manufacturer", MAX(workstation.SERVICETAG) "Service Tag", MAX(workstation.LOGGEDUSER) "Last Logged In User", MAX(state.DISPLAYSTATE) "Asset State", MAX(osInfo.OSNAME)
Report SQL Query
Hi All, Please can I have some assistance mending the below. The script shows all the correct information but instead of receiving contact information regarding "User" we need it to show all the information for the "Last Logged on User" such as phone numbers etc. SELECT MAX(workstation.WORKSTATIONNAME) "Machine Name", MAX(workstation.MODEL) "Model", MAX(workstation.MANUFACTURER) "Manufacturer", MAX(workstation.SERVICETAG) "Service Tag", MAX(workstation.LOGGEDUSER) "Last Logged In User", MAX(state.DISPLAYSTATE)
Graph: Total requests as time goes
Hello, I'm looking to be able to generate graphs that show the total amount of open/onhold requests at the end of each week. The vertical axis would show number of tickets (say a scale of 0 - 500) The horizontal axis would be time in week (for example: January Week 1, January Week 2, Januar...) The amount of requents needs to be total, not new. So if a request lasts from week 1 to week 3, it would be counted in week 1 and 2. Hope that makes sense. If someone can show me how to do this, then I'm looking
Cookie issue after upgrade to version 9200
Anyone else experience issues with ticket module in ServiceDesk since the upgrade to version 9200 - everytime I want to open an existing ticket or when I create a new ticket the website stop working, I just got a blank page. The issue affects every web browser and seem only to affect ticket module in ServiceDesk. As soon as I have created a new ticket or open an existing one I have to delete two cookies before I can continue to use other modules in ServiceDesk. The cookies in our environment are
Advanced Search fails on requester is
Hi, we've noticed that when using the advanced search functionality and search for Requester is, the systems returns 0 results. However running the search as Requester contains returns some results, so there are clearly tickets logged. Is this a known bug? We are using : 9.1 Build 9120 Thanks Lynne
New request opening through email - not working
Hello, I am new on this forum so my apology if I'm not asking on the right thread. So, I am having problem with my manageengine service desk, particularly with request creation through email. Everything was working fine until today. I've tried to restart server, mssql... I can see that mails are forwarding to mail account that is designated for request creation. It would be wery kind from you if you could point me where to look for the problem. Thank you in advance.
Request not opening on new email creation
Hello, I am new on this forum so my apology if I'm not asking on the right thread. So, I am having problem with my manageengine service desk, particularly with request creation through email. Everything was working fine until today. I've tried to restart server, mssql... I can see that mails are forwarding to mail account that is designated for request creation. It would be wery kind from you if you could point me where to look for the problem. Thank you in advance.
Problems - Advanced Permissions
There are a decent permissions management for Requests but not for Problems. Could you please consider to add the following permissions: Technicians allowed to view: All Problems All in group & assigned to him
Waiting to load adventnet.com
Hi, When users try to access our servicedesk it gets stuck attempting to access www.adventnet.com, after a few minutes waiting it loads the helpdesk successfully. After this initial attempt the page loads quickly, until the user either logs off their machine or the server restarts in which case it needs to go through the initial long load time. Have tried updating the servicedesk but it did not improve the issue.
Waiting for adventnet.com
Hello, For the last week when users try to access our helpdesk it gets stuck trying to load adventnet.com, after a couple of minutes it loads the helpdesk and is fine from that point onwards until either they log out or the helpdesk server restarts. Tried upgrading the servicedesk build to 9000 from 8217, still the same.
Service Catalog & Business Rules
Is it possible to use "Change Request Template to" to assign a request template from the service catalog, rather than an incident template? We need to use business rules to assign incoming requests through email to a specific template in order to use a workflow for approvals that has been configured.
Administrator site not work after upgrade
Hello! We upgraded from version 9120 to 9200 with "updatemanager" batch file. The process finished successfully but we have some issues in the admin site. When we try to set anything we got a blank page and nothing happens. For example we tried to add a technician and click a letter to jump in the requester names the site goes to "https://servicedesk.orgdomain.hu/RequesterDef.do?startsWith=r" but nothing appears in the browser. We tried it in different browsers like Chrome, Firefox, IE and Edge
Aterisk integration
Hello. Tell me please, whether the appearance of integration is planned with Aterisk systems , meaning it Service Desk plus. At the end of last year, this item was on the list of the following features , is now removed . Thanks in advance for your reply
Asset is not visible in request anymore
Hi! After upgrading to the version of SDP, where assigning multiple assets to a request was introduced - I noticed that associated asset is not visible in Request Details view. See screenshot: However if I click Edit button in the upper part of this View - I can see that the asset is assigned to this request: Also I noticed that if I search trough the requests and include this asset's name as a search parameter - no requests are found (like if no requests had that asset assigned): At the same time
Auto closure based on email received within existing request
Hi, We have a vendor that doesnt use our ME tool, but when requests are assigned to them an auto email sends and creates a ticket in their system. When they resolve the job a email notification gets sent back which attaches into the request within ME. Is there a way to auto close these tickets when the email is received within the request? The email will have specific detail in the subject e.g request number and "confirmed" or "resolved.
Report time spent by members in a project
Good afternoon I need your help. I need to generate a report showing how many projects are involved and how long an individual is employed. Also a report showing the comparative of the planned advance against the actual status of a project. Thank you
Report time spent by members in a project.
Good afternoon I need your help. I need to generate a report showing how many projects are involved and how long an individual is employed. Also a report showing the comparative of the planned advance against the actual status of a project. Thank you
Report time spent by members in a project
Good afternoon I need your help. I need to generate a report showing how many projects are involved and how long an individual is employed. Also a report showing the comparative of the planned advance against the actual status of a project. Thanks
Erroneous notifications about request unassigned within group
When handling a request, we often assign it to a specific technician and group in one step. ServiceDesk Plus then sends out an e-mail notification to all the members of the group stating the the request is unassigned within the group. When every member of the group responds by viewing the request, they see that it is in fact assigned to the one intended. Peeking inside for a possible cause, history shows a sequence of property changes with assignment to the group assignment before the technician
Could I somehow add an additional requester lookup as an input field?
We have a service catalog request for onboarding/offboarding. It would be great if we were able to add an additional field that would lookup a requesters name, instead of the form filler manually putting in the first/middle/last name of the employee that needs provisioning. Is it possible to inject the same requester name field/lookup, elsewhere on the form and bind it to a data field? basically the "search requester" input method.
Removing Support Group
Hi, I'm trying to do some housekeeping and remove old support groups, but even though there are no Techs assigned to a support group, I receive an error message stating 'Groups cannot be deleted' when I try to delete it. How can I delete these groups? Thanks
Email Commands Help
Hi, Please help with the email commands, cant make it work, All i want to do is Change Status from A to B and Change "additional field value to xxx" please write syntax , Thank you for your time.
Auto-assign request based on a "Leave type"
Hi all, I have an idea to auto-assign specific requests to a technician who works on a remote side. It can be done by Business rules. But this technician is different during one month (one week - one specialist, next week - another specialist). How can I configure the rules so requests are assigned to the technician with specific Leave type? Thank you in advance. Nikolay
Scheduled Report
I need to create a report on the last day of every month. If I add a scheduled report, select all months and set to generate this report On Date of 31, will it run, for example in February 29?
Request Catalog : does not record "Responded Date" when technician replies
Good morning, we are having an issue gathering KPI's when utilizing the request catalog. If I want to track Response Date after a technician has replied in application to the requester it does not trigger an update to the "Responded Date" instead all of my Responded Date's are "Not Assigned" when I run reports. I also tried to add a note and consider as first response - however the option does not exist for Request Catalog. Any help would be much appreciated.
HTT 500 error and sdp.settings.filepathexists.error
Hello. I download a Standart Free version of ServiceDesk Plus. (Version 9.2 Assembly 9200). System is installed on Windows 2012 Std RUS and MS SQL Server 2012 RUS (Windows 2008R2 RUS). Collation of DB SQL_Latin1_general_CP1_Cl_AS. When I changed the configuration in web menu or I configuring users settings in the system parametrs, I get an error sdp.settings.filepathexists.error. What is it? Where i see the logs. Help me please. Sometimes there is an error 500 , it helps clear your browser
sdp.settings.filepathexists.error
Hello. I download a Standart Free version of ServiceDesk Plus. (Version 9.2 Assembly 9200). System is installed on Windows 2012 Std RUS and MS SQL Server 2012 RUS (Windows 2008R2 RUS). Collation of DB SQL_Latin1_general_CP1_Cl_AS. When I changed the configuration in web menu or I configuring users settings in the system parametrs, I get an error sdp.settings.filepathexists.error. What is it? Where i see the logs. Help me please.
Import modified requester information
Hello, I'm looking to export my existing requester list, make modifications and excel and import the list in order to apply the modifications to the existing accounts. Is there a DBID or identifier I could use in order to avoid creating duplicate entries when I import the updated records? My company is currently using Version 9.0 Build 9049. Thanks.
it is possible rename category field by another name?
Hi, it is possible rename category field by another name? Thanks and regards, Gerardo Cortes
Service Desk Server service not starting
When attempting to launch the application it hangs at Application Layer started.....I also cannot start the service I receive Error 1067. Please helpa s I cant move forward .
Adding Payment for purchase order
When entering a payment to a purchase order, it doesnt actually add one: Clicked Save In this case, its not the full payment, but vendor sent multiple invoices at different times, and I wanted to pay this one now. When I get this prompt I click cancel, because I dont want to notify anyone. Then I see no payment: Even if I modify the notification portion (click OK and fill out that form), it doesn't add it.
SDP - Failed to start Server after SystemCrash
Hi, our Server 2008 R2 chrashed hard due to hdd failure and after rebuilding the system SDP Server fails to start. Done some googling and checed the forum but none of the tipps helped so far :( Here is the error message running run.bat after stopping javaw.exe: and attached pls find serverout0.txt.... [17:40:23:476]|[02-08-2016]|[SYSOUT]|[INFO]|[10]|: scanner initialized| [17:40:23:491]|[02-08-2016]|[SDPStarter]|[INFO]|[10]|: ========================================================| [17:40:23:491]|[02-08-2016]|[SDPStarter]|[INFO]|[10]|:
Mail Fetching Issues
Please I am having issues with my Servicedesk plus, for about 2months now I have been having issues fetching mail, its stops and starts again, but now for a very long time it hasn't started, we had to relocate the server of recent and when we got it back on it worked for some minutes and stopped. At present we have over 3000mails waiting to be fetched and this is putting us in a bad light need help ASAP. Checking System log I see; Issue in email fetching Module: Mail fetching Type: Error Probable
Time lapsed analysis tab
Hi, I've noticed that the time lapsed analysis tab sometimes displays "no data available", as below. Do you know why this is? We are using 9.1 Build 9120 Thanks Lynne
Embedding Youtube Videos in Solutions
Hi, As of now, It is not possible to include HTML content because we don’t have Insert HTML option in Solution Editor. I can manage to get the Insert HTML option by changing some of the parameters in ze_init,js file. Now i have a real issue. If i'm trying to include the iframe code then SDP removes the iframes from description. <iframe width="560" height="315" src=“XXXXXXXXXXXX" frameborder="0" allowfullscreen></iframe> Embedding Videos in Solution is the basic feature for any helpdesk system. I
Technician Calendar/Asset Checkout
When can we/I expect to see a shared calendar for the technicians and an asset checkout feature? I have been requesting these features for well over a year now and the response given has always been either in an upcoming service pack or on your roadmap. Are these features ever going to be integrated into SD or should I just forget about it?
Unable to Edit E-mail Id(s) to Notify
We have had several issues where users put incorrect information in the E-mail Id(s) to Notify field. This makes it difficult to close the ticket. Is there any way to edit this information so the bounce back email doesn't keep opening the ticket? Thanks, Brian
Assets assigned to department not seen in the New Request page
Hi, I have assigned an asset to the department via Assets tab. But when a user from this department creates a request he cannot see this asset in the drop-down list. He sees only assets assigned to him personally. The point is that I want to allow every user from the department to open request for this particular asset. Is there any way I can do this? Thanks
login page
Hi I cannot customize my login page. I upgrade from 9112 to 9115. but when i create custom\login\custom.html it can not read by server and the old login page shown. I remove the old customized login page in "C:\ManageEngine\ServiceDesk\applications\extracted\AdventNetServiceDesk.eear\AdventNetServiceDeskWC.ear\AdventNetServiceDesk.war" but not occure any changes. Please help me Thanks
how i can add link to the login page
I want to add link under the login button , like this : i tried to modify the custom.html page , but i found that it will not add anything under the LOGIN button , and it will just effect the header or footer of the page . So can anyone help me in this ? Note : We are using ManageEngine ServiceDesk Plus | 9.1 Thanks
Next Page
