(imported topic written by Marty23)
Is there a length of time that action history on a computer and or a fixlet is kept by Bigfix?
It seems that when I look at the action history of a computer and or a fixlet, I’m missing things.
Marty
(imported comment written by BenKus)
Hey Marty,
The actions will stay there until someone right-clicks and removes the actions (which prevents them from being loaded up in the console, but keeps them in the database).
Ben
(imported comment written by Marty23)
Ben;
if they are still in the datbase, can I get them to reload in the console, or can I at least see them in the web reports?
Marty
(imported comment written by jessewk)
Running the expired computer remover tool will also set the deleted flag to true. Some deployments run this every 1-6 months.
You can use the following SQL queries to find and undelete deleted actions.
To find deleted actions:
select P.Id as ‘ActionID’, P.Name as ‘Action Name’, P.Username, P.CreationTime as 'Last Time Someone Changed Action’
from PROPERTIES P, VERSIONS V, ACTIONS A
where P.contenttype=7 AND P.Id=V.Id AND P.Sitename = V.Sitename AND P.IsFixlet = V.IsFixlet AND P.Version = V.LatestVersion AND A.ActionID = P.Id AND A.IsDeleted = 1
To undelete an action:
exec undelete_action
Note: Replace with the corresponding ID number you want to undelete.
Once you have undeleted the actions you will need to clear the console cache to make sure you see the previously deleted actions.
The following KB article has directions on how to clear the cache.
(imported comment written by carroll91)
Thanks Jesswk! Much appreciated.