Hi, there are two ways to intergrate SCCM output in qradar. The traditional way is SCCM scanner to be integrated using VIS. Results will be mapped into asset db. The way you described is connecting to the SCCM db using JDBC. Pls use SCCM standard queries to achieve this rather than your own views. However if you seriously need to create your own view pls check MS Technet BR Karl
https://social.technet.microsoft.com/Forums/en-US/5d87b8ab-8451-4f3e-ac48-cbd752bb6d37/create-custom-database-view-in-sccm?forum=configmanagergeneral
#QRadar#Support#SupportMigration