6 Replies Latest reply on Jan 17, 2019 9:09 AM by Carina Burns

    Prebuilt integration for SCCM?  Docs?  Listed as a feature in Remedy 9.x upgrade doc

    Carina Burns

      Currently on ARS 9.103 (ITSM Service Desk) and while looking at the docs to upgrade to 9.104, I came across the statement that there is prebuilt integration for SCCM.   However when I search the online documentation specifically using the phrase SCCM, I only get that same upgrade doc and the planning worksheets.  

       

      Where else should I look to find BMC Docs about this prebuilt integration and how to enable/use/deploy it?

      This is as much as I have come across but SCCM isn't specifically mentioned...BMC Atrium Core Web Services API components - Documentation for BMC Atrium Core 9.1 - BMC Documentation

        • 1. Re: Prebuilt integration for SCCM?  Docs?  Listed as a feature in Remedy 9.x upgrade doc
          Stefan Hall

          Everything you need you can find here, also the download link for the sccm AI Jobs

          BMC Atrium CMDB SCCM Adapter Guide - Documentation for BMC Atrium Core 9.1 - BMC Documentation

           

          Good Luck and a Happy New Year

          Stefan

          1 of 1 people found this helpful
          • 2. Re: Prebuilt integration for SCCM?  Docs?  Listed as a feature in Remedy 9.x upgrade doc
            Nick Caulfield

            Not quite everything.

             

            I thought there was documentation detailing a bug in the transformation for some component classes like operating system (mentioned by Andrius Seirys in the comments on that documentation page) but I could not find any link to that.

             

            Out of the box, if you open the transformation which imports Operating System CIs, you will see that there is a hop from Filter Rows to CMDBLookup.

            That hop should not be there (there should only be 2 hops coming from a Filter Rows step). Instead, there should be a hop from the previous step, CMDBOutput OperatingSystem going to CMDBLookup.

             

            Unless this is fixed (also for other classes like NetworkPort and Monitor - and possibly others), then the component will be imported but there will be no relationship between the computer and that component.

             

            OperatingSystem.png

             

             

            Something else to be aware of is that the number of CIs from the SoftwareProduct transformation can be very large. When I discussed this in another thread, I was told that some customers disable it altogether. We customised the SQL in the table lookup step to only bring in certain useful BMC_Product CIs and exclude other types. On the other hand, we did remove the transformation creating BMC_Memory CIs since there was a value for memory already being written to an attribute on the ComputerSystem CI and we did not feel that we needed both.

             

            We installed the 9.1 integration and later upgraded ARS and CMDB to 18.5. There do not seem to be any issues specifically relating to that upgrade even though Pentaho changes version from 4 to 6 in that time. Good thing too because when I tried to look up BMC documentation for the SCCM adaptor 9.1.04+, I ended up at a PDF which was a repeat of the 9.1 doc. Perhaps I just missed something there.

             

            We made a couple of other customisations as well so it does not hurt to consider the integration that BMC supply as a starting point, study it well and adapt it.

             

            Also, in the documentation, you will notice that there is a reconciliation job...

            ...which is nice, but it uses the standard rules which are better optimised for ADDM data than for SCCM data, and if you are using both (particularly if there is overlap) then you may need to consider things like ensuring the timing of the jobs is configured so that the ADDM reconciliation job runs first (because the standard rules use token Id a lot and SCCM data does not have this). If you do it in that order, it should be OK, but if a computer from SCCM is identified before the same computer in ADDM, then you may end up with two instances in the production dataset rather than a merged instance.

             

            Oh, and talking about identification, we found some examples of computers in the SCCM source having generic values for Serial number such as

             

            "None"

            "INVALID"

            "Chassis Serial Number"

            "OEM_Serial"

            "NONE"

            "12345678"

            "---------------------------------------"

             

            Seriously!!

             

            The fact that they are there at all is a Microsoft issue and not a BMC issue but if you also have similar, then you may want to customise the SCCM integration such that if it encounters values like this, it replaces them with a NULL serial number, otherwise some computers will not be identified because the identification rule which refers to serial number will think they are duplicate

            2 of 2 people found this helpful
            • 3. Re: Prebuilt integration for SCCM?  Docs?  Listed as a feature in Remedy 9.x upgrade doc
              Stefan Hall

              If we go into the details, I would recommend a partner product for the integration - seamless datapump.

              We had no problems with it and we‘re online very quickly with a good quality.

               

              Tech Data - SEAMLESS DATA PUMP™ for BMC Atrium CMDB (Microsoft SCCM, VMware,...

              • 4. Re: Prebuilt integration for SCCM?  Docs?  Listed as a feature in Remedy 9.x upgrade doc
                Nick Caulfield

                I've heard good things about Seamless - witnessed a demo once, but if that's not an option for any reason then the BMC integration (despite having room for improvement - part of which is in the details) can be made to work

                • 5. Re: Prebuilt integration for SCCM?  Docs?  Listed as a feature in Remedy 9.x upgrade doc
                  Stefan Hall

                  Absolutely, only a little more expensive.

                  Happy New Year

                  • 6. Re: Prebuilt integration for SCCM?  Docs?  Listed as a feature in Remedy 9.x upgrade doc
                    Carina Burns

                    School district...

                    In other words, we don't have a budget for anything and work mostly with duct tape and bubble gum to MacGyver fixes.