Forum Discussion
SharePoint connect to SCCM
i have a SharePoint List and i want to get some information from SCCM by running SQL Query on back end. i have a SQL Query but i do not know how to connect SharePoint to SCCM and get the data from th...
Do you need it in a SharePoint List?
Reason I ask is you could use PowerBI or Power Query in Excel to query AD directly (without SCCM) and pull back the information.
And if you really, really need it in a SharePoint List then use Flow to read the info out and copy to the List.
I have to use the SharePoint List because i have a PowerApps and it saves all the data into SharePoint list.
you could install the Data Gateway and have your powerapp use that to connect to SCCM
if i use Data Gateway will that save information in sharepoint list?
