Recent Posts - page 2

  • ConfigMgr : Discovery Methods in System Center Configuration Manager 1706 CB

    In Today’s tutorial, we learn about the discovery methods in System center configuration manager. We have below discovery methods in System Center Configuration Manager. – Active Directory Forest Discovery – Active Directory Group Discovery – Active Directory System Discovery –… Read More ›

  • ConfigMgr Guide : Holistic Standardization and Fine Tuning

    This is one guide that will take your SCCM skills and environment to a whole new level ! This would give you good insight into your infra and also let you understand how the enterprise class Microsoft Suite is behaving… Read More ›

  • SCCM Troubleshooting : Ironing out Patching for ConfigMgr 2007 (upto 95% compliance)

    This guide will take you through troubleshooting guides, tips, tricks and tools to achieve 95%+ compliance in your environment and maximum coverage. The guide assumes the following environmental conditions:   Microsoft System Center Configuration Manager 2007 R3 WSUS 3.0 SP2… Read More ›

  • Power BI : ConfigMgr : Indepth Hardware Inventory Report – (with pbix, query and guide)

    Power BI : ConfigMgr : Indepth Hardware Inventory Report

  • Power BI : Microsoft Office Telemetry Dashboard

    Microsoft Office’s Telemetry Dashboard is an essential add-on for giving your environment an Office Health Index – where you have it, licensing, upgrade, tracking issues, AppCompat etc. The insight telemetry provide is priceless and yet free. Here the data sources… Read More ›

  • Power BI : How to make quick awesome looking dashboard for SCCM

    An awesome example of what power bi can do – and its all interactive and dynamic content – which sync’s with your sql data in real time. a little bit of sql and little bit of excel does the magic…. Read More ›

  • Powershell : OpsMgr : SCOM 2012 Prereqs Powershell

    Start-Transcript -Path c:transcript0.txt -noclobber # This scripts needs unrestricted access Write-Host “This scripts needs unrestricted access (Set-ExecutionPolicy Unrestricted.)” -ForegroundColor Green Write-Host “The prereq setup for System Center 2012 R2 Operations Manager takes around 15 minutes depending on your internet speed”… Read More ›

  • SCCM SQL Query : SQL Query for Client Count per AD Site

    SELECT     R.AD_Site_Name0,     Count(SMS_Installed_Sites0) AS ‘Count’ From     v_R_System R     JOIN v_RA_System_SMSInstalledSites SIS ON R.ResourceID = SIS.ResourceID Group By     R.AD_Site_Name0 

  • SCCM SQL Query : SQL Query for Locations and Boundaries

    Download SQL Query   The Query : select sys1.Name, sys1.DefaultSiteCode, (select SUBSTRING(sys2.ServerNALPath, CHARINDEX(‘\\’, sys2.ServerNALPath) + 2, CHARINDEX(‘”]’, sys2.ServerNALPath) – CHARINDEX(‘\\’, sys2.ServerNALPath) – 3 ) + CASE sys2.Flags WHEN ‘1’ Then ‘ (Slow)’ WHEN ‘0’ THEN ” END + ‘; ‘… Read More ›

  • SCCM SQL Query : Find SCCM Client Health

    select sys.Name0 as ‘Computer Name’, sys.User_Name0 as ‘User Name’, summ.ClientStateDescription, case when summ.ClientActiveStatus = 0 then ‘Inactive’ when summ.ClientActiveStatus = 1 then ‘Active’ end as ‘ClientActiveStatus’, summ.LastActiveTime, case when summ.IsActiveDDR = 0 then ‘Inactive’ when summ.IsActiveDDR = 1 then ‘Active’… Read More ›