Archived community.zenoss.org | full text search
Skip navigation
1 2 Previous Next 3243 Views 17 Replies Latest reply: Aug 7, 2012 10:41 AM by jdd0x01 RSS
mikeC79 Rank: White Belt 42 posts since
Jun 25, 2012
Currently Being Moderated

Aug 6, 2012 11:13 AM

Where did my history go?

I am running Zenoss core 3.2.1, and if I look at my event history, it only shows events as far back as 24 hours. I have the "first seen" date set to 1 week ago, and "Delete Historical Events Older Than (days)" is set to "0".

 

Am I missing something?

  • jdd0x01 Rank: White Belt 26 posts since
    Jul 3, 2012
    Currently Being Moderated
    1. Aug 6, 2012 4:23 PM (in response to mikeC79)
    Re: Where did my history go?

    Have alerts actually occurred for there to be a history for that particular device? Have you verified that all the severities for the events are checked for the machine's events in the viewer?

     

    For what its worth, I have also noticied inconsistencies within the interface for viewing events as well. I have not tried to narrow down where in the code it is possibly wrong, however.

  • jdd0x01 Rank: White Belt 26 posts since
    Jul 3, 2012
    Currently Being Moderated
    3. Aug 6, 2012 4:49 PM (in response to mikeC79)
    Re: Where did my history go?

    Do you see those criticals in the events.history table in the Zenoss MySQL DB?

  • jdd0x01 Rank: White Belt 26 posts since
    Jul 3, 2012
    Currently Being Moderated
    5. Aug 6, 2012 5:24 PM (in response to mikeC79)
    Re: Where did my history go?

    You would log into the shell via SSH where Zenoss is running. From there, as the zenoss user, run mysql -uroot -p and put in your MySQL root password (you should have this from when you installed and setup the server). Once in you can do a show databases; command to see what databases are listed. By default, Zenoss uses the events database. After that, type use events; Running show tables should get you a listing of the tables, look for the history table and type this: select * from history where device = 'device' and firstTime > '2012-08-05' order by lastTime\G;

     

    Here are the commands step by step:

    • Login to Zenoss server as zenoss user
    • mysql -uroot -p - put in your MySQL password
    • show databases;
    • use events; <- if your default Zenoss DB is events
    • show tables;
    • select * from history where device = 'device' and firstTime > '2012-08-04' order by lastTime\G;

     

    The last command should print out some lines showing you events that occurred on or after 8/4 through today for that specific device...

     

    BTW, there may be several meta-events about state change or various internal changes, they can be ignored and don't show up in the events for the device itself within Zenoss' UI.

  • jdd0x01 Rank: White Belt 26 posts since
    Jul 3, 2012
    Currently Being Moderated
    7. Aug 6, 2012 5:48 PM (in response to mikeC79)
    Re: Where did my history go?

    No problem

     

    Ah, this sounds like they were deleted. Did you acknowledge the events or delete them?

  • jdd0x01 Rank: White Belt 26 posts since
    Jul 3, 2012
    Currently Being Moderated
    9. Aug 6, 2012 5:55 PM (in response to mikeC79)
    Re: Where did my history go?

    Sounds good, sorry I couldnt be of more assistance. Once I get time I plan to research the loss of events because I have noticed it as well on certain events/devices - almost certain there is a bug in there somewhere.

  • jmp242 ZenossMaster 4,060 posts since
    Mar 7, 2007
    Currently Being Moderated
    10. Aug 7, 2012 7:56 AM (in response to jdd0x01)
    Re: Where did my history go?

    Events are supposed to be cleaned up if you enable that, but by "older than x days" sort of setting. I don't delete events myself. Maybe a starting point to look for bugs?

     

    --

    James Pulver

    ZCA Member

    LEPP Computer Group

    Cornell University

  • dpetzel Rank: Brown Belt 1,141 posts since
    Oct 17, 2010
    Currently Being Moderated
    12. Aug 7, 2012 9:43 AM (in response to mikeC79)
    Re: Where did my history go?

    Events --> Event Manager --> Delete Historical Events Older Than (days)

     

    Setting to 0 should prevent items from being deleted

1 2 Previous Next

More Like This

  • Retrieving data ...

Legend

  • Correct Answers - 4 points
  • Helpful Answers - 2 points