ConfigMgr Report: Total Number of Packages Per Distribution Point

less than 1 minute read

Today I had to create a report in ConfigMgr to list total number of packages that have been assigned to each Distribution Point. The SQL query is rather simple, a one-liner. Here’s the query:

select ServerNALPath, COUNT (PackageID) As PackageCount from v_DistributionPoint group by ServerNALPath order by PackageCount

This query works on both ConfigMgr 2007 and 2012.

ConfigMgr 2007 Report:

ConfigMgr 2012 Report:

Share on

Twitter Facebook LinkedIn

Azure Resource Graph Query for Subscription Owner Role Assignments

1 minute read

In the current customer engagement, we wanted to replace the Microsoft Defender for Cloud recommendation A maximum of 3 owners should be designated for subsc...

Azure Policy for Allowed Service Tags in Network Security Groups

2 minute read

Previously, I have published a blog post about Azure Policies for Restricting Service Tag in Network Security Groups. In that post, I shared the policy defin...

Azure Policies for Restricting Service Tag in Network Security Groups

1 minute read

Recently Tenable has reported a vulnerability on Azure Network Security Groups (NSG) related to the use of service tags in NSG rules You can read more about ...

PowerShell Module AzPolicyTest V2.0 Released

6 minute read

Introduction I created the PowerShell module AzPolicyTest (GitHub, PowerShellGallery) back in 2019. This module provides a list of Pester tests can be used t...

Tao Yang