SCCM Configmgr SQL views

SQL Query to get all views Select distinct table_name,COLUMN_NAME From Information_Schema.columns Order by table_name Source: https://gallery.technet.microsoft.com/SCCM-Configmgr-2012-R2-SQL-5fefdd3b http://eskonr.com/2013/04/download-sccm-2012-sql-views-documentation/

Advertisements

SCCM Report to get All Site Server & System with there Roles

select distinct sys1.ServerName, sys5.Caption0 as ‘Operating System’, CASE sys4.SystemType0 WHEN ‘x64-based PC’ THEN ‘x64’ WHEN ‘x86-based PC’ THEN ‘x86’ END as ‘Type’, sys2.SiteCode as ‘Site Code’, sys2.SiteName as ‘Site Name’, sys2.ReportingSiteCode as ‘Parent Site Code’, (select CASE sys3.RoleName WHEN ‘SMS Site Server’ THEN NULL WHEN ‘SMS Component Server’ THEN NULL WHEN ‘AI Update Service Point’... Continue Reading →

Blog at WordPress.com.

Up ↑