Query last pulled value from all monitors
Hi, Today i notice that some of the monitors are actually not getting any value from server. Since the "Monitor" does not showing the last pulled value like how it showing for MSSQL / Exchange Monitor, it is really troublesome to check one-by-one by clicking "edit" -> "test monitor" So, can someone help me to provide a SQL query that will query the last pulled value (within 24 hours) fro all monitors? -- Regards, Anandharaj System Engineer (Unix / Linux)
A successful report and a failed query.
Team, When I create and run a report it runs fine. When I asked to see the query: SELECT pd.PRIORITYNAME "Priority",wo.WORKORDERID "Request ID",longtodate(wo.CREATEDTIME) "Created Time" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID WHERE (((longtodate(wo.CREATEDTIME) >= datetolong('1288584000000') AND ((longtodate(wo.CREATEDTIME) != 0) AND (longtodate(wo.CREATEDTIME) IS NOT NULL))) AND ((longtodate(wo.CREATEDTIME)
Monitor SAN Switch (Brocade)
Hi, Does anyone manage to configure brocade SAN switch in OpManger? I can see the "brocade" in device temple, but there is no default monitors assigned. I also not sure what are the monitors that supported by Brocade. -- Regards, Anandharaj System Engineer (Unix / Linux)
Netflow Analyzer Pro 8 - Export Application Mappings & Reports
Our company was recently purchased and we are in the process of moving our Netflow Analyzer Pro to a server at the new corporate headquarters. I would like to know if there is a way to export the Application Mappings and Reports to the new server, but nothing else. We will be monitoring new devices and we want to start with fresh data. Can this be done or should I just move the database and then delete all of the devices and start fresh. Please advise. Sincerely, Matthew Linsemier The Doctors
Drill down reports
Hi SD+ Develops, its been a long time since i used to work with SD+, now I'm back to use it again and i can see a lot of changes and great developments since version 5 and 6. I was wondering whether reports can be drilled down. I want a report to find all workstations with any versions of Microsoft Office. Then i want to drill down to different versions. Then i want to drill down to where these versions are installed. Please can somebody reply to me about this?
Upgrading from 7.0 to 8.0
I checked the "About" page and clicked on the "details" link and found that it recommends using the migration sequence if you're below build number 7500. What it not clear is if this applies to 7.0 or 8.0? In other words, I want to make sure I follow the right path for upgrading and I'm currently at 7.0 Build 7018, so do I need to follow the migration sequence process or is that only for 8.0 Build 7500 and above?
AD Manager Plus and Exchange 2010
Does AD Manager support the creation of Exchange 2010 mailboxes?
Add resolution information to "View Requests by Requester" ?
When working on a request and selecting Actions | View Requests by Requester, the listing of requests displays. After selecting a prior request, the request details display with notes, but not the resolution. Is there a way to add the resolution to these details? Currently the description displays, but nothing else.
List of Windows Services by Device
Hi, I want to have a quick overview of the windows services that assigned to all devices. Can some one help me with the query? This report should include any service(s) that is not assigned to any device also. I know there is "windows service monitor availability" report, but i want the report to be based on service. E.g: Service A - Device 1 - Device 2 Service B <empty> Service C - Device 1 -- Regards, Anandharaj System Engineer (Unix / Linux)
Custom Report - POs From The Past Year
Good Morning, I'm looking to create a report based on Purchase Orders that will show purchase orders of any status from the current year (January 1st to current day of the current year) put in by specific users. Here is what I have so far: SELECT pos.STATUSNAME "PO Status",po.POCUSTOMID "PO Number",po.PONAME "PO Name",longtodate(po.DATEORDERED) "Ordered Date",longtodate(po.DATEREQUIRED) "Required Date",poa.FIRST_NAME "Requester",pos.STATUSNAME "PO Status",paao.NAME "Vendor Name",po.TOTALPRICE "Total
Agent Installation Issue
I am trying to install the agent on my computer (Intel i5 with 12Gb ram running Windows 7 Pro 64bit) through the Admin > Scope of Management window. After selecting my computer I clicked on install agent however after 35 minutes it still says "Agent installation has started in 1 computer" with an Agent Status of Yet to Install against my computer name. I suspect something has gone wrong as 35 mins to install on a local network seems to high, can anyone point me to some logs please ? Thanks,
Repository-browser for users
Hi. Just wondering if there is a solution for an user to browse the repository and install software? Without the help from an administrator to deploy the software?
In progress failed.
since the last patch, when I deploy a new distribution, the current status always says In progress ( failed ).
Cannot delete a request with a large amount of conversations
I have a request that I believe is slowing down my system as it has 100+ conversations attached to it. The request continues to gain conversations as they are being attached as returned emails. (technician email changed). I would like to delete this request altogether. I am getting an error that the delete failed. Is there a way to manually delete the request using SQL (MSSQL)? Or, is there a better way that you would recommend deleting the request? Thanks!
change the SNMP public (default) credentials in netflow analyser after initital configuration
Hi ..From where to change the SNMP public (default) credentials in netflow analyser after initital configuration.. Thanks
RPC Server unavailable
Hi! On most of our virtualized (VMWare) Win2008 servers we get the "RPC server unavailable" when trying to set up WMI based monitoring. RPC server is up and running, so is WMI and DCOM on all the servers.... Firewall is disabled on all machines, and the servers are on the same subnet as the OPManager server. I have searched through the KB articles and the forums, but so far no luck in finding anything that might resolve the problem.
Tiral version to Lincence version upgrade
Hi, We are currently using Manage Engine application manager trial version. We will purchase the licence within a few days. We have a few doubts which we need to clarify. 1) Can we re-use the existing monitors Set-up in the Trial version, once we upgrade it to the license version ? 2) Will we be able to open the Manage engine console once the licence expires ? Thanks Anand
Report on Ticket Type
How do i run a report that lists me all the different 'Ticket Types' we have raised? We have Tickets Types such as: Incident, Service Request, Enhancement etc
Do not email on ticket assignment to a support rep, if the support rep is self.
We love the ticket assignment notifications (When a support rep has been assigned a ticket) however its annoying when the e-mail comes in when we assign the ticket to ourselve. Current Operations: Bob "picks up" or assigns a ticket to himself Bob gets an e-mail saying a ticket has been assigned to him. Proposal: Admin enables "Do not email self" Bob "picks up" or assigns a ticket to himself Bob does not get an email. Ashley assigns a ticket to Bob Bob gets an e-mail saying a ticket has been
Embed Weather Map Widget
Finally got this to work, after adding a new widget, custom html US Weather Map <embed src="http://image.weather.com/web/flash/FMMain.swf" width="600" height="400" type="application/x-shockwave-flash" allowScriptAccess="always" allowFullScreen="true"></embed> With internet connectivity, it auto updates every 5 minutes. Here is another one which will focus on your location based on latitude and longitude. <html> <head> <title>Weather</title> </head> <body> <center> <object width="600" height="400">
Configuring Email Notification
I have been trying to configure the notification by email. I am using two separate servers for Netflow and ExchangeServer 5.5. I think I have put in all information for sending email notification but test mail is always failed.
Deleting a user from the aaauser table
Dear All, i was trying to import a new user from active directory, it gives me any error that the user is already existing. when i wrote this query (select * from aaauser) in the database query page, it give me that the user is existing in the table but i can't see him in the users page in the software. can u tell me how to delete a user from the table.???
EventLogAnalyzer on debian 64bit
I am trying about 7-8 hours to make EventLogAnalyzer to start, but i cant, i run debian amd64, when i press the add new host, it gives me blank screen..., also, the ./runSEC.sh needs library file phoenix:~/ManageEngine/EventLog/bin# ./runSEC.sh bin/SysEvtCol: error while loading shared libraries: libz.so.1: cannot open shared object file: No such file or directory when i link the file with phoenix:~/ManageEngine/EventLog# cd lib phoenix:~/ManageEngine/EventLog/lib# ln -s /usr/lib/libz.so.1 libz.so.1
Cisco Temperature Monitor
Hi, I have existing Cisco switch with temperature monitor that working fine. Now, when i add the temperature monitor to the new switch, its not able to get the value. Comparing the OID, seems like there is some differences. Working Temperature Monitor: Graph Name: CiscoTemperature Display Name: Temperature-Chassis Temperature Sensor OID: .1.3.6.1.4.1.9.9.13.1.3.1.3.1 New Temperature Monitor: Graph Name: IronportTemperature Display Name: Temperature OID .1.3.6.1.4.1.15497.1.1.1.9.1.2 -- Regards, Anandharaj
Service Catalogue
Hi, We are deploying Service Desk Plus (SDP) and before we have created our Service Catalogue. With Service Catalogue we want to list to all our services, including incidents verification. The problem is, with Service Catalogue when cannot create an “incident form”, he always create the form/request like a service request. So we cannot evolve from an incident to a problem with the Service Catalogue forms. Thanks in advanced, Best Regards, Henrique Alves.
Import Resource Groups
Hi, I was wondering i there is a way to import a large amount of resources which I know is possible but I would also like them to be imported into specific resource groups without have to set up all the groups initially. Is this possible? Thanks
Resource Group Import
Hi, Is it possible to import the resource group? I was hoping to be able to do this via the department / location fields but it does not appear that I can do this. Thanks in advance
"Old" SLAs to Service Catalog
Hello! Please, explain to me, old SLAs (defined in non-ServiceCatalog module) can be applied to requests, created through Service Catalog templates? Thanks!
Contracts Module - Enhancements & Issues
Dear All, Now that the 7005 is out, we are back on feature enhancements. Previously, based on your suggestions, we improved the reporting module & it has come out well with lot of issues getting fixed. I would like to do the same for the Contracts module. Contracts module, as you all know, is an integral part of any customer support software. We have a couple of suggestions for enhancements of the same. And therefore, I would like to invite suggestions for enhancements to the Contract Module, the
Netflow plug-in SMTP ???
Netflow I have little problem when Netflow plug-in SMTP to send the report but could not find the SMTP settings changed ???
Restoration DB
How to restire DB
URL in password reset email incorrect
I have been setting up SD+ and found that the URL link in the password reset email is incorrect. When it comes through it is formated as http://10.0.1.50:8080/http:/noc3.mydomain.com:8080 instead of the correct http://noc3.mydomain.com:8080 I have reset the URL in the self-service portal setting but everytime I change that field and save it thoughs an error unless I leave it at noc3:8080 This seems like a bug but wanted to see if anyone else has seen this. W2003 8.0.0 Build 8007
REST API Error - GET_REQUEST
I have successfully added requests using the API. Now I'm in the process of retrieving data from the REST interface. I am accessing http://<service desk server>/sdpapi/request/<ticket number> I am sending the following POST attributes: OPERATION_NAME=GET_REQUEST TECHNICIAN_KEY=<valid key here>Here's the output I'm getting: <operation name="GET_REQUEST"> <result> <status>Failed</status> <message>Error when performing required operation.</message> </result> </operation>
Dashboard Errors
Hello, We're running OpManager 8722. If I try to add a widget to the dashboard, I get a completely white page with Error in the upper right hand corner. I tried rebooting the server running OpMgr. After reboot, I noticed if I go to Maps > Servers > List View that page only shows the menu bar at the top, but none of my servers are listed. However if I click the Maps tab all servers appear normally. Please advice. Tom
Unable to remove Groups from Service Desk
Hi We are unable to remove Groups on Service Desk. It comes up with error " Groups cannot be deleted as it is being used by other module " Please help. Thank you Michelle
Cisco Catalyst 3560 PoE-48 Port - PoE Utilization Monitor
Hello, Does OpManager have a monitor to view the PoE Utilization on our Cisco Catalyst 3560 48 Port Switches? Thanks
Does AD Manager Plus 5 support Exchange 2010?
Does admanager plus 5 support exchange 2010?
T1 reported rates are incorrect on WAN interfaces.
I am getting spikes way above 100% utilziation rates. The interface in NetFlow Manager is set to 1536000 bits per second (full T1 speed). The serial interface on the routers are set for frame relay. Bandwidth and the clockrate are set at the frame switch. Is what I am seeing in the reports reliable and correct? It seems not based on the fact that I would think that you can't have utilization rates above 100%. Any help in this matter is greatly appreciteated.
Help with unknown protocal assignment - UDP ports
I am trying to assign traffic types with unknown ports, I can get it to assign the port but I am running into a problem with UDP ports. I have alot of VoIP traffic which of course picks a random UDP port in a range say from port 20000 to 45000. The problem is if I assign it to the SIP group I create any traffic that uses any of that range with be classified as SIP traffic when it is not. Since many applications pick UDP ports at random can you give me any suggestions on the best way to correct this?
Guidance needed
Hi There I am very new to Manage Engine, I am finding a couple of issues which I am sure are easy to correct. The first is changing the column widths within the application, how do I do this so I can see the full name of the software? Secondly, when catergorising, giving an access type or and type if licence, I seem to go through selection of the software, and then one of the sections and then selecting OK when completed. This means for each piece of software listed I have to go through a
Next Page