Simple survey report
This query will provide a quick numeric snapshot of your survey results by question. So, if you have 4 satisfaction levels you will receive back a number from 1-4, with 4 being a perfect score. SELECT sqdt.QUESTION "Survey Question",round(avg(sadt.RATING),2) "Average Rating" FROM SurveyPerRequest spr INNER JOIN SurveyPerRequestExt spre ON spr.SURVEYID=spre.SURVEYID LEFT JOIN SurveyDetails sdt ON spre.SURVEYID=sdt.SURVEYID INNER JOIN SurveyQuestions sqdt ON sdt.SURQUESID=sqdt.SURQUESID LEFT JOIN
Cisco pix 506e Problems
Hello To Whom it may concern I have a Cisco pix 506e which is refusing to establish any connection with Netflow. I was wonderin if any one can recomand some command lines or anything might help me out. I am trying to establish SNMP c2v its just no validating. Thats all i have right now in the firewall. Inbound all is open no blocks. snmp-server host inside 10.10.10.221 snmp-server location 10.10.10.221 no snmp-server contact snmp-server community public snmp-server enable trap
Maximum Unlock/Reset Attempts?
Is there any way to limit the maximum number of attempts to reset or unlock a password? Overall and within a given time period? We'd like to limit the number of failed attempts so that the users have to contact a help-desk/IT employee after the limit is reached.
ServiceDesk Plus upgrade from 7.0.22 to 7.5
Hi!, I am having troubles to upgrade ServiceDesk Plus from version 7.0.22 to version 7.5. After run updatemanager.bat, it finds an error and rolls back installation. After that, SDP does not run anymore, it remains starting service and persistent layer forever and ever... Can anyone help me? Thanks! jordi.suarezd@t-systems.es
Sending notification to other people
Hello! I would ask for help in changing functionality of sending notifications. I understand that you (ManageEngine) will not make such changes just for me, so I even can modify source code in Java script by myself. What I need: When specialist requests an approval for a request, notification sent to some person. That person make decision and at that moment notification sent to specialist that requested for approval. I really need to send that second notification also to person who created initial
Notification that unassigned ticket has been updated by requester
We've had this happen several of times now and it is not good... We get an end user who submits a new ticket (marked as not a rush) and our support group gets notification via email that new ticket has been submitted. It doesn't necessarily get assigned to a tech immediately (simply because it is marked as not a rush), and in the mean time, the end user that submitted the ticket has updated the ticket (either with more information, a request to close it, or something - but it is an update never
Does DeviceExpert support HP GbE2c?
hello, Does DeviceExpert support HP GbE2c? If support, then how to backup it's configuration? thank you!
[MSSQL with Instances] - Canceling monitor edition returns to the "default" instance
Hi, I'm working on putting "SQLADM Named instance of" for all my monitors of each of my instances (Read previous posts if you want :) I finally did not delete the monitors, since I would probably loose collected data in the process...) and I meet a "problem", here it goes... If I go to the second instance of my SQL monitored Device, I can go "Edit monitor" for say "Granted WorkSpace Memory" (in the Memory Monitors pane), I make my change, adding text to the alarm and clicking "Ok". It
Cisco ASA Backup via SSH --> always unsync
Hallo, I have a problem using Device Expert. I am backing up a Cisco ASA 5520 configuration file via ssh (no tftp possible). Problem: With sh run snmp community string only shows asterisks. Sh startup shows snmp community string in clear text. --> Therefore Device Expert always says configuration would not be synced. Is there any chance to edit the command for backing up running config? If I could use "more system:running-config" instead of show running command, community string within running config
Cisco CS11501
Does Device Expert support Cisco CS11501? I don't see a template in the selection and the copy command is slightly different from the other devices: CS11501 - copy startup-config tftp a.b.c.d CSS11501 filename Others - copy startup-config tftp://a.b.c.d/3901_ConfigFile.txt I think the backup is failing because of the different syntax. Please advise. Thanks.
Reports - Scheduled - Arrgh.... + Suggestions!!!!
Hi Support, I have created a report and scheduled it to send to a particluar set of people including the customer. The customer wants this to be sent to additional members of staff. I went into scheduled reports and clicked edit, there isn't anywhere that I can see where to modify the emil to list. I then created another report, and called it the same as the previous one expecting this to overwrite the existing one. It showed two reports of the same name, which shouldn't be possible!! I then got
Releases/Hotfixes/Roadmap Info/ and Delays
Not really a feature but important none the less let the voting decide!! Inform us of updates/delays etc by having a Sticky forum post that only you can add to that is called Releases. As well as putting the release entry at the top of the forum as you normally do the Releases post would advise on release dates, delays, pre-release notes, and links to the download section. We could then all watch this topic and get emails automatically when there are releases, delays or pre-release notes or development
Warranty display should be based on purchase/contract date and alert if expired
First request - April 2006 Want to be able to add a "warranty" and get alerted if the customer tries to log a call after the warranty has expired. I belive the warranty has been taken over from ServiceDesk I'm guessing that this would be more useful to read Contract Expiry or something similar See full discussion http://forums.adventnet.com/viewtopic.php?t=11494
Email Notifications and attachments to requests
Original request July 07 "User msl Hi I currently have notification configured to send mail to the contact, however due to the way we use SupportCenter, it would be really useful for the message to go to more than one addressee (at least the originator) as well. Furthermore, I often need to save a file as part of the resolution and also send the contact a file as part of the request closure, but am unable to attach files to either the resolution pane or the notification email. Please consider adding
OpManager upgraded 8050 and MS SQL backend
Hello, I upgraded our OPmanager with latest service pack 8050 and now we are facing issues. Opmanager is used with MS SQL backend on MSSQL 2000 First problem When I try to add Windows services I got error Error While handling the request Second problem Process monitor is not working, when I tried to add a process monitor, i'm not getting error message, I've nothing and process monitor is not added. All existing process monitors gone As there aer a lot of great new things in this version
Backup and Rstore OPmanager from windows professional to windows Server
Hi, I have Three questions, 1) I would like to know what is the procedure of backing up OPmanager from normal windows machine to windows server? 2) Is it recommended to make backup of OPmanger oftenly.? 3) When Obtaining new license, whats the procedure to activate it in OPmanger machine ? Thanks,
SLA Criteria
Hello, I would like to use field "status" as a criteria for SLA. How can I do? Thank you in advance!
Server error on restart?
Have installed Desktop Central trial on a server, was testing it out on a few machines. Restarted the server due to a windows update and now it wont seem to start the service. Using the web browser to access it i get the message: Service Temporarily Unavailable The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later. any ideas ? Sniperkid
Job Title field
Hi i wonder if we get someway take the Job Title field away and if it´s not possible can we get text Job Title away. and if i can how do we do it /iS
Bug? Cannot Delete Job Title in Requester window
Hi, I was updating some of the requester information and I have noticed that that the Job Title field contents cannot be deleted (set back to blank). I delete all texts in the textbox and click on update, but when I open the requester again, it comes back. (no error messages) If I changed the Job Title to another title (not blank), then it updates fine. Could you look into this? Thanks
Asset Report
Hi I am after generating a report but cant seem to get the information using the wizard as i want the service tag including. I would like a report that shows the following for ALL assets not disposed of. Resource Name Product Product Type Asset Tag Serial Number Service Tag User Department Any assistance greatly appreciated. Regards Mike
Report: history of workstation assigment
Hi I need to generate report showing what workstations was assigned to user in period of time. I did not see such report in standard reports and did not manage to create it using custom reports. It would be nice also to have report showing to who workstation was assigned to in period of time. Could you help me create SQL query? BR Jan
Actions Menu
Hi When we View a request, is there a way to modify the actions menu to see more status set actions, ie awaiting "3rd Party", this would save time by not having to edit every time. Regards Mark W
Upgrade Question
I am in the process of upgrading our copy of ServiceDesk from 7014 to the current release and moving it from the current server to one that has more storage. My question relates to the ability to migrate some data but not necessarily all data from the current installation to the new install. For example, is there a way to move all of the computer inventory data but not the purchasing history (or some other combination as yet undetermined)? Also, I have a current license. Can that be used on the
How to change the severity of alert?
for example, i want to change the interface down alert(not the trap) from trouble to attention.
How to add specific OID to subnet
Need help, how to add specific OID to the scan result on IPAM
Problem of integrating op manager with service desk plus
trying to get service desk plus to integrate with op manager but op manager tells me my server is too busy to fetch information. I checked the log files and got this error msg. im thinking maybe it has something to do with the fact that im using active directory logins so i dont have a default admin account. only the ones through active directory. your quick response would be greatly appreciated. here is the log file msg. 12:14:00:659 PM Login form post: HTTP/1.1 200 OK 12:14:00:659 PM actionClass
Scan problems
I have run in to several issues with scanning computers. Particularly Mac's. Here is a few: 1. SD+ can't get the Serial Number 2. yet alone identify a host by that S/N (So, If the host info in SD+ and reality are not 100/100, you can't really scan the network without creating duplicates). 3. Domain part is dropped from Resource Name (hostname.domainx.com is OK but hostname.domainy.com is cut to hostname. This creates several issues). 4. Model is shown as --Choose Model-- in edit mode after the scan.
Workstation Configuration
Hi, in Workstation Configuration there is a field 'Location'. I understand that this filters through from Active Directory, am I correct? In Active Directory, the properties allow you to select a location for a workstation but you have to browse to find the location. Can you let me know where the data comes from in the browse button Many thanks Jayne
Time Change
How to change time on the help desk main page?
Starting Issues.....
whenever I start the manage engine service desk application it fails to initialize. And if I try to start manually then alos it doesn't work. Below is the part of the Wrapper log file. Kindly assist. STATUS | wrapper | 2010/03/16 15:32:35 | Launching a JVM... STATUS | wrapper | 2010/03/16 15:32:40 | ManageEngine ServiceDesk Plus started. INFO | jvm 1 | 2010/03/16 15:32:58 | Could not create connection; - nested throwable: (java.sql.SQLException: Network error IOException: Connection refused:
How can I inject SQL for our custom request fields through API?
Does the API interface support SQL injection for the custom fields we've created? I tried sending API attributes like "UDF_CHAR1=Test1" and "UDF_CHAR2=Test2", but this doesn't seem to fill our custom fields. Please let me know how I can auto-fill these custom fields through API.
Daylight Savings Time problem on ServicsDesk Plus
Good morning, I'm trying to figure out this DST issue. On the ServiceDesk Plus home page, the time shows as one hour behind actual DST time. However, timestamps on notes added, resolution, etc. are the correct DST time. What might be causing this problem? I've tried correcting the problem by re-saving the preferences info, but this does not work. I've read on related threads that I might have to update Java using time.jar, but that fix was for DST problems with the timestamps. ServiceDesk
Matrix report group by Year / Month
The matrix reports grouped by year and monts sort column by name of the month. So first is August (08) no January (01). This should be sorted by the number of the month. I have a polish version of SDP. Is names of the months can be translated?
ServiceDesk: Customize number of assets allocated to a workstation
I would like to extend the list in ServiceDesk/Inventory/workstations/Assets tab. Currently, I can only list 25 assets allocated to the workstation and would like additional entries. Where in Admin can I customized this?
Computer Management / Event Log in DC?
Is it possible to access the Computer Management mmc snap-in from Desktop Central? What i am really trying to accomplish is viewing computer event logs from within DC. Thank you!
Change database to MySQL
I wish to use the MySQL already installed on the server. I performed these steps... - changeDBserver.bat - it successfully created the database in the MySQL server and the test connection passed - backupdata.bat - successfully created the backup file - restoredata.bat - ERROR in this step. It seems to create the approx 37 tables but does not populate the tables with any data. I attached the results from the command window.
Add Device That is Not Connected
How do you add a device that is not currently connected to the network? I would like to be able to add a device and setup its monitors so that it is ready to monitor once the device is connected. Thanks,
Custom WMI Perfmon Information
Hi, We have some custom Perfmon values that are being exposed. We can look at these values on the server via the Perfmon viewer however we cannot pull them into OpManager. We set up a new WMI monitor, add the correct credientials, and OpManager can see the Categories with our custom counters and lets us select them. All is good up to this point. -however- nothing is being pulled into OpManager and when we use the 'test monitor' option this fails. All other WMI information from the server comes through
cpu utilisation monitor not right for linx?
I have opManger 8 and the cpu utilisation (cli) for linux isn't working, it appears the command line being used is not right for linux, as it returns an empty string if typed manually on the cli. When you use the test monitor button, it reports no response. The cmd line it is using is top b n 1 | grep 'CPU[0-9* states:' which in Fedora 12 returns an empty string, is there way of editing this monitor so that the cmdline can be altered?
Next Page