SQL query


Please help SQL query for distribution point role installed server name with OS version details.

Answer ( 1 )

  1. It is really tricky if your DP servers don’t have SCCM clients installed. If you have SCCM clients installed on the DP servers then it’s easy … you can pull these details from the default reports based on collection….

    https://www.anoopcnair.com/sccm-server-details-with-roles-custom-sql-query/ this is basic SCCM Infra server report …. when SCCM client is not installed.

    https://www.anoopcnair.com/sccm-patch-status-sql-query-based-collection/ this report will give you operating system details for a collection

    Best answer

Leave an answer

Sorry, you do not have permission to answer to this question .