SQL queryQuestionPlease help SQL query for distribution point role installed server name with OS version details. solved 0 Configuration Manager aamir ansari 1 year 2021-09-30T16:38:15+05:30 2021-09-30T16:38:15+05:30 1 Answer 27 views Beginner 0
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