BES_RELEVANT_FIXLET_HISTORY

This view contains an entry for every Fixlet/computer pair that has ever been relevant, with timestamps indicating the first time it became relevant, the last time it became relevant (the same as FirstBecameRelevant if it became relevant only once), and the last time it became non-relevant. Some of these fields might be NULL if the event in question never occurred. This view includes custom Fixlet content.

Column	Type	Description
Sitename	varchar(128)	Fixlet site name
ID	int	Fixlet ID
ComputerID	int	Computer ID
FirstBecameRelevant	datetime	Time at which Fixlet first became relevant
LastBecameRelevant	datetime	Time at which Fixlet last became relevant
LastBecameNonRelevant	datetime	Time at which Fixlet last became non-relevant
Version	int	Fixlet version