Query report - date
Hi all, I need a help with MySQL to make a where clause that shows me only the lines where CompletedTime = CompletedTime - 1 day. I know that in Oracle would be something like this: (TRUNC(wo.crompletedime)>TRUNC(SYSDATE)-1) The rest of the query is ready, I'm only stuck in this where clause. My SQL is Linux Based. Tks in adv, Thaiz Cabral
How to use a different instance of MySQL in ServiceDesk Plus
I have already MySQL installed on my Red Hat Enetprise 4.0 server. How can use Red Hat's MySQL instant in ServiceDesk Plus
Hidden categories from requestors
We would like to see the inclusion of category visibility control in future releases of ServiceDesk+, i.e. the ability to hide categories from requesters but make them visible to technicians. We like to make to the act of making a request as easy as possible for users, this means simple understandable categories, however this does not provide our technicians with the level of granularity they require in categorising their workload. An example being a user might make an "e-mail" related request, but
Drop down menu for request status changing by technicians
we would like it so that you dont have to edit a request to change its status through a dropdown would be ideal
Technican as a Requester
Hi, I have added several technicans to our system but it seem that they can't be a requester at the same time; is that right?? I think it's quite normal that a technican can also be a requester ...
Bar code functionality
How is the Bar Code field designed to be used? We would like to be able to have a bar code on all our equipment and associate it to an asset. Another thing we would like to do is perform a physical inventory of all equipment with a data collection device and upload it into the data base and/or compare it with what is in the data base for any changes/additions. Also can we print the bar code labels from the system or do we need to purchase/make our own labels to enter into the system. I think we would
Phonelist
Is there a way to provide the requesters a phonelist of the imported active directory users ? All data is in the database, so why not use it
Change "title" to "subject"
Is there anyway for me to change the "Title" heading to "Subject" on the request form? Our employees are are experiencing some confusion about what is meant by "title" and some of them are listing their job title (which does us no good) instead of a subject line for the request. If there is something that can be easily modified in the database, please let me know ASAP. If there is no easy fix on my end, I would like to request that a feature be added so that we can rename the header text for the
AD overwriting moible phone numbers changes
When importing accounts from AD SD+ also imports the Mobile phone numbers from AD witch is what we want. But if a requester changes there number the change will be overwritten next time AD is imported. Is there away to stop AD overwriting such changes or for SD+ to update AD?
Asset Allocation History
Hi Guys Firstly great product - looking forward to version 5 upgrade release. Just wondering if anyone else would like to be able to build up an asset allocation history record, for example if I allocate an asset to a user I would like to record the start date and end date that user is allocated the asset and then continue doing this through the asset life, its useful for audit purposes to record who has had which asset when. What do you think?
How to restore columns on Request page?
I accidently removed all columns under the request page. The icon that allows me to do so is no longer there. how can I restore the columns. See attachment. Thx.
Need Alternate User Authentication
The feature "Keep me signed in" will not work as a solution on my network. I had been synchronizing with Active Directory (worked well) until my organization mandated smartcard logon. Now users cannot be authenticated by AD because they no longer use a user ID and password to log onto the network, they use their smartcard and PIN. SD needs to provide a pass-thru authentication or some other means of logging into SD with their smartcard credentials as soon as possible. My users have cannot log into
Active Directory Synchronization
I used active directory to populate the requesters so passwords will be updated from AD. It also populated the departments and they are not the department names I want used in this software. 1) How do I clear all department names from the list without doing them one at a time? 2) How do I prevent AD from trying to populate that info again?
Service Desk on Windows 2003 64 bit
Hi, Is there any chance to run Service Desk Plus on Windows 2003 Enterprise Edition 64-bit? Because I can't get it to start. Gabriel Gearip
Stop logins expiring - administrator cant log in!
We have been using SD+ for a little while now and it would appear as if our administrator login has expired. How do we stop logins from expiring as this has obviously caused us a huge problem if the administrator cant log on to the helpdesk
HTTPS
I want to run SDP though HTTPS only. I know I can set the HTTPS port using the changeWebServerPort batch file, but is there a way to disable the HTTP port as well? I want HTTPS to be my only option. Thanks.
Assign workstation to owner using SQL
Hi, How can I assign workstation to owner using SQL ? Which table should be modify ? Br T.
How to use a different instance of MySQL in ServiceDesk Plus
How can I use different instance of MySQL in serviceDesk plus in Red Hat 4.0 enterprise server.
How Can I Track Changes In Network Inventory (Hardware)
How can I monitor inventory changes ( e.g Hard Disk, RAM, CPU) in my network.
Problem with Advanced Filtering in Custom Report
I have created in Asset - Additional Fields text field "Room" with Type: Pick List. Then I create Custom Report and try filter this text field values. In Advanced Filtering I select column "Room", "is" and press "Choose" for pick values. But in pop-up window list of values is empty... When I press "Ok" in pop-up window the following message displayed: "The selected date should be greater than the current date". SDP build 5506, 5507 - same results. Please, help. Thanks.
Replies to existing jobs are not being highlighted
We are noticing that when a requester sends a reply in to a case it does not show as emboldened in the list of requests and we are missing the fact that the client has replied. Unassigned cases are in bold. This only seems to have happened recently - we are running build 5505 but I am not sure if 5506 had any effect on this? Thanks
Serial number monitoring to prevent duplication
Hi, I was wondering if SD+ can monitor serial numbers to prevent duplication of PC details in AD when I rename a PC. I know that SD+ used to obtain all information based on NIC on a workstation, but I was wondering if there was any way to achieve the same result based on serial number. At present on rescan, we get duplication of PC's.
Please use mysql versions greater than 4.1.12????
Hi everyone! Has anyone come across this when they run the trial version of ServiceDeskPlus for the first time? Server is starting. This may take a couple of minutes ... This evaluation copy is valid for 28 days Please use mysql versions greater than 4.1.12 [root@servicedeskplus bin]# I'm currently running Fedora Core 6, and this happens when I do the modification from here: http://forums.manageengine.com/forumHome.do?forumGroupId=49000000002007&forumTopicId=49000002677595 At first I got the "Trying
empty report
i have install service desk on a server belong to one of the forest then i extract from active directory full users and users also from network scan i extract network after all of that i can't generate any report, all the report come blank like inventory report by os, however in inventory browsing all the data appeare also i can access another forest which is not belong to the service desk server i can browse active directory but when i wxtarct the users nothing beeing extaract however i extract
Workstation is asset question.
Hi, we currently have a situation whereby we purchase PC's as packages with the monitor, keyboard and mouse all included. in this scenario the workstation is the asset (ie the workstation does not have an asset added). is there a nice way to reflect this scenario in DA+ ? regards, Daniel.
Technician notifications
Hi Support, I have all notification emails in rich text format (HTML). Whenever we received notification emails for unpicked tickets in a group, the email received is unreadable. It looks like the HTML formatting is broken/lost. We are using outlook 2003. Mime-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9_24544119.1162881120819" ------=_Part_9_24544119.1162881120819 Content-Type: text/html;charset="UTF-8" Content-Transfer-Encoding: quoted-printable ****************** Action
Access to MY SQL tables
I'd like to be able to clear one of the tables in SQL since the AD sync brought over department names that I don't want. There are 502 records and I started deleting them through the app, but it's taking way too long. What is the password to attach to the SQL tables?
Warranty tracking
Hi, We plan to purchase servicedesk plus in our Network Management dept. but there's a feature that we would really need: if an asset is defective is sent back to the store; we would need a module where we write the time of the sending, the defect, if the defect was repaired, date of arrival etc. All this would be related to the asset. Thanx! Gabi.
Add Notes notification email
Hi, Whenever I add a note (Actions -> Add Notes) and select the "E-mail the technician for notes addition" option, an email with the header and subject below will be generated: =============== From: Helpdesk [mailto:helpdesk@abc.com] Sent: Tuesday, November 07, 2006 4:26 PM To: Jones, Alan Subject: Notes has been added to the request with Request ID :##11## =============== All the customized templates in the Notification Rules have been customized to our preferred format and layout. The above is
CPU Contention Problems with MS Report Server
Our installation is having contention problems with AdventNet Service Desk and Reporting Services. I cannot Start the Report Server as a service on the same server as AdventNet because the CPU starts running at almost 100%. This causes Service Desk to lock up and I have to stop the Report Server and restart Service Desk before it clears up again. Has anyone else had this problem in the past? Thanks! dyb
Symbol in requests after upgrade to 5507
After my upgrate to 5507 I get the symbol � in my open requests. Please assist
Query - group and login
Hi everyone, I need a query that gives me the following information: Request ID, Technician, Status, Created Time, Completed Time, Login and group. Tks a lot, Thaiz Cabral
Due Date
Hi, Can i know how the Due Date is set automatically on Requests. Manesh
Query
Hi I need a Query to do the following Sorted by Company, Request ID, Title, From Time, To Time, Time Spent, Assigned Technician, Resolution, Description
Cant see tables from crystal connection
Hie I have succesfully setup my ODBC connection. I have tested the connection and am getting TEST OK. From Crystal when i try to create a report. I go through ODBC (RDO) then select make a new connection, then select servicedeskplus and enter root for the user. My problem is that i cant see any servicedeskplus tables. I can only see the mysql database and no more. What else should i do to get access to the servicedeskplus database and table I have attached a screenshot of my connections. regards
Expired trial, licence installation
We installed the 30 day trial 30 days ago and have just purchased and received a licence. It would appear that I was just a bit too late in installing the licence as ServiceDesk has appeared to just stop, ie the page just does not display. So does the 30 day trial just stop working after the 30 days, and if so can I install the licence some way so that the modifications and data already input are not lost? Thanks
I want to create script Sales Tax
Hi, I want to create script Sales Tax in software HelpDesk . Sales Tax 10% of cost .what do you do ? Help me.
Cannot close workorders
I am using ServiceDesk Plus version 5.5.0. I am having issues with closing work orders. Once the work order has been closed it will "magically" reopen. It doesn't happen to just one technician but all of them (six). Any ideas as to why or anything I should look for in my setup?
Help with query - Requests
Hi, I need a query that gives me the following information: Request ID, Technician, Status, Created Time, Completed Time, Login and group. Tks, Thaiz Cabral
Service Desk Plus SMS Configuration
Hi any body knows how to configure SMS provider in Service Desk Plus , as I find only a configuration for POP and SMTP only in the Admin page
Next Page