Thanks for your prompt reply.
In fact, I was confused with
BigFix Insights and
BigFix IVR. Last week I used the Fixlet to deploy BF Insights for IVR thinking that would be the first step.
My purpose is to be able to report on historical data for patching compliance and device inventory.
Because the initial deployment that I attempted last week it wasn’t allow me to setup the DB from the webui interface.
I went ahead and removed IVR, and then reset the DB config for Insights using the following query:
delete from [BFEnterprise].[dbo].[webui_data] where App = 'insights'
I also re-created the BFInsights DB as it contained some tables created by the previous setup.
After that, I ran the setup from WebUI and everything went through without any issues. I am now looking at the BI reports provided by BigFix.
At the moment I am using a replica from my lab server but it doesn’t have too much data. So I have two questions:
- Can I use a replica of my prod BFEnterprise DB as a second data source for this current setup?
- Will I be able to report on data from previous months(Like the total installed/missing patches) once I add the source or is that available once I move forward in time with more ETL runs?