I am a POC user of BigFix and attempting some SQL patching of 2019 SQL servers. The only available patches I see for SQL are for 2016 and 2022 SQL but nothing for a cluster of 2019 servers. I know there is at least one that would apply: KB5049235 - Cumulative Update 30 for SQL Server 2019. Any advice appreciated.
I haven’t experienced this and we have SQL cluster servers as well.
On a server you expect the patch to be relevant, you can try stepping through each of the relevance using QNA tool or Fixlet Debugger tool to see which one is failing. That should help you as a starting point determine root cause.
You can download Fixlet Debugger into that machine and check each Relevance statement.
I had a case where the SQL Server version reported a specific version (SQL Server Properties) on the machine and a different version on the registry.
On my case, on the Registry it reported older version and on the SQL Server Properties a newer version - and BigFix always tried to Install the “newer version” and failed - because this version was already installed. When a New Fixlet was released - is was successfully installed and updated also the Registry