Need a report that list the Actual Date/Time a fixlet was "installed"

Reporting
1

Is there a way to simply get the Date/Time a fixlet was "installed"
In the report I need, I’m not worried about “Time Remediated” I need the the following in a report that I have to supply in an Excel spreadsheet…

Fixlet Name, Computer Name, Date/Time of Actual Installation

Thank you in advance…
Paul Harrison

2

“installed” is not really a concept that entirely makes sense, it would be more like when was an action run on a system.

If the actions still exist on the root server, you can query them using session relevance, but if not, then you would need to look at querying the actionhistory.db on each client.

Example: https://bigfix.me/relevance/details/3006026

I think the default retention time for actionhistory.db is 1 year, but I recommend setting it to 5 years.

_BESClient_ActionManager_HistoryKeepDays=1825

3

Thank you. The reports I need to run that require this information are usually run within 90 to 120 days from the time of the action. But I will take your advice on increasing the retention time.

4

Since the date should still be on the root server, could you give me a hint on what the session relevance statement should be?