Query Error (KPI report :based on group and technician)
This query doesn't work in build 8013 for MSSQL (https://forums.manageengine.com/#Topic/49000005072090) SELECT au.FIRST_NAME 'Technician', qd2.QUEUENAME "Group", (SELECT COUNT(wo4.WORKORDERID) FROM Workorder_Threaded wot4 INNER JOIN workorder wo4 ON wo4.WORKORDERID=wot4.WORKORDERID LEFT JOIN WorkOrderStates wos4 ON wos4.WORKORDERID=wo4.WORKORDERID LEFT JOIN WorkOrder_Queue woq4 ON wo4.WORKORDERID=woq4.WORKORDERID LEFT JOIN QueueDefinition qd4 ON woq4.QUEUEID=qd4.QUEUEID WHERE (wot4.THD_WOID=wot4.WORKORDERID)
Query Error (Re: Resolved time Report)
Hi, https://forums.manageengine.com/topic/resolved-time-report The query above for MSSQL produces the following error in build 8013 - MSSQL: java.sql.SQLException: Operand type clash: ntext is incompatible with tinyint at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
automatic assignment of technicians
With respect to the service desk plus ManageEngine system has the option of automatic assignment of technicians could say that technical limits have to exclude, or until I can exclude few technicians. Data: Application ServiceDesk Plus Enterprise 8.0 Version: 8000
forward using SNMP
Hi, I didn't saw it on the docs. I'de like to forward using SNMP all of the alerts that has critical \ major severity. the idea is that I use opmanager as MLM and would like to forwards relevant alarms to my NOC (MOM). how can I do it (I saw only Email is supported)?
Opmanager Restore Procedure
Hi there How can i restore opmanager mysql database. Databased crashed and i want to restore without reisntalling application. Please help.. I do have opmanager backup directorey.. Thanks Mpumzi
Service Desk Plus-Want Technicians to be Requestors as well
I would like for my technicians to be able to submit requests via the Service Catalog in Service Desk Plus. How can I setup to the system to allow this to occur?
Keyword search in Requests should search in resolution/notes
Most users describe their issues in very basic terms, such that many different issues might get described as "computer crashed" or "Having problems printing". It is in the resolution or notes that the technician is able to more specifically describe the problem. Currently, performing a keyword search in Requests only produces results where the keyword appears in the title and description of the request. Changing the search to look into the resolution and notes as well would allow the technicians
ServiceDesk: Approvals tab - Description field
I have a question about the Description field under the Approvals tab. When the approver adds comments it displays under Description to a detail, but only part of it displays. While I can read the entire description by hovering over it, I would like to copy and paste it. Is there another location (within the Service Desk) that will display the entire contents of this field? Here is an example: Request 47262. The full description (aka Comments) was “We are able to provide only one set of equipment
AD Self-Service Plus Users can register questions, but cannot change them later on
When a user registers on the system, he/she is able to select the questions wanted to be used to later be challanged with. The problem is: how to replace these questions with new ones? Seems like when a person logs on, after having registered, all they get to update is AD information (Self-Uddate), change the AD Password, and sign out. What is wrong and where are the settings that will allow me to change/modify this so users can change their current registered questions. Thanks Bolivar
Failed to receive 20 Item(s) as the Max Number of IT Assets
WTF.... I've just tried to recieve an PO order of 20 sticks of ram, and get this... Failed to receive 20 Item(s) as the Max Number of IT Assets exceeds the license!!! Why is there a limit? What is the limit? I've sent an email to support but havent gotten a reply or acknowledgement of the request.
Customer Portal - Language Options
Currently, customer portal language depends on browser language. For customers who are not technical or speak English, there should be an manual option for users to change the language, like this:
Winlogon screen top banner image change?
Hi all, I was curious if there was a way to customize the ADSelfService installer so that it replaces the banner at the top of the Windows XP Winlogon screen, aka , with an image we specify. I've been able to customize all of the settings and whatnot that we want other than that, but can't find any image files or anything like that inside the MSI that could theoretically be replaced.
Unable to import IIS W3C Web Server Logs or MSSQL Logs
When attempting both a local or remote import of IIS W3C Web Server Logs or MSSQL Logs the import always fails with a message "Import of log file failed!"; however Importing IIS W3C FTP Log's works fine every time. All three logs are from the same server. I have checked and confirmed that IIS is logging in W3C Extended Log File Format. I’ve also tested this from both a 2008 Server Running IIS 7 with SQL Server 2008 and a 2003 Server Running IIS 6 with SQL Server 2005. Previously running EventLog
upgrade from Netflow analyser 7 to netflow analyser 9
Hi I upgraded netflow analyser version 7 to 9, but the GUI is stuck with the version 7. All the backend services (tomcat and mysql) have been upgraded properly though. Any thought ?
Improvements to Solutions Module
Hi, Two things I'd like to see improved/changed with the Solutions part of the program: 1. When Searching Solutions from the Resolution tab, if you choose a solution which has an attachment, the attachment does not get attached to the ticket. I suppose to make this work, the Resolution form would need to permit attachments itself, which would be a helpful feature anyway. 2. Could the "Topic" drop-down when creating a solution use the category/subcategory/item data that already exists in the
64 Bit Linux Agent
I am currently evaluating PMP for my environment and I am wondering if there is a 64 bit agent for Linux? If not, is there source I can compile myself for the agent?
How to configure extra ldap field map
One enhancement in 8015 is: SDF-36318 : Support to map user defined fields from LDAP to requester fields, during the requester import. For now this configuration is available only as a database configuration. Anybody knows howto do this configuration. Thanks
Error when adding URL Monitor
When I add a new URL monitor through 'Admin | URL Monitors | Add ', I complete the form (URL Name, Address, interval, time out, send alert to, unavailable, match content (check now) and click OK, I end up on a blank page with a URL of http://localhost:8060/admin/ConfigURL.do. This happens when I execute against localhost on the OpManager server, from a remote browser, using different browsers (Firefox, Chrome, IE) and IE in compatibility mode, as a trusted site, etc. After receiving the blank page
Adding a Protocol by destination IP address
Is there any way to create a protocol based on source/destination ip address? I would like to get more visibility into our exchange environment but it uses random ports. Thanks!
Schedule reports
Hi. I got several scheduled reports, but since last week they are no longer being generated. I've tried to delete and recreate them but didn't work. Anyone can help me? Thanks. Antonio.
ServiceDesk Plus host URL
We have SD+ working fine from http:\\helpdesk:8080 but wish to present SD+ also on another URL e.g. zzzhelpdesk:8080 ( this is because on a seperate site they already have another entry for "helpdesk" in their DNS) ( and change the notification emails accordingly to come from zzzhelpdesk:8080) I understand there is an URL Alias setting within the Admin, Self serve settings, but will this change the email notification template to the new address? Any help would be appreciated
Is it possible to add a Device type?
Hi there, is it possible to add a Device type? I found that Oputils Device Type list doesn't include FreeBSD, VMware and other devices I have in my network. Regards, Juan Pablo Baserga
switch port mapper for catalyst 4507R not displaying MAC addresses
I'm running OpUtils Professional 5.8 #58027. I'm using snmp v2 to perform switch port mapper but some interfaces show up as Used/Up with not mac or ip address displayed. If i go to the CLI of the switch, it is very obvious that both are available ... here's an example of the output in the web interface with the corresponding CLI output: MDF-4507R#sh mac- int f4/5 Unicast Entries vlan mac address type protocols port -------+---------------+--------+---------------------+--------------------
Restore a database
Hi, i had a problem in my SupportCenter when restore the DB it give me a error "Unable to restore database : Unexpected end of ZLIB input stream" i try several backups always in the version 7701. Thanks and regards, Bruno Rodrigues
Support Rep / License problem
Hi, i have a support rep with AD-login "pf.m". This was working fine. Now i wanted to add a contact with the same name. When i did this, the system asked me if it should link it to the existing support rep. I agreed to this. Afterwards a delete the contact again and also the support rep was deleted. I don't know why. So I wanted to add the support rep again. This was working. Then a tried to activate "enable AD login". But I always get following error: "no more support reps left on your license".
Creating Process Monitor
Hi, Our existing customer having a problem on creating process monitor on Linux machine, currently they using build 8721. Please see my attached file for details. Please advice, Thanks, Joe Reyes Pre-Sales System Engineer AG Datacom Phils., Inc
Password reset link broken
The password reset link is broken - 404 error.
Understanding traffic volume analysis with VPN tunnel
If I monitor the complete traffic of a Cisco ASA Firewall outside Interface, I get traffic volumes for my servers inside IPs and also for the esp traffic between the outside tunnel interfaces between sites. The esp traffic volume is similar to the inside traffic pakets. So,... is the esp traffic the hole traffic including the encapsulated inside IP pakets or is it only the addional encryption overhead? Thx for your help! UH
IPSLA not working
hello, We have the IPSLA module installed on Netflow 9.1 Professional. The module seems to be very buggy. We are trying to query 4 Cisco 2811 routers only one works..I have previously contacted support which they have called to provide support but after an hour of troubleshooting I was told the problem is with the routers. I have verified the configuration and even changed one of the routers hardware and the problem is still the same. If from the router command line I run sh ip sla monitor statistics
I cant monitor process or something in linux OS
Hi there, I have installed Opmanager 8.0 in linux server, i want monitor some linux process like server itself, i have read all topic about linux monitoring but nothing i've found yet. I have added monitor in Performance monitors and chosen by cli monitoring but it didnt work, What else i try ? Thanks in advance,
Software list - SQL - help needed
Hello Is there a way to create queries graphically, using a third party app eventually? Would somebody help me please on an SQL (mysql) for a List with installed Software I am stuck at this point (see below) but I also need workstation state (in use, disposed, ...) , software type (managed, freeware, ...) as well as site, department and user and ordered by software SELECT SystemInfo.WORKSTATIONNAME "Workstation",WmiSWUsageInfo.SOFTWAREUSAGE "Software_Usage",SWInstallationKeyInfo.SOFTWAREINFOID "Product_ID",SWInstallationKeyInfo.PRODUCTID
Configurations (user and computer)
Hello, need to know if a copy can be made of current configurations without having to create the configuration from scratch.
Juniper 2320 - No CPU, Memory, Temp dials
Can you please explain how I can fix this? I've seen a couple of other posts, but support seem to fix this without any explaination - it would be helpful to post the fix I think. Either way, just happy if I can get this solved. Ta
With the client installed Network Level Authentication/Single Sign On fails to the server
With the client installed Network Level Authentication/Single Sign On fails to the server causing users to have to login twice. The server details are: Windows 2008 R2, Enterprise, 64 bit, Service Pack 1 Configured as a Remote Desktop Host Server (the issue occurs both in and out of a Connection Broker Farm) Example: Windows 7 desktop configured to use “Cred SSP” to delegate users credentials to the server. This works without the client on the server, with the client installed the user is presented
Changed Password Policy on SBS Server but ADSelfService still shows old Policy
I changed the domain policy to allow the user password to be changed in 0 days rather than 2 days but ADSelfService still shows minimum age of 2 days. Why is it not updating after stopping and starting the service? I also did a gpupdate /force after making the policy change in Group Policy manager and then stopped and started the service for ADSelfService.
SDP Asset Management - Cisco Equipment Configuration Management
Does SDP provide such feature that I can use network scan to discover all the cisco router/switch via SNMP and also retrive the IOS version, configuration files into the asset record? And also provide the configuration comparison feature? If not, is it possible to integrate the DeviceExpert with SDP? Thanks.
Requesters via external database.
Hi All, Is there anyway to have SD+ or SD+MSP query an external database to get a list of requesters without importing them to log tickets. We are trying to prevent having to import and maintain requesters in SD+ from our accounting and production systems which are integrated. Thanks Tim.
Disassociate technician groups from sites
Unless I'm missing something, could I request that technician groups be decoupled from sites? We have several technician groups which with very few exceptions consist of consistant groups of technicians across all sites. If groups of technicians & their associated email notification settings could be set up as a self contained entity, these groups could then be linked to a site rather than having to recreate them for each & every site (which is a real pain if the group changes). This would also
Import Users from AD OU
Hello We're trying to have all of our password resources be assigned permissions based on the AD group that the users are in. We created an OU for PMP, and would like to have all of our groups underneath the OU. When I try to import the groups from the OU using the Import from AD feature, I cannot figure out which naming convention it requires. Anyone have an article or thread that might guide me in getting this to work? TIA Mike
Integratre Netflow Analyzer PasswordManger??
Hallo, we have installed 5 Installations of NFA5.5. - is it possible to manage the accounts of the NetflowAnalyzer with the PMP? - is it possible to authenticate the user in PMP with Radius? Thanks Tom
Next Page