Reply
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

Highlighted
Advisor
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:  https://github.com/Microsoft/BusinessPlatformApps/tree/dev/Source/Apps/Microsoft/Released/Microsoft-...

 

specifically the  Service/Database/NoETL folder:  https://github.com/Microsoft/BusinessPlatformApps/tree/dev/Source/Apps/Microsoft/Released/Microsoft-...