All the supported Sql views are listed here. https://learn.microsoft.com/en-us/mem/configmgr/develop/core/understand/sqlviews/sql-server-views-configuration-manager
There are no tricks to this use any of the views listed to create your report.
I want to create PowerBi patch compliance report but the issue is my SQL does not give desired results as SQL views are not getting correct data.
What all other ways can I create the PBI report in sccm?