<h2>Service Graph Connector for Microsoft SCCM 3.0 Setup Guidelines</h2><br/><div style="overflow-x:auto"><p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; font-family: inherit, serif;">Service Graph Connector for Microsoft SCCM 3.0 Setup Guidelines</span></strong></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;">Introduction</span></strong></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><span style="font-size: 10.5pt; color: #2e2e2e;">Service Graph Connector for Microsoft SCCM (SG-SCCM) 3.0 release </span><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">allows users to import data from multiple SCCM instances into a single ServiceNow CMDB. </span></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">Service Graph Connector for Microsoft SCCM 3.0 has a different initial configuration from the previous versions of the connector. This document describes the best practices for customers that are upgrading to Service Graph Connector for Microsoft SCCM 3.0.</span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">Whether importing data from a single SCCM instance or multiple SCCM instances, all users of SG-SCCM 3.0 are expected to go through the steps of the Guided Setup to create new connections and generate corresponding data sources and scheduled data imports. These generated data sources and scheduled data imports are used for data import. </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;">Key Steps</span></strong></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <ol style="margin-bottom: 0in; margin-top: 0px; list-style-position: inside;"><li style="font-size: 10.5pt; line-height: 150%; font-family: SourceSansPro, serif; color: #2e2e2e;"><span style="font-family: 'times new roman', times;">Grant permissions for SG-SCCM to create data sources and scheduled data imports dynamically.</span></li><li style="font-size: 10.5pt; line-height: 150%; font-family: SourceSansPro, serif; color: #2e2e2e; background: white;"><span style="font-family: 'times new roman', times;">For each SCCM instance to import from:</span><br /> <ol style="list-style-type: lower-alpha; margin-bottom: 0in; margin-top: 0px; list-style-position: inside;"><li style="font-size: 10.5pt; line-height: 115%; font-family: SourceSansPro, serif; color: #2e2e2e;"><span style="font-family: 'times new roman', times;">Create a new connection and credential to the SCCM instance.</span></li><li style="font-size: 10.5pt; line-height: 115%; font-family: SourceSansPro, serif; color: #2e2e2e;"><span style="font-family: 'times new roman', times;">Create a new set of data sources and scheduled data imports.</span></li><li style="font-size: 10.5pt; line-height: 115%; font-family: SourceSansPro, serif; color: #2e2e2e;"><span style="font-family: 'times new roman', times;">Validate the data sources to confirm connectivity.</span></li></ol> </li></ol> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">Complete the is following steps through the guided setup to configure SG-SCCM 3.0.</span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;">Guided Setup: Configure Data source and Scheduled data import access</span></strong></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><span style="font-size: 10.5pt; color: #2e2e2e;">Unlike previous versions of SG-SCCM, Service Graph Connector for Microsoft SCCM 3.0 </span><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">does not </span><span style="font-size: 10.5pt; color: #2e2e2e;">directly execute the <span style="background: white;">out-of-box data sources and scheduled data imports. </span>Instead, SG-SCCM 3.0 creates a new set of data sources and scheduled imports for each SCCM connection, which are copied from the out-of-the-box data sources (also called Prime Data Sources) and scheduled imports. These newly copied Data Sources are identified with a unique prefix that is provided by the customer during configuration. </span></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">After creating</span><span style="font-size: 10.5pt; color: #2e2e2e;"> a<span style="background: white;"> connection and credential alias user</span>, the connector<span style="background: white;"> generates corresponding data sources and scheduled data imports. </span> However, scoped applications do not have the capability to create data sources or scheduled data imports by default on the ServiceNow platform. Therefore, t<span style="background: white;">o enable the generation of data sources and scheduled data imports</span>, the<span style="background: white;"> user needs to create access on the following tables:</span></span></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <ul style="margin-bottom: 0in; margin-top: 0px; list-style-position: inside;"><li style="font-size: 10pt; font-family: SourceSansPro, serif; color: #4c4e59; background: white;"><span style="font-family: 'times new roman', times;">Data source [sys_data_source]</span></li><li style="font-size: 10pt; font-family: SourceSansPro, serif; color: #4c4e59; background: white;"><span style="font-family: 'times new roman', times;">Scheduled data import [scheduled_import_set]</span></li></ul> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">The first step in the guided setup, "Configure Data source and Scheduled data import access", enables these required permissions.</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="text-align: center; background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img src="/sys_attachment.do?sys_id=0938866793f312d05736b25d6cba109a" width="310" height="290" loading="lazy" /></span></p> <p style="text-align: center; background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">Follow the steps to configure the required access, as shown below.</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">The following figure shows the "Application Access" for </span><span style="font-size: 10pt; color: #4c4e59; background: white;">Data source [sys_data_source] </span><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">table.</span></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10pt; font-family: 'times new roman', times; color: #4c4e59; background: white;"><img style="display: block; margin-left: auto; margin-right: auto;" src="/sys_attachment.do?sys_id=4938866793f312d05736b25d6cba10b6" width="468" height="273" loading="lazy" /></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">The following figure shows the "Application Access" for </span><span style="font-size: 10pt; color: #4c4e59; background: white;">Scheduled data import [scheduled_import_set]</span><span style="font-size: 10.5pt; color: #2e2e2e; background: white;"> table.</span></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img style="display: block; margin-left: auto; margin-right: auto;" src="/sys_attachment.do?sys_id=9138c66793f312d05736b25d6cba102e" width="468" height="271" loading="lazy" /></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;">Guided Setup: Configure the connection</span></strong></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">In this step, we create a new connection, using the Flow Designer Connection Credentials interface. Please note that there are two different connection options in the guided setup:</span></p> <ul style="margin-bottom: 0in; margin-top: 0px; list-style-position: inside;"><li style="font-size: 10.5pt; font-family: SourceSansPro, serif; color: #2e2e2e; background: white;"><span style="font-family: 'times new roman', times;">Configure connection</span></li><li style="font-size: 10.5pt; font-family: SourceSansPro, serif; color: #2e2e2e; background: white;"><span style="font-family: 'times new roman', times;">Configure connection (Integrated authentication)</span></li></ul> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">It is only required to configure one <strong><em>or</em></strong> the other of these two, based upon whether or not you wish to use the Integrated Authentication feature. </span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="text-align: center; background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img src="/sys_attachment.do?sys_id=f038866793f312d05736b25d6cba1081" width="276" height="336" loading="lazy" /></span></p> <p style="text-align: center; background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">Clicking on the Configure button takes us to the Flow Designer Connections page. </span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;">Connection and credential setup</span></strong></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">Whether this is a new install of SG-SCCM or an upgrade from SG-SCCM 2.5, the expectation of SG-SCCM 3.0 is that a new connection and credential alias will be created for each SCCM connection, including the first connection. <span style="background: white;">User</span>s<span style="background: white;"> that </span>are <span style="background: white;">upgrading from an older version of Service Graph connector for Microsoft SCCM </span>are <span style="background: white;">expected to create </span>a <span style="background: white;">new connection and credential alias. </span></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">In the Flow Designer Connections interface, do not configure the Default Connection. Rather, click on the Add Connection button to add a new connection.</span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img style="display: block; margin-left: auto; margin-right: auto;" src="/sys_attachment.do?sys_id=cd38866793f312d05736b25d6cba10bc" width="468" height="146" loading="lazy" /></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">Configure and create the connection. It is suggested to give a meaningful name for this connection to differentiate it from other SCCM connections that may be created later.</span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="text-align: center; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img src="/sys_attachment.do?sys_id=5538866793f312d05736b25d6cba10f6" width="318" height="257" loading="lazy" /></span></p> <p style="text-align: center; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">Note:</span></strong><span style="font-size: 10.5pt; color: #2e2e2e; background: white;"> Mid Server is configured as a part of guided setup step of "Configure Data Source and Scheduled Data Import". </span></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">After the new connection is created, you should see it in the list of Connections in Flow Designer.</span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img style="display: block; margin-left: auto; margin-right: auto;" src="/sys_attachment.do?sys_id=3038866793f312d05736b25d6cba107e" width="468" height="165" loading="lazy" /></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;"> </span></strong></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">Navigate back to the guided setup to continue the configuration process.</span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;"> </span></strong></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;">Guided Setup: Configure Data Source and Scheduled Data Import</span></strong></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">In this step, we generate a set of data sources and scheduled data imports for the newly created connection. Users need to create a new set of data sources and imports to allow for separate scheduling and customization for each SCCM connection.</span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;"> </span></strong></span></p> <p style="text-align: center; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;"><img src="/sys_attachment.do?sys_id=5138c66793f312d05736b25d6cba1026" width="314" height="318" loading="lazy" /></span></strong></span></p> <p style="text-align: center; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;"> </span></strong></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;">Generating corresponding data sources and scheduled data imports</span></strong></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;"> </span></strong></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><span style="font-size: 10.5pt; color: #2e2e2e;">Service Graph Connector for Microsoft SCCM 3.0 </span><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">uses generated data sources and scheduled data import</span><span style="font-size: 10.5pt; color: #2e2e2e;">s<span style="background: white;"> instead using of out-of-box data sources and scheduled data imports. </span>The g<span style="background: white;">uided </span>S<span style="background: white;">et</span>up<span style="background: white;"> step "Configure Data Source and Scheduled Data Import" generates data sources and scheduled data import associated with </span>the <span style="background: white;">connection and credential alias.</span></span></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">The first configuration element, "Prefix to Data source and Scheduled data import sets", is a mandatory item. This prefix is an identifier (max 8 characters) that is appended to all of the data source and scheduled import names for this distinct SCCM connection. In a Multi-Instance deployment, this prefix should be a short, meaningful identifier that allows you to identify a set of related data sources. For example, if you have two different SCCM instances for AMS and EMEA regions, you could choose "AMS" and "EMEA" as your instance prefixes, for easy identification and differentiation between the sets of data sources and schedules.</span></p> <p style="text-align: center; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img src="/sys_attachment.do?sys_id=7c38866793f312d05736b25d6cba1090" width="389" height="170" loading="lazy" /></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">Note: </span></strong><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">MID Server is mandatory if "Connection and Credential Alias" created for Integrated authentication connection type.</span></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">After configuring the connection, click "Create/Update Imports". If the prefix is a new unique value, the SG-SCCM guided setup will create a new set of data sources and scheduled data imports, copied from the default (Prime) SG-SCCM data sources and scheduled imports, using the prefix plus the identified connection, MID and Run As User parameters. </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">If the prefix value corresponds to an existing set of SG-SCCM Data Sources, then those data sources and scheduled data imports will be updated with the newly specified configuration parameters.</span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">After creation, the new data sources and scheduled data imports are shown as below. Note that these items have their<span style="background: white;"> name</span>s<span style="background: white;"> prefixed with </span>the p<span style="background: white;">refix </span>value <span style="background: white;">specified in </span>the <span style="background: white;">previous step. </span></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"> <span style="font-size: 10.5pt; color: #2e2e2e; background: white;"><img style="display: block; margin-left: auto; margin-right: auto;" src="/sys_attachment.do?sys_id=8d38866793f312d05736b25d6cba10d4" width="468" height="327" loading="lazy" /></span></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;">Validate Data Sources</span></strong></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">After the new data sources are created, they should be validated to confirm connectivity. On the guided setup step "Validate Data Sources", click on the Configure button.</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">Select the newly created data source based upon SG-SCCM Computer Identity. Then click on "Test Load 20 Records".</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">Confirm the connection was successful with a non-zero number of records processed.</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;"><img style="display: block; margin-left: auto; margin-right: auto;" src="/sys_attachment.do?sys_id=3838866793f312d05736b25d6cba107a" width="316" height="68" loading="lazy" /></span></strong></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;">Generated data source and connection and credential information</span></strong></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">Microsoft SCCM uses an internal identifier called Resource ID to uniquely identify computers inside SCCM. This ID is used in SG-SCCM as part of the Source Native Key to identify records. However, Microsoft SCCM does not guarantee that Resource IDs are unique across multiple SCCM instances. It is known that SCCM Resource IDs can and will overlap between different SCCM instances. Unless handled correctly, this can cause data from different SCCM instances to combine together in incorrect and undesirable ways inside the CMDB.</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">To differentiate data from different SCCM instances, d<span style="background: white;">ata imported using </span>a <span style="background: white;">generated </span>D<span style="background: white;">ata </span>S<span style="background: white;">ource has a connection and credential alias </span>identifier (sys_id) embedded in the SQL select statement. This <span style="background: white;">information is used to associate CIs with </span>a <span style="background: white;">specific SCCM instance.</span></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">When SG-SCCM guided setup creates the sets of data sources as described in the steps above, it will dynamically add this SQL clause, based upon the configured connection and credential alias. </span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">The following figure shows the generated data source SQL statement that has connection and credential alias information embedded in it. </span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img style="display: block; margin-left: auto; margin-right: auto;" src="/sys_attachment.do?sys_id=4538866793f312d05736b25d6cba10cf" width="468" height="226" loading="lazy" /></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">The following figure shows the import set row with connection and credential alias information sys_id as a distinct import data column.</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img style="display: block; margin-left: auto; margin-right: auto;" src="/sys_attachment.do?sys_id=1d38c66793f312d05736b25d6cba1028" width="468" height="109" loading="lazy" /></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">The following figure shows the Sources [sys_object_source] table records with the connection and credential alias information associated with all of the records.</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img style="display: block; margin-left: auto; margin-right: auto;" src="/sys_attachment.do?sys_id=c138866793f312d05736b25d6cba10f3" width="468" height="191" loading="lazy" /></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;"> </span></strong></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;"> </span></strong></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;">Regarding Out of the Box Data Sources and Scheduled Data Imports</span></strong></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">Users should not directly configure or use the out-of-the-box (OOTB) scheduled data imports or data sources (which have names starting with 'SG-SCCM') because of following reasons:</span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <ul style="margin-bottom: 0in; margin-top: 0px; list-style-position: inside;"><li style="font-size: 10.5pt; font-family: SourceSansPro, serif; color: #2e2e2e; background: white;"><span style="font-family: 'times new roman', times;">OOTB scheduled data imports or data sources are used as a template for generating an instance of data sources and scheduled data imports.</span></li><li style="font-size: 10.5pt; font-family: SourceSansPro, serif; color: #2e2e2e; background: white;"><span style="font-family: 'times new roman', times;">Any customization of SQL statement in out of box data sources will copied to generated data sources, which may not be desired.</span></li><li style="font-size: 10.5pt; font-family: SourceSansPro, serif; color: #2e2e2e; background: white;"><span style="font-family: 'times new roman', times;">Guided <span style="font-size: 10.5pt; color: #2e2e2e;">S<span style="background: white;">etup no</span> <span style="background: white;">longer provides the ability to set credential and other configuration for out-of-box data sources.</span></span></span></li><li style="font-size: 10.5pt; font-family: SourceSansPro, serif; color: #2e2e2e; background: white;"><span style="font-family: 'times new roman', times;">Data imported using OOTB data sources will be missing connection and credential alias information, so there is no way to associate CIs with a specific SCCM instance.</span></li></ul> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">Instead, it is recommended to follow the guided setup steps as described above to add a new connection and create the copies of data sources and scheduled data imports for execution.</span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;"> </span></strong></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;">Deactivating the existing 'SG-SCCM Computer Identity' scheduled data import</span></strong></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">In a SG-SCCM upgrade scenario, the existing SG-SCCM Computer Identity Scheduled Data Import may still be active. <span style="background: white;">User</span>s<span style="background: white;"> must deactivate the existing "SG-SCCM Computer Identity" scheduled data import because in this version</span> of SG-SCCM, the OOTB<span style="background: white;"> data sources and scheduled data imports</span> (which<span style="background: white;"> ha</span>ve<span style="background: white;"> a name starting with 'SG-SCCM'</span>) are <span style="background: white;">used as a template when creating a</span> set<span style="background: white;"> of data sources and scheduled data imports. </span></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">Instead, u<span style="background: white;">ser</span>s should<span style="background: white;"> configure the generated scheduled data import </span>as described above, and then <span style="background: white;">use that for </span>the SCCM <span style="background: white;">data import. </span></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;">Skipped data source records during upgrade</span></strong></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">Customer who are upgrading from </span><span style="font-size: 10.5pt; color: #2e2e2e;">a <span style="background: white;">previous version of </span>the SG-SCCM <span style="background: white;">connector</span> <span style="background: white;">will have data sources record</span>s<span style="background: white;"> as </span>S<span style="background: white;">kipped </span>Changes in the upgrade process<span style="background: white;">. This happens because </span>in previous versions of SG-SCCM, the <span style="background: white;">credential and connection detail</span>s<span style="background: white;"> are saved in </span>directly on the <span style="background: white;">Data Source [sys_data_source] record.</span> Thus, it is identified as a "customized" record that cannot be automatically merged on upgrade.</span></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">These skipped updates must be resolved to ensure that all new features of SG-SCCM 3.0 are installed on the customer instance. It is expected that all the records in "Skipped Changes to Review" will need to be resolved.</span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">The following figure shows out-of-box data sources records as the skipped 'Customizations Unchanged' records. </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img style="display: block; margin-left: auto; margin-right: auto;" src="/sys_attachment.do?sys_id=9938866793f312d05736b25d6cba10fb" width="468" height="238" loading="lazy" /></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">Users should review these skipped Data Source [sys_data_source] record and "Revert to Base System".</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img style="display: block; margin-left: auto; margin-right: auto;" src="/sys_attachment.do?sys_id=0d38866793f312d05736b25d6cba10b9" width="468" height="213" loading="lazy" /></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">Note: "</span></strong><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">Revert to Base System" for out-of-box data sources record is required because these data sources are used as templates for generating an instance of data sources. </span></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">If there are existing customizations of the SG-SCCM SQL statements that are desired to be preserved, these SQL statements should be saved (such as to a text file), before reverting to the Base System. They can then be remerged using the following guided setup step.</span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;">Guided Setup: Customize Instance Data source SQL statement</span></strong></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">SQL statement customization is an optional step. If users want to customize the SQL statement, they must modify the instance member "Custom SQL Statement" instead of modifying data source SQL statement directly. This is because the SQL statements in the data sources can be overwritten during data import.</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">To customize, click the Configure button in the "Customizing Data source SQL statement" section of guided setup.</span></p> <p style="text-align: center; background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img src="/sys_attachment.do?sys_id=c538866793f312d05736b25d6cba10d7" width="329" height="220" loading="lazy" /></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">This presents a list of "SCCM Instances". Each of these corresponds to a single connection/instance, identified by the specified prefix, such as "AMS" in the example below.</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img style="display: block; margin-left: auto; margin-right: auto;" src="/sys_attachment.do?sys_id=0138866793f312d05736b25d6cba1094" width="468" height="156" loading="lazy" /></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">Click on the instance prefix to see the list of "Instance Members" for this prefix. Each instance member represents the derivation of the specific instance data source from the Prime (OOTB or default) data source. </span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="text-align: center; background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img src="/sys_attachment.do?sys_id=cd38866793f312d05736b25d6cba10bf" width="354" height="176" loading="lazy" /></span></p> <p style="text-align: center; background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">In the Instance Members, there is a column "Custom SQL Statement". This is where a custom SQL statement can be set, for a specific data source associated with a specific instance/prefix. For example, you can specify a custom SQL statement for the "AMS-SG-SCCM Computer Identify" data source, which is derived from the prime (default) SG-SCCM Computer Identity data source. This custom SQL statement overrides the default SQL, for this data source.</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">In a Multi-Instance scenario, you can have different custom SQL statements for different instance sets, e.g. one custom SQL statement for "AMS-SG-SCCM Computer Identity", a different custom SQL for "EMEA-SG-SCCM Computer Identity", and so on.</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">To add a custom SQL statement for a specific instance member data source:</span></p> <ol style="margin-bottom: 0in; margin-top: 0px; list-style-position: inside;"><li style="font-size: 10.5pt; font-family: SourceSansPro, serif; color: #2e2e2e; background: white;"><span style="font-family: 'times new roman', times;">Click on the Instance Member record. </span></li><li style="font-size: 10.5pt; font-family: SourceSansPro, serif; color: #2e2e2e; background: white;"><span style="font-family: 'times new roman', times;">On this form, you can populate the Custom SQL Statement field. </span></li><li style="font-size: 10.5pt; font-family: SourceSansPro, serif; color: #2e2e2e;"><span style="font-family: 'times new roman', times;">For convenience, you can populate the custom SQL statement field with the current default SQL statement (from the corresponding Prime data source) by clicking the "Copy Prime SQL Statement" link. This gives a recommended starting point for any intended customization.</span></li><li style="font-size: 10.5pt; font-family: SourceSansPro, serif; color: #2e2e2e;"><span style="font-family: 'times new roman', times;">Click Update to save the changes.</span></li></ol> <p style="text-align: center; background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img src="/sys_attachment.do?sys_id=0538866793f312d05736b25d6cba10d2" width="468" height="367" loading="lazy" /></span></p> <p style="text-align: center; background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">Note: The Connection ID field does not need to be added to the SQL statement. It will be inserted automatically during import execution.</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">The following is the order in which SQL statements are used:</span></p> <ul style="margin-bottom: 0in; margin-top: 0px; list-style-position: inside;"><li style="font-size: 10.5pt; font-family: SourceSansPro, serif; color: #2e2e2e; background: white;"><span style="font-family: 'times new roman', times;">"Custom SQL Statement" - 1<sup>st</sup> Preference if specified.</span></li><li style="font-size: 10.5pt; font-family: SourceSansPro, serif; color: #2e2e2e; background: white;"><span style="font-family: 'times new roman', times;">"SQL Statement" field of "Prime Data Source" if "Custom SQL Statement" is not specified.</span></li></ul> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img style="display: block; margin-left: auto; margin-right: auto;" src="/sys_attachment.do?sys_id=d538c66793f312d05736b25d6cba1071" width="468" height="227" loading="lazy" /></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;">In the example above, "AMS-SG-SCCM Computer Identity" will use the custom SQL Statement. Meanwhile, "AMS-SG-SCCM Disk" will use the default SQL statement defined on SG-SCCM Disk.</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 10.5pt; color: #2e2e2e; background: white;"> </span></strong></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">Note: </span></strong><span style="font-size: 10.5pt; color: #2e2e2e;">Upgrading c<span style="background: white;">ustomer</span>s<span style="background: white;"> who have customized "SQL Statement" </span>in the previous SG-SCCM are <span style="background: white;">required to </span>manually <span style="background: white;">move </span>their <span style="background: white;">SQL statement customization to </span>the <span style="background: white;">"Custom SQL Statement" field of "Instance Member". </span> </span></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e;"> </span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;">ServiceNow Software Asset Management Professional data source</span></strong></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">If the "Software Asset Management Professional" plugin is activated before the Guided Setup step of "Configure Data Source and Scheduled Data Import" is performed, then the following additional data sources and scheduled data import are generated:</span></p> <ul style="margin-bottom: 0in; margin-top: 0px; list-style-position: inside;"><li style="font-size: 10.5pt; font-family: SourceSansPro, serif; color: #2e2e2e; background: white;"><span style="font-family: 'times new roman', times;"><Prefix>-SG-SCCM SAMP Usage</span></li><li style="font-size: 10.5pt; font-family: SourceSansPro, serif; color: #2e2e2e; background: white;"><span style="font-family: 'times new roman', times;"><Prefix>-SG-SCCM Software Edition</span></li><li style="font-size: 10.5pt; font-family: SourceSansPro, serif; color: #2e2e2e; background: white;"><span style="font-family: 'times new roman', times;"><Prefix>-SG-SCCM Software Last Used</span></li></ul> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img style="display: block; margin-left: auto; margin-right: auto;" src="/sys_attachment.do?sys_id=5138866793f312d05736b25d6cba10f9" width="468" height="90" loading="lazy" /></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">But if the user activates "Software Asset Management Professional" after performing the guided setup step of "Configure Data Source and Scheduled Data Import" and want to use above data sources and scheduled data import then they must re-execute the guided setup step of 'Configure Data Source and Scheduled Data Import' to re-generate these data sources and scheduled data import. </span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;">Editing or deleting generated data source and scheduled data import</span></strong></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">If the user performs "Configure Data Source and Scheduled Data Import" guided setup step using an existing "Prefix" then instead of generating new data source or scheduled data import existing, the previously generated data sources and scheduled data imports are modified.</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">If the user wants to delete any generated data source or scheduled data import, they can delete these based on their need and re-generate it by performing guided setup step of "Configure Data Source and Scheduled Data Import".</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;">Adding a second SCCM Instance </span></strong></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><span style="font-size: 10.5pt; color: #2e2e2e;">As stated previously, Service Graph Connector for Microsoft SCCM (SG-SCCM) 3.0 release </span><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">allows users to import data from multiple SCCM instances into a single ServiceNow CMDB. </span></span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">The process of defining a second (or third, etc.) SCCM instance connection is the same as defining the first connection, as described above.</span></p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">Key Steps:</span></strong></span></p> <ol style="margin-bottom: 0in; margin-top: 0px; list-style-position: inside;"><li style="font-size: 10.5pt; line-height: 115%; font-family: SourceSansPro, serif; color: #2e2e2e;"><span style="font-family: 'times new roman', times;">Create a new connection and credential to the SCCM instance, using the guided setup "Configure the Connection" step as described above</span></li></ol> <p style="margin: 0in 0in 0in 0.25in; line-height: 115%; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; line-height: 115%; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="margin: 0in 0in 0in 0.25in; text-align: center; line-height: 115%; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; line-height: 115%; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img src="/sys_attachment.do?sys_id=d938c66793f312d05736b25d6cba1030" width="278" height="224" loading="lazy" /></span></p> <p style="margin: 0in 0in 0in 0.25in; text-align: center; line-height: 115%; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; line-height: 115%; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img src="/sys_attachment.do?sys_id=d138866793f312d05736b25d6cba10fe" width="468" height="226" loading="lazy" /></span></p> <p style="margin: 0in 0in 0in 0.25in; text-align: center; line-height: 115%; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; line-height: 115%; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <ol style="margin-bottom: 0in; margin-top: 0px; list-style-position: inside;" start="2"><li style="font-size: 10.5pt; line-height: 115%; font-family: SourceSansPro, serif; color: #2e2e2e;"><span style="font-family: 'times new roman', times;">Create a new set of data sources and scheduled data imports with a new and unique prefix.</span></li></ol> <p style="line-height: 115%; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; line-height: 115%; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="text-align: center; line-height: 115%; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; line-height: 115%; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img src="/sys_attachment.do?sys_id=0538866793f312d05736b25d6cba1097" width="453" height="250" loading="lazy" /></span></p> <p style="text-align: center; line-height: 115%; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; line-height: 115%; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="text-align: center; line-height: 115%; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; line-height: 115%; font-family: 'times new roman', times; color: #2e2e2e; background: white;"><img src="/sys_attachment.do?sys_id=9538c66793f312d05736b25d6cba102b" width="468" height="194" loading="lazy" /></span></p> <p style="line-height: 115%; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; line-height: 115%; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <ol style="margin-bottom: 0in; margin-top: 0px; list-style-position: inside;" start="3"><li style="font-size: 10.5pt; line-height: 115%; font-family: SourceSansPro, serif; color: #2e2e2e;"><span style="font-family: 'times new roman', times;">Validate the data sources to confirm connectivity</span></li></ol> <p style="line-height: 115%; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; line-height: 115%; font-family: 'times new roman', times; color: #2e2e2e; background: white;"> </span></p> <p style="line-height: 115%; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; line-height: 115%; font-family: 'times new roman', times; color: #2e2e2e; background: white;">The new data sources can be customized through the same process as described previously.</span></p> <p style="line-height: 115%; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif; text-align: center;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;">List of terms </span></strong></span></p> <table class="MsoTableGrid" style="border-collapse: collapse; border: none; height: 108px; margin-left: auto; margin-right: auto;" border="1" cellspacing="0" cellpadding="0"><tbody><tr style="height: 18px;"><td style="width: 167.656px; border: 1pt solid windowtext; padding: 0in 5.4pt; height: 18px;" valign="top"> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="color: #2e2e2e;">Name </span></strong></span></p> </td><td style="width: 455.656px; border-top: 1pt solid windowtext; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-image: initial; border-left: none; padding: 0in 5.4pt; height: 18px;" valign="top"> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><strong><span style="color: #2e2e2e;">Definition</span></strong></span></p> </td></tr><tr style="height: 36px;"><td style="width: 167.656px; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; border-image: initial; border-top: none; padding: 0in 5.4pt; height: 36px;" valign="top"> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">SCCM Instance</span></p> </td><td style="width: 455.656px; border-top: none; border-left: none; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 36px;" valign="top"> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">Set of data sources associated with </span><span style="font-size: 10.5pt; color: #2e2e2e;">a single <span style="background: white;">SCCM source. (Connection and credential alias)</span></span></span></p> </td></tr><tr style="height: 18px;"><td style="width: 167.656px; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; border-image: initial; border-top: none; padding: 0in 5.4pt; height: 18px;" valign="top"> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">SCCM Instance Member</span></p> </td><td style="width: 455.656px; border-top: none; border-left: none; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 18px;" valign="top"> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">Data source associated with 'SCCM Instance'.</span></p> </td></tr><tr style="height: 36px;"><td style="width: 167.656px; border-right: 1pt solid windowtext; border-bottom: 1pt solid windowtext; border-left: 1pt solid windowtext; border-image: initial; border-top: none; padding: 0in 5.4pt; height: 36px;" valign="top"> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 10.5pt; font-family: 'times new roman', times; color: #2e2e2e; background: white;">Prime data source</span></p> </td><td style="width: 455.656px; border-top: none; border-left: none; border-bottom: 1pt solid windowtext; border-right: 1pt solid windowtext; padding: 0in 5.4pt; height: 36px;" valign="top"> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-family: 'times new roman', times;"><span style="font-size: 10.5pt; color: #2e2e2e; background: white;">Template data source (out of box data source) that is used as </span><span style="font-size: 10.5pt; color: #2e2e2e;">origin for the <span style="background: white;">cop</span>y process<span style="background: white;"> for generating data source</span>s<span style="background: white;"> associated </span>with a <span style="background: white;">specific SCCM connection.</span></span></span></p> </td></tr></tbody></table> <p style="background: white; margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif; text-align: center;"><span style="font-family: 'times new roman', times;"><strong><span style="font-size: 13.5pt; color: #2e2e2e;"> </span></strong></span></p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p> <p style="margin: 0in; font-size: 12pt; font-family: 'Times New Roman', serif;"> </p></div>