SQL query
Question
Please help SQL query for distribution point role installed server name with OS version details.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please help SQL query for distribution point role installed server name with OS version details.
Answer ( 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