Add Information to Query Store data

[jagriffin5]

Would like to request a modification to the Query Store data collection that includes the following columns from sys.query_store_plan:
force_failure_count
last_force_failure_reason_desc
plan_forcing_type

These columns are useful in helping to determine possible causes for performance issues that are either due to failures in plan forcing or, if a plan is forced, did it get forced manually or with SQL Server's auto tuning features.

[PiJoCoder]

Thanks @jagriffin5, appreciate the feedback. We'll consider for future build

[PiJoCoder]

This was added in the previous release

SQL_LogScout/SQL LogScout/Bin/SQLScript_QueryStore.psm1

Line 35 in 13b9575

DECLARE @sql5 NVARCHAR(max) = 'SELECT db_id() dbid, db_name() dbname, plan_id, query_id, plan_group_id, engine_version, compatibility_level, query_plan_hash, is_forced_plan, force_failure_count, last_force_failure_reason_desc FROM sys.query_store_plan'

https://github.com/microsoft/SQL_LogScout/releases/tag/v6.24.10.10#:~:text=Query%20Store%20data%20collection%20updated%20to%20help%20determine%20causes%20for%20plan%20forcing%20failures