Frequent Visitor
Posts: 8
Registered: ‎04-04-2018

SCCM Solution Template stored procs

Hi folks,


Installing the SCCM Solution Template deploys a suite of scripts to the client most likely in C:\Program Files\Microsoft Templates\Microsoft-SCCMTemplate\Apps\Microsoft\Released\Microsoft-SCCMTemplate\Service\Resources\Scripts, one of which is "process data.sql". The last line in this file is:

EXEC [pbist_sccm].[sp_set_process_flag] .... however I am unable to locate this sproc .... does anyone have an idea as to where it is located?


TIA John

Posts: 35
Registered: ‎07-31-2015

Re: SCCM Solution Template stored procs

All stored procedures are executed/created on the TARGET system during the installation process.  


Have a look at the Git repo:


specifically the  Service/Database/NoETL folder: