SharePoint connect to SCCM

Question

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 the SCCM and put it back on SharePoint list.

For Example User will enter a computer name into sharepoint list and then SQL Query will run and it will go to SCCM and find that computer name and grab other information about computer and put back into SharePoint list.

frank daske · Answer

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:&nbsp;https://www.layer2solutions.com/support/cloud-connector-faqs/sql-sync-to-office365&nbsp;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. &nbsp;

deleted · Answer

Do you need it in a SharePoint List?&nbsp;Reason I ask is you could use PowerBI or Power Query in Excel to query AD directly (without SCCM) and pull back the information.&nbsp;And if you really, really need it in a SharePoint List then use Flow to read the info out and copy to the List.

deleted · Answer

I have to use the SharePoint List because i have a PowerApps and it saves all the data into SharePoint list.

dean_gross · Answer

you could install the Data Gateway and have your powerapp use that to connect to SCCM

deleted · Answer

if i use Data Gateway will that save information in sharepoint list?

Forum Discussion

SharePoint connect to SCCM

7 Replies

Resources