SQL query
Question
Please help SQL query for distribution point role installed server name with OS version details.
aamir ansari 
Leave an answer
Sorry, you do not have permission to answer to this question .
Register Now
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