SCCM SQL Views Types
Hi Folks, This time We'll talk about SCCM SQL Views. What is SCCM SQL Views? SCCM SQL Views is part of SCCM SQL Database and contain information about all SCCM components like Resources, Collections, Updates, All Packages ...everything...... Hence provide option to fetch custom data or create custom reports. Following are types of SCCM SQL Views and contains information in categories..... V_* : default view V_R_ * : It will fill the values with Discovery data V_RA_ * : It will, fill the values Once Discovered and Assigned V_GS_* : HINV/SINV/Software Granular data- Present/Current inv data V_HS_* : Historical data after 90 days - Task maintenance data HINV/SINV/Software V_AI_* : Asset Intelligence rela...