Report to get the list of Category, Subcategory and Item.
Use the query to list of Category, Subcategory and Item. MYSQL database: select cat.categoryname "Category", sub.name "Subcategory", GROUP_CONCAT(item.name separator '\n') "Item" from categorydefinition cat left join subcategorydefinition sub on cat.categoryid=sub.categoryid left join itemdefinition item on sub.subcategoryid=item.subcategoryid group by cat.categoryname, sub.name MSSQL database: SELECT cat.CategoryName "Category" , sub.NAME "Subcategory",(SELECT STUFF((SELECT NAME + CHAR(10) FROM
Scaned Serial Number moved to service tag
Hi Team, Does any one have the same problem, we scan the desktops with SDP agent installed but the serial number picked up by agent is showing in service tag in assets.and keeps serial number field blank. We requires the serial number captured to be placed in serial number field only.
Open new request and pre-fill the technician opening the request.
When opening a new request in SDP, is there a way that the person logging the request will automatically be selected as the Technician?
Cannot upgrade to any version past 8201
Hello, Recently, I upgraded SDP to version 8201. Now I am unable to upgrade to any later version. I have tried Versons 8203,8205 and 8206. Every time the upgrade fails the only error message that appears on the Java client is "Sorry, Uninstallation is currently not supported" Any ideas how I can resolve this?
Multiple Contract's for different time entry types
Hi, We are running into a similar problem all of the time with our contracts. We sell a telephone and email support contract, with limits on either number of incidents or time-period. (e.g, level 2 support is unlimited incidents within office hours (8am/6pm)). However this level of support contract only covers email and phone calls. If customer wants a Webex, or for us to work remotely, they have to purchase hourly based units (1 unit = 1 hour). So, when someone buys a level 2 contact, plus 10 hours,
SiteAdmin cannot edit technician on the same site
Using Servicedesk Plus Build 8204. Site admins cannot edit the technician for updates. Please see image: Please advise
switchport manager
Hello，everybody！I have a requirement about swithcport manager to ask for you.Can switchport manager support Cisco Nexus 7000 and which version does it support ? thank you !
Problem with upgrade DeviceExpert
Hello! I try to upgrade my DeviceExpert from 5650 to 5700 and have an error message: Unable to load Disk Space related native library. Exception in thread "Thread-2" java.lang.UnsatisfiedLinkError: getFreeSpace at com.adventnet.tools.update.installer.DiskSpace.getFreeSpace(Native Method) at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:152) at java.lang.Thread.run(Unknown Source)
Column Chooser
Hi Guys, I hope you can add aditional column like "Custom Field" such as "Location", "Remarks" in the Column Chooser. That would be great especialy when you have many custom fields. Thanks.
Can't interact with DE via REST API
Hello guys! Would you be so kind as to help me with my problem? I try to interact with Device Expert via API from python script. I sent a POST request to URL like this <Protocol- http or https >://<DeviceExpert-Server-Name>:port/api with following parameters: ACTION = "GET_DEVICE", API_KEY='xxx', IPADDRESS='X.X.X.X', but I have received an empty string. import urllib, urllib2 url = 'https://x.x.x.x/api' req = urllib2.Request(url) values = {'API_KEY':'xxxxxxxxxxx', 'IPADDRESS':'x.x.x.x', 'ACTION':'GET_DEVICE'}
Notification Issues in Trial Version
Not receiving notification email from Manage Engine.
Unable to import active directory users with Firefox
Hi There, Recently upgraded our SDP software to 8.2.0 Build 8204, but have since discovered that I'm unable to perform an Active Directory user import when using Firefox (v21.0) as my browser. Capture.PNG is what I'm seeing in Firefox, Capture_IE.PNG is what I can see in Internet Explorer (domain and OU names removed). I did need to flush my cache for some things to display correctly post-upgrade, however refreshing with CTRL+F5 on this page has no effect. I can workaround the issue at the moment
IPhone Application issue
HI, I have been trying to get the IPhone SD application to work with our SD-MSP system. The application is able to connect to our system but when I try to view requests etc it comes up with the following error "Error when adding request details - null" Any suggestion welcome. Regards Tony
MSSQL DB backend, MESD transaction log fills HDD
Over the last few weeks we have noticed strange behavior with the transaction logs for MESD. We are using MSSQL 2008 for the DB backend. This was originally configured back in November, and has been working fine until recently. Not sure what changed, but it is now to the point where we need to truncate the log file a few time a day. We've seen the transaction log file reach 65GB on a slow day, which makes no sense. When this happens, the service desk all but dies - it loads up fine but no one can
Installed software on workstations report
We are looking for a custom report that we can query for a specific software package or part of a software name (wildcard). The report needs to be grouped by the software title, and list the workstations and the assigned users underneath that. We are running MSSQL on 7.506. I have tried some of the queries on this board, but nothing returned the desired results. Thanks.
jResource check failed for service jboss.web:service=WebServer. Port already in use:8080
How can I change the port on 9.6 build?
password expiry notification email
Can the format example be removed from the password expiry notification email? Your password will expire on 05/05/2013 07:56 AM(MM/dd/yyyy hh:mm a).
Netflow Bandwidth Usage Incorrect
Hello, We are in the process of trying to configure opmanager for use in our enterprise however it has come to my attention that the bandwidth usage showing up in the netflow system is wrong. Over the last while we have had some very large 4.29GB sessions recorded for protocols and links that could not possibly be using that much data. I took it upon myself to run some sample transfers through the ASA 5510 reporting at the moment. An exact 500MB rar file being sent outside via ftp to a public web
Unable to update from 9600 to 9700 (Netflow Server is currently running)
Hello, I've been attempting to update from build 9600 to 9700 of Netflow Analyzer but have run into the following problem. When I attempt to run UpdateManager.bat I receive the error message below: Exception in thread "main" java.lang.NoClassDefFoundError: com/adventnet/netflow/dbutils/NFClientUtil "Netflow server is running. Shutdown server before upgrading" I made sure to stop the service but still receive the error. So I then attempted to run shutdown.bat and received the following error:
Changing Availability Treshold
Hello, Is there any feature to change the threshold value for availability dial in OPM v8? Let say I would like to custom for routers & switches to have this threshold: GREEN = >80% YELLOW = >70% and <80% RED = <70% Regards, MNO
Requested Doesn't Get Email
Hi, If I log a call onto the system manually via a new request form, I assign the requester on the form and then technician. The technician gets an email, but the requester doesnt Why is this?
How to search Event logs using basic command Logon type =3 BUT no username
Hello, Real Quick how to search in the search field using basic commands: logontype =3 but dont want to display Event.log.analyzer username what will be the next sentax.
OpManager and SDP SSL
I currently run both SDP and OpManager on the same server. SDP has an SSL certificate and is running on port 443. I would like to purchase an SSL for OpManager, what would be the best apprroach? Can I bind OpManager to a specific IP address? I also have the netflow add-in. Thanks,
API - Update contact
Hi In the api, I can add contact by using "addContact", and successfully retrieve a contact through "getContact" What I would like to do is "updateContact"? Is it available in the API? Thanks
Server Dial Graph & clicked through "Process diagnostics" are very different
Can you explain why this is the case? In this example the ram is over 93% utilised and has triggered a critical alert but the dial graph still displays 7%?! I have a case open 4589015 Thanks
Distributed edition - FAQs
Here is a set of frequently asked questions about the recently launched Distributed edition of ManageEngine NetFlow Analyzer. 1. Is it fine to run OpManager and NetFlow Analyzer on the same server? To ensure that the performance doesn’t take a hit, we do not recommend running both OpManager and NetFlow Analyzer on the server. We recommend using dedicated servers for OpManager and NetFlow Analyzer Distributed edition in order to achieve maximum performance. 2. What are the flow formats supported
ae_scan.vbs fails with SSL
I had installed Demo SDP and scanned another computer with ae_scan.vbs. It worked fine and computer appeared in Assets. Later I configured SDP over SSL. It works fine but when I execute ae_scan.vbs, it gives error: ---------------------------------------------------------------------------------------------- Exception occured while running the Script. (ManageEngine AssetExplorer) Error Code : 0x800C0008 Error Desc : System error: -2146697208. For resolution please report the above Error Message
ae_scan.vbs fails if SDP runs on SSL
I had configured Demo SDP and executed ae_scan.vbs on another computer. It worked fine and the scanned computer showed in Assets. Later I configured SDP on SSL configured with cerficate issued from W2K3 CA. It works fine but when I exucute ae_scan.vbs, it gives error: --------------------------------------------------------------------------------------------------------------------------------- Exception occured while running the Script. (ManageEngine AssetExplorer) Error Code : 0x800C0008
Gina not working outside of company network
I have been testing Gina to see how it will work when not on our network. I installed Gina on a test laptop and when it asked for server I entered the xxxxxxx.xxxxxx.ca as it is setup for SSL connection and then when is asked for port I entered 9251. Everything worked in the office when on net but when I test it outside the office network. ie at home, the only thing that comes up is a white box. Is this not intended to work when not connected to our office network?
Problems after 8.2 update
We have finally updated to the 8.2 version because we had a need to use Project Management. The result is now a non-functioning Service Desk app. Thus far, we have uncovered the following problems since running the update to 8.2... The Home tab displays a mostly blank page. Only the Quick Create displays, the rest is blank. For some users, the dashboard tab indicates that a plugin is required. Did not have that before. Recieve an HTTP 500 error when I attempt to open a incident or request that
Cant' Display Data Collect from Cisco ASA5505
Hello, I have one issue with NetFlow. I'm Trying to collecte data from a cisco asa5505, but i can't display alert and information collect on by NetFlow. I mean by this,source ip, destination ip, applications details and so on. Kindly check the pictures bellow.
Opmanager as a Linux service
Hi, is it possible to start opmanager as a service under Linux OS (e.g.: using /etc/init.d/xxx start - stop - status)? I need a useful function to start Opmanager at boot time... Thank you in advance
REST API and User defined attribute
I am using the REST API to create requests. Data is sent via the INPUT_DATA xml attribute. Everything works fine. I would like to add a user defined attribute to the xml structure but the problem is the syntax of this attribute : "N° de Client" <Operation> <Details> <subject>Specify Subject</subject> <N° de Client>N9812</N° de Client> </Details> </Operation> The above xml structure is incorrect (spaces and special char), is there any solution without modifying the user defined attribute's
Can I install Java Runtime Environment (JRE) 1.6 on opmanager server?
Dear Support, My opmanager server's ServerView RAID Manager required me to install Java Runtime Environment (JRE) 1.6 on the server. After configuration of the opmanager, can I install Java Runtime Environment (JRE) 1.6? will it cause any problem with the build in java in opmanager software? Regards, Robert
[ask]OpManager template for BlueCoat PacketShaper
dear OpManager team, do you have template for BlueCoat PacketShaper (3500, 7500, etc)? all i can found at OpManager is only template for BlueCoat ProxySG and i couldn't find any on BlueCoat PacketShaper template. i want to monitor traffic for each configured class at the PacketShaper. thanks..
montoring IP SLA
Hi, I am running IP SLA on the cisco routers to monitor the availability of the links. Is it possible to configure Opmanager to monitor those IP SLA monitors and report that the link is down if the monitor returns down. We are doing this on whatsup but cannot seem to be able to do it on Opmanager thanks Ramzi .
Can not restore Opmanager 10100
Hello I seem to be having issues restoring OpManager 10100. My Database is MSSQL 2008 R2 SP2. I'm trying to migrate my data to a new server. I have never had problems with this in the past. On my current OpManager server I am using the data base maintenance tool. I select All Data and Backup Mode is MSSQL to MySQL. When I try to restore the data using the same tool I get the following error. "This backup will be restore only in MySQL db server." I also tested and cant restore my current
Device already present in the System
I have some problems with adding a vmhost after I deleted it. I get the message: "Device already present in the System", but when I search for it as a host or ip I get no results. The reason I deleted the vmhost was that it could not figure out how to display the current VMs after some of them have migrated to another host. I am running MS HyperV cluster with four nodes. I am running OpManager 10100
Monitor a website with 403 - Forbidden: Access is denied.
Hi, Can Opmanager monitor a website (specifically ping) that states "403 - Forbidden: Access is denied."? Basically I have a web site that some users are reporting to be slow during various times of the day and I wanted to monitor it with opmanager (ping and response times) but due to the configuration Opmanager wont be able to open the site only get the above message. Thanks
Overview Columns
I'd like to edit my overview to include 2 columns, but am unable to do so. I can select the number of columns, but I can't edit the column widths. If click Save, I get prompted that I need to change the column widths: Anyone seen this before. Only happens on the Overview screen.
Next Page