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.
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.
We do what you are talking about with SharePoint lists and SCCM via SCORCH (System Center Orchestrator). That's what SCORCH is designed to do with Runbooks. If you are licensed for SCCM, you should check to see if you are licensed for the entire System Center suite.