Action History PowerBI Dashboard in BigFix Insights

BigFix Performance vs. Historical Data: You No Longer Have to Choose

One of the best features of BigFix is the granular detail it captures. We rely on it to know exactly when an action ran, who targeted it, and the specific result on every endpoint.

However, there is a common trade-off. To keep the BigFix Console responsive and the platform database lean, administrators have to run the Audit Trail Cleaner. This inevitably deletes the very history we need for long-term compliance reporting. Many teams find themselves hesitating to clean the database because they don't want to lose that visibility.

BigFix Insights changes that math.

By offloading action data into BigFix Insights, you create a permanent historical record that exists independently of the platform database. You can keep years of deployment history without impacting the responsiveness of the console for your day-to-day operators.

I have written an article that provides a step-by-step guide on how to build a Power BI dashboard against this data. The report is designed to replicate the "Action History" view you are used to seeing in the console, but with the persistence of a data warehouse.

Now, you can aggressively clean your console history to maintain peak performance, knowing your reporting data is safe and accessible in Power BI for whenever the auditors come knocking.

1 Like