4 Replies Latest reply on Jun 21, 2013 2:40 AM by Bjorn Calabuig

    How to... working with Spoon

    Bjorn Calabuig
      Share This:

      Hi List,

      Just advancing with Spoon.

      I'm tryng to do this:

       

      - Excel with Business Services (just like computer sample)

      - Excel with Business Services Relationships (just like computer vs processor sample)

       

      Q1: How to update attributes present at AST level but NOT at CORE level?

      For example, System Role. This attribute appears on AST:Business Service but not on BMC.CORE:BMC_BusinessService.

       

      In order to import Business Services, I'm trying to use a transformation to insert registers on BMC.CORE:BMC_BusinessService, including information related to System Role, as said, only present on AST form.

       

      But, what should be done to map, for example, System Role to the System Role field on AST:BusinessService?

      I guess I should design something similar than what is done in CI-CMDB transformation, at high level:

       

      CI-BusinessServiceInput -> CI-BS-CMDBOutput -> CI-BS-AROutput.

       

      The last step, pointing to AST:BusinessService form instead of AST:LoadAttributes.

       

      Q2: Create relationships works, but how to create People relationships, between a Business Service and a Company/Organization/Department?


      I'm still working on this right know, as far as now, I've created a transformation called "BMC_BusinessService_Rel_BusinessService_XLS".

      Any help would be appreciated.

       

      Kind Regards,

      Björn.

        • 1. Re: How to... working with Spoon

          These transforms posted here might be useful:

           

          https://communities.bmc.com/docs/DOC-23130

           

          As far as AST Attributes, I created an integration with Rackwise and used ththe AROutput step to AST:Attributes to populate Attributes that are not BMC_ComputerSystem CI Attributes (e.g. Tag Number).

           

          KP

          1 of 1 people found this helpful
          • 2. Re: How to... working with Spoon
            Bjorn Calabuig

            Karl,

            Thanks for your quick response.

             

            I'll take a look as soon as I can to the Service Modeller you're proposing.

             

            Kind Regards,

            Björn.


            • 3. Re: How to... working with Spoon

              I recently modified the Service Modeling Toolkit for a customer who wanted to include Consumer CIs such as BMC_Organization. See the "scrubbed" screenshots. If you would like the AI Transforms, just email me directly karlis_peterson@bmc.com.

               

              Here are the screenshots: *we built 75 Service Models in 4 minutes using AI

               

              Sample scrub2.png

              Sample scrub1.png

               

               

               


              • 4. Re: How to... working with Spoon
                Bjorn Calabuig

                Hi Karlis,

                Nice to see that our approach isn't a foulish idea...

                 

                We're working also in a similar direction:

                 

                A People Collection (at Company, Organization or Department level) uses a collection of "Solutions".

                 

                A Solution, as you can see, is composed basically by Technological Services (1 to N) and each of these is also connected to Provider Services (1 to N). Under the Provider Services, there can be 1 to N IT Infrastructure layers.

                 

                Image1a.jpg

                 

                Solutions can share Technological Services, such as Applications or Licenses. Provider Services are normally related to CPD.

                 

                Solutions could normally be connected to something called Locations. A Location is a combination of People Collection and a Site. A Location could be shared by different People Collections. Defining Locations at CI level, more precise information is available when analyzing impact.

                 

                Some Solutions can be demaned through SRM. Solutions like those related directly to "User Profiles", once provided, will cause the creation of "used by" relationships between user and solution.

                 

                Each Solution 3-Level approach represents a logical tree on CMDB. In fact, the primary idea is to work on ITSM (for example, on Incident Management) using the same 3-Level representation.

                 

                Image2.jpg

                 

                When navigating Top-Down, Product Categorization will change dinamically according to the last level selected. Bottom-Up navigation is also possible.

                 

                This are just ideas that maybe will never see the light...

                 

                Thanks.

                Björn