Search results for query: *

Thanks Jpadie. The first script works when SEVERITY = 5 and the result is available to a output text file. The second script does not work when I have a mixture of severity 5 and 4. The result is not available to a output text file. There are no error messages. Just at the left side bottom of...

I'm running SNMP Zenoss connected to mysql database.I'm using a PHP script to select the device that fails the most based on the severity level 5 and 4 for a particular year and month. The script works when I select severity = 5 but does not work when i have a mixture of 5 and 4. Severity 5 is...

Thanks Markros. That worked except i had to remove one statement "ORDER BY number_of_events DESC LIMIT 10" SELECT device, count(*) AS number_of_events from history where severity = 5 GROUP BY Device //ORDER BY number_of_events DESC LIMIT 10 UNION ALL SELECT device, count(*) AS number_of_events...

Thanks. That did not work. Your query gives me the top 10 based on severity 4 for some reason. I am not looking for the top 10 of each. I need a mixturre of 4 and 5. Thanks again.

I'm running SNMP Zenoss connected to mysql database.I'm trying to select the device that fails the most based on the sevrity level 5 and 4. Severity 5 is highest and 1 is the lowest. Table name is history. -Column name called "devices" has all the device names. -Column name called "events" has...

I like you thank everybody for all the help. You guys rock!!

I'm running SNMP Zenoss connected to mysql database.I'm trying to select the device that fails the most from the database. Column name called "devices" has all the device names. Column name called "events" has all the events that are generated. How can i write a query that will display the...

Please Help and Thanks in advance.

I had submitted this before: I'm running SNMP Zenoss connected to mysql database.I'm trying to select the device that fails the most from the database. Column name called "devices" has all the device names. Column name called "events" has all the events that are generated. How can i write a...

Thanks Peter - It works. One more thing is I need to display the result between the 1st of the month - 30th of the month and year should be 2010. Thanks

I'm running SNMP Zenoss connected to mysql database.I'm trying to select the device that fails the most from the database. Column name called "devices" has all the device names. Column name called "events" has all the events that are generated. How can i write a query that will display the...

Thanks for the feedback.

I'm running SNMP Zenoss connected to mysql. I'm trying to select the device that fails the most from the database. How do I do that? Please help. Thanks in advance