BigFix Insights Testing

I’m trying to test BigFix Insights in our lab which is running BigFix v10 and MSSQL 2016. I see in the Insights documentation that it says MSSQL2017 is required (which is very specific and it would be nice if that was open to other versions). But just testing, I went into v10 WebUI > Settings > Insights and tried to create an instance and I get this error:

Error on BigFix Insights connection
Error: Error: Incorrect syntax near 'TEMPORAL_HISTORY_RETENTION'.

Besides redeploying to MSSQL 2017 is there anything that can be done (even if it is unsupported)?

Even trying against a MSSQL 2017 DB gives me this same error message.

Thanks for reporting the error. Could you please open a support ticket so our engineers can investigate it?

case CS0125616 created

Was there any resolution here? Getting same error

I don’t see anything in the case notes and I don’t recall the resolution. You could open a ticket, reference CS0125616 and see if that support engineer still has notes.It was from July 15ish 2020