Forum Discussion
SharePoint connect to SCCM
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?
To keep the results of pre-selected local SCCM SQL data queries (and many other sources) in sync with native SharePoint Online (or on-prem) lists code-free you can also go this way:
https://www.layer2solutions.com/support/cloud-connector-faqs/sql-sync-to-office365
A Windows Service does the job in the background. All SharePoint features, such as views, search, notifications, workflows, PowerApps, and more are available as the data finally is in the SharePoint list, always up-to-date.
