Migrate query mysql to Postgres...
I had a query in Mysql. select resource.name, hw_name, component_desc, count(resource.name), invprocessor.clock_speed from invcomponenttype,invhw,invhwcomponent,invcomponent, resource, invprocessor where invcomponenttype.component_type = invhw.component_type AND invcomponenttype.component_label='Processor' AND invhwcomponent.HW_ID = invhw.HW_ID AND invcomponent.component_id = invhwcomponent.component_id AND invcomponent.Computer_id = resource.resource_id AND invprocessor.component_id
ServiceDesk Plus - Generate a report on Parent Request and its linked requests
select wo.WORKORDERID "Parent request ID",wol.WORKORDERID "Linked Request ID" from WorkOrder as wo left join WorkOrderStates as wol on wol.LINKEDWORKORDERID=wo.WORKORDERID where wol.LINKEDWORKORDERID!=0 order by 1 Use the above query to generate a quick report on the parent request id and the linked request ids.
HeartBeat not reachable !!
Administrators would agree that Network Monitoring tools are living embodiment of “Heart” in a Service Provider ecosystem. This bionic heart monitors & manages servers, applications of customer networks in an uninterrupted manner and floats their boat. Thought I'd share an instance where more than one heart skipped a beat :) OpManager is an application that has been trusted by thousands of Service Providers for more than a decade. In my recent consultation programs, I happened to engage closely
Mmonitor "Mail Server Cluster" and "File Share Quorum Witness" Services?
Does OPmanager monitor "Mail Server Cluster" and "File Share Quorum Witness" Services? Thanks
Troubleshooting Application Performance Issues by Monitoring Datastore Latency
Every time the end users complain about the performance of an application installed on a VM, it becomes difficult for the VMware administrators to troubleshoot the problem. Today we will look at; datastore latency (read & write), one of the key metrics for monitoring application performance. Datastore read latency is the average time taken for a read operation from the datastore. Similarly, the datastore write latency is the average time taken for a write operation to the datastore So when the time
Looking Beyond the Obvious - Troubleshooting RPC Errors
Thought I'd share an interesting issue faced during the days when I was handling product support. The client I was attending to reported that the monitoring tool was generating RPC errors for most of the monitored servers. This was the error message he received: Error # The RPC server is unavailable. The interesting fact was that the alerts were raised only at a particular time of the day , between 3:00 AM to 3:30 AM. Things would come back to normal after 3:30AM. Here are the typical
Monitoring Intelligence using Anomaly Detection
Most of the clients I have consulted with, take a traditional approach towards performance monitoring. They are focused towards threshold based alerting mechanism and fail to improve their service. The problem with this method is its reactive approach. Your IT gets involved only when there is a failure or when the system reaches a critical state. This often results in a gradual degradation of resource performance. For example, the response time takes a hit when the load of the server increases
How good is your threshold?
One standard question that I get asked whenever I'm consulting with a client is about the recommended thresholds for the monitored resources. Most, if not all, users are concerned with setting optimal thresholds for monitoring server, network, and application performance. When I draw a blank, I'm looked at like an alien. Either I'd come across as a thorough dud who doesn't know his stuff, or a total rookie. However, the truth is that there is no universal standard threshold for most monitored
Like a hamster on a wheel !!
One of the frequently asked reports during my ServiceDesk Plus onsite training & consultation visits is the report showing the time spent by the servicedesk team in handling requests ( Incident / Service Requests ). Every IT director and Service Desk Manager would love to see this report to assess the current state of affairs of the team and to plan the workload accordingly. During my discussions with the IT ServiceDesk team(Technicians), I find that they are putting forward their best effort
Microsoft .NET Monitoring
Microsoft .NET Framework needs no introduction. It has stood stead fast and strong against time and competition. This blog does not intend to showcase the features of MS .NET, but will highlight how easy it is to get MS .NET monitored using ManageEngine Applications Manager. Applications Manager uses WMI protocol to monitor Microsoft .NET Framework. Enabling WMI on a Windows Server is quite an easy task and the instructions outlined in the forum post @ https://forums.manageengine.com/topic/win9x-inventory#
What affects the health of a system?
Quite often, administrators end up monitoring one or more attributes (or event logs) that may not be of importance than the standard performance attributes like CPU, Memory, Disk. These less-important attributes are required to be monitored but should not be propagated to the system health status. ManageEngine Applications Manager comes handy in such a scenario. You can configure the attributes that may affect the Health of a system - it could be a server, an application, a network device,
Thank heavens my boss hadn't noticed what I did...
Have you ever accidentally caused an IT wreck but managed to sort it before your boss notic ed ? Now's the time to tell us about it! Share your unforgettable story with the PitStop community, and you might just win a $25 gift voucher. What counts as an “accidental IT wreck”? Things like... Overlooking a high-priority service request from one of your C-level end users Bringing down your ecommerce site while trying to retire an old fax server Locking users out of the network when reconfiguring
Mysql to postgresql query conversion
Hi, Whether your tool support MySql to postgresql query conversion? In your trail version I didn't find any option to change current query.
DNS Search Order
Can we modify DNS search order on Mac or PCs using Desktop Central?
Trial User.. no flows showing up
We are trialing the ManageEngine product with the intent to purchase if all goes well. I have set up cflowd on our POC router (set it up as version 9). I can see the router is sending flow data, and I can do a packet capture on the Manage Engine server to verify that the cflowd packets are making it to the server, however, I don't see any data in manage engine. When I do my packet capture, I am seeing ICMP Destination Unreachable (code 3, port unreachable) being sent back to my router. I talked with
Remove Category: Description: fields
Hi, how delete Category, Description field from email , when replying the requests ?
Issue with closure report after upgrade to version 8.3
After MSP upgrade, database changed from MySql to PostgreSQL and now the below query is giving errors. Please help. SELECT sdo.NAME "Site",qd.QUEUENAME "Group",cd.CATEGORYNAME "Category",wo.WORKORDERID "Request ID",wof.UDF_CHAR1 "Type",ti.FIRST_NAME "Technician",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.COMPLETEDTIME) "Completed Time",wo.TITLE "Subject",UNIX_TIMESTAMP(DATE_FORMAT(FROM_UNIXTIME(wo.COMPLETEDTIME/1000) ,'%Y-%m-%d %H:%i:%s')) - UNIX_TIMESTAMP( DATE_FORMAT(FROM_UNIXTIME(wo.CREATEDTIME/1000)
Multiple connections to a server or shared resource by the same user, using more than one user name, are not allowed.
Multiple connections to a server or shared resource by the same user, using more than one user name, are not allowed. Disconnect all previous connections to the server or shared resource and try again.
Export Software List View
I would like to export the Software > Scanned Software list view. Is there any way to do this?
generate a new report of Survey detail and result
Kindly, i need a query to generate a new report of Survey detail and result as following... Request ID||Request Title||Requester||Technician||Survey||Created Time||Rating Value Grouped by Category with providing the surveys count and average for each category and for all the report. thanks.
Create report with Last Update time
Hello, I am trying to run this report however I get the error "only select statements can be used". Can you please help? SELECT ti.FIRST_NAME "Technician",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",cd.CATEGORYNAME "Category",ti.FIRST_NAME "Technician",sdo.NAME "Site",longtodate(wos.LAST_TECH_UPDATE) "Last Update Time" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID
how to insert my sms server
I have my own sms server that i want to insert into manage engine but i see i can insert only GSMMODE and SMSCLICK where can i insert my own sms server??
Device Backup
Hi There. We have some cisco devices that are integrated with tacas+. When we run the backup, or any other command, the first try always fail (and goes to local authentication) and the second time always succeed. Is there any parameter that can be changed, so the telnet to the device does a retry, on failure? Thanks for your reply
Uninstall AD SelfServicePlus clients and reinstall ADSSP bulk clients
Dear Support I required to uninstall SelfServiceDesk Client from bulk computers and reinstall the client again of all of the computer could you please share the procedure I am using version-5.0 AD SelfServicePlus is this possible to uninstall client from web-console waiting for your response Thanks & Regards, Shujjat Shah
FW Analyzer attack Firewall
I have a problem FW Analyzer permanent host sends an ICMP packet but the firewall, firewall and he takes it as an attack. How can this be avoided? Reduce the number of calls to the firewall via icmp On a host other than fwanalyzer nothing is not installed Unknown (FWanalyser host) 28 Nov 2014, 16:45:09 warning %ASA-4-400011: IDS:2001 ICMP unreachable from (FWanalyser host) to (Firewall host) on interface dmz ICMP unreachable (Firewall host) Warning 3518034 2001 deny
Job Sheet e-Mail
Hi All, Job sheet feature is very good. I ve customized Job sheet Customer succesfully . But i want to send Job Sheet Page to my related customer. How can i do? i coudnt find it. And can we send use Notification Rules. for example. When the CLOSED to a request, then sending JOB SHEET email to related customer automatically .
Replacing an Existing Distribution Server
Hello, We currently have a distribution server setup at one of our remote offices but we have found that there's an issue with this server and it will need to be replaced. We are planning to setup a new server at this office with the same name and IP address but I wanted to find out if there are any additional steps I would need to take to move the desktop central distribution server on to the new machine or if it's just a case of reinstalling the distribution server software? Is anyone able to advise
how to add filter viewing like 'barcode' on asset
I wanna add 'barcode' word on filter viewing workstation asset. How to add this item on filter viewing workstation asset. Here's the screenshoot what i want. Please help me. Regards, Adnan
Know when your technicians login and logout of the ServiceDesk Plus portal
select aal.NAME "Last logged User" ,MAX(aas.USER_HOST) "IP Address",LONGTODATE(MAX(aas.OPENTIME)) "last login time", longtodate(max(aas.closetime)) "Last Logout Time" from AaaAccSession aas LEFT JOIN AaaAccount aacc on aacc.ACCOUNT_ID=aas.ACCOUNT_ID LEFT JOIN AaaLogin aal on aal.LOGIN_ID=aacc.LOGIN_ID GROUP BY aal.NAME You can execute this SQL query through Reports -> New Query Report in the ServiceDesk Plus portal or use SQL Query Analyzer against the ServiceDesk Plus database.
Is your website available?
With as many as 20+ IT management products to be featured, it is not that easy to ensure that the demo site is up and running for each of these products in addition to the 15-odd free ManageEngine tools on individual physical servers hosting the demo instances. Will make a separate post to tell you how these are being hosted at our demo sites. Being a part of the team that is responsible for ensuring the demos are always up and rolling up the sleeves to schedule and do the actual demo, it is
Applications Manager - Disk Drives without Thresholds and Actions
Run this query in SQL Query Analyzer against the Applications Manager Database. select RESOURCEID, RESOURCENAME, TYPE from am_managedobject where resourceid not in (select id from am_attributeactionmapper) and resourceid not in (select ID from am_attributethresholdmapper) and TYPE in ('Disk') This query will give you a report on the Hard disk drives for which the thresholds and actions have not been configured.
Applications Manager - Pull an inventory of servers, ipaddress and device type
select AM_ManagedObject.DISPLAYNAME,AM_ManagedObject.TYPE,CollectData.TARGETADDRESS from AM_ManagedObject,AM_ManagedResourceType,CollectData where AM_ManagedObject.TYPE=AM_ManagedResourceType.RESOURCETYPE and AM_ManagedResourceType.RESOURCETYPE not in ('Node','Network') and CollectData.resourcename=AM_ManagedObject.resourcename order by AM_ManagedObject.DISPLAYNAME Use the above query in SQL Query Analyzer to pull out an inventory report of servers along with their ipaddress
A Simple Complex Scenario !!
Thought I'll share a simple, yet complex scenario my colleague and I faced recently when troubleshooting an 'SNMP Failed' issue in OpManager . Scenario : OpManager could not monitor the performance metrics of a Juniper Netscreen SSG Firewall because SNMP authentication was failing. Severity : A prospect from UK was evaluating SDP and OpManager and was happy with both the applications. He needed the above scenario in OpManager to be addressed to purchase the application. To troubleshoot this
An hour behind in summer and a leap forward
With less than a week for the US day light savings to end, thought why not share an incident related to this when I was a Technical Support Engineer. The 'Day Light Saving' dates back to 1967 and was regularized across the states in the US, barring a couple of states. I am not going to deal with this history for sure, but, a decade ago, it played a kind of spoilsport to the twin celebrations in the office. After a good stint as a sysadmin, technical support was a relatively newer role for me.
How to have your cake and eat it too!
ManageEngine ServiceDesk Plus was the new kid on the block and gaining popularity as a promising IT helpdesk tool. My colleague and I had to travel to Jamaica for an implementation and training for a large SDP deployment. That was our first largest implementation in 2007 since its first release in 2005. SDP had a solid Incident Management and Asset Management module and all the ITIL -ready features were added in phases only in the subsequent releases. The product was an instant hit at
Who deleted what and when in ServiceDesk Plus Request Module?
select el.message "Message", au.first_name "Deleted by", longtodate(el.occurredtime) "Deleted AT" from errorlog el left join aaauser au on el.ownerid=au.user_id where (el.errormodule like 'request') and (el.action like 'delete') Use the above SQL query to find out who deleted what and when from the Request Module in ServiceDesk Plus.
The Kingdom & its Keys !!
" In a world of locked rooms,the man with the key is KING, And honey,you should see me in a crown" Remember this popular quote from Sherlock BBC series when Jim Moriarty confronts Sherlock Holmes ? That’s exactly the scenario in the cyberspace today. In the digital world, keys are the privileged accounts like Domain admin, service accounts, login accounts of the linux,unix servers, network equipment et al . These accounts in the wrong hands could wreck havoc. Password Manager Pro from ManageEngine
Curious Case of Albert and an IP Address
Albert was taken over by panic when he called us. Panic is an understatement, as I could hear his heart thudding over the phone. He had an urgent need to find all the conversations for a specific IP address through his Firewall. He required this conversation detail as a report for the previous week. Albert was a newly hired firewall guy responsible for his network integrity and compliance. The company Albert works for is one of ManageEngine's premium customers who had deployed ManageEngine
Enabling SNMP: Not a T-Rex age task anymore!
A decade ago, when today’s major players were competing hard to establish as the lead player in the IT Network/Server Monitoring sector, ManageEngine released its flagship product – OpManager – with a powerful web and java client. I can’t erase those days off my memory when we were running pillar to post within the office space to configure SNMP on servers and workstations to check if OpManager can pull all the essential performance monitors. Configuring SNMP on Windows machines was never
Don't fret if your graphs turn out empty. Not when you have MIB Browser!
Close to thirty percent of our support tickets are related to ManageEngine monitoring applications not pulling statistics from network devices or servers. That is where MIB Browser comes in handy. It is a tool that performs SNMP operation to GET or SET values on network devices and servers. I prefer calling it a troubleshooting tool as it helped me solve many trouble tickets. A little bit on SNMP before I get to some of the ‘how –to’ of this tool. Many network devices and servers support SNMP (Simple