11 Replies Latest reply: Apr 9, 2012 3:25 AM by Josie George RSS

    CataLog Mapping in Normalization

    Rahul Priyadarshy

      Hi All,

       

      I am not sure what i am doing wrong, Please give some input. (Referred BMC KnowledgeBase-KA-321339)

       

      I have configured DATASET for normalization.

       

      BMC.SCCM- Data Set Name

      Inline Normalization - Yes

      Allow Unapproved CI-Yes

      Create New PC Entry-Yes

       

      Then i created few Catalog Mapping in Normalization Engine to Replace the Product name in my BMC.SCCM dataset itself (Discoved Vs What we want to Put).

       

      Results are below-->

      Data Is Pulled by AIE Succesfully in BMC.SCCM dataset.-----Done

       

      New PC Entry is Getting Created if its not there as a part of Inline Normalization.-------Done

       

      Catalog Mapping is not taking place.Also CTI product/manufatrures for which i have done mapping its original data (exact Discoved data) is coming in my data set (No Mapping conversion). ------- i dont see any error.

       

      Any help will be really appreciated

       

      Regards

      Rahul P

        • 1. Re: CataLog Mapping in Normalization
          Amey Bagwe

          Hi Rahul,

           

          Have you created entries on the NE:ProductNameAlias form for the manufacturer and model names..? If there is an already existing entry in PC then the catalog mappings will not work.

           

          try the following steps (may be for a small set of CIs)

           

          • Turn on "Create New PC Entry". This will be required as a new product catalog entry (mapped categorization from the Catalog Mappings) will be created first
          • turn off inline normalization
          • delete the already created entry from "Product Catalog Advanced Search" form (An entry will be created automatically)
          • create entries on the NE:ProductNameAlias form
          • re-check the catalog mappings created.
          • re run the normalization job

           

          if there are no manufacturer name and model name details for the CIs then create a entry BMC_UNKNOWN in the NE:ProductNameAlias form before executing the normalization job

           

           

          thanks.

          • 2. Re: CataLog Mapping in Normalization
            Abhijit Valvekar

            Hi,

             

            I would suggest three option –

             

             

            1.       Sometime its needed AR server restart to changes taking place first so try with this option

             

            2.       You can also use Product Catalog Alias mapping form to map your discovered CIs

             

            3.       Create alias entries in NE:ProductNameAlias form, this option definitely work for your use case

             

            Thanks and Regards,

            Abhijit Valvekar

            • 3. CataLog Mapping in Normalization
              Rahul Priyadarshy

              Hi Amey & Abhijit,

               

              Thanks a lot for ur reply. Seems that what i was trying to do is working with the help of ur answer/suggestion.

               

              I did below to acheive this-

              (1) Delete all PC entry which was created by Normalization Engine

              (2) created alisa model and Manufacturer in NE Product Alias form

              (3) Created/Modified Catalog Mapping from Normalization Engine Console

              (4) Inline normalization enabled,PC craetion enable in Normalization engine configuration

              (5) Re-Started  AIE Service

              (6) Re-Started Ar Server

              (8) Re Ran AIE Jobs

               

              Data is coming now also Model and Manugacturer names are getting converted too. I have one more query.

              It seems that  Aliaing and Catalog Mapping both steps are necessary.

               

              Regards

              Rahul P

              • 4. Re: CataLog Mapping in Normalization
                Abhijit Valvekar

                HI Rahul,

                 

                You don’t need entries in both the forms.

                 

                If you do have entry in NE:ProductNameAlias form then you don’t need to be entries in Product Catalog Mapping.

                 

                Thanks and Regards,

                Abhijit Valvekar

                • 5. Re: CataLog Mapping in Normalization
                  Josie George

                  Hi,

                  The aliases in NE:ProductNameAlias table is considered when normalization type is Name+Cti and the aliases in catalog mapping form is considered when the normalization type is cti only.

                   

                  Regards,

                  Josie George

                  • 6. CataLog Mapping in Normalization
                    Amey Bagwe

                    Hi Abhijit,

                     

                    Only having entriers in the NE:ProductNameAlias form does not help. Catalog Mappings are necessary in case you wish to replace CTIs in target CIs.

                     

                    Can you please explain the scenario you are talking about.

                     

                    thanks.

                    • 7. Re: CataLog Mapping in Normalization
                      Abhijit Valvekar

                      Hi Amey,

                       

                       

                      1.       If you want to replace only Manufacturer Name and Product Name values then it does not requires entries in Catalog Mapping and

                       

                      2.        When you wish to replace the CTI values then entries needed in Catalog Mapping as well as in Alias.

                       

                      Thanks and Regards,

                      Abhijit Valvekar

                      • 8. Re: CataLog Mapping in Normalization
                        Amey Bagwe

                        Hi Abhijit,

                         

                        If I wish to replace the manufacturer name and model name then the values which need to be applied in the target CI will be provided in the "catalog mappings" right..?

                         

                        Is there any other way to replace the manf name and model name..? without creating catalog mappings..?

                         

                        thanks.

                        • 9. Re: CataLog Mapping in Normalization
                          Abhijit Valvekar

                          Hi Amey,

                           

                          Scenario 1 :

                           

                          Normalization Type – Name & CTI

                          If you wish to replace the values of Product Name and Manufacturer Name then create entry in NE:ProductNameAlias Form. This will only replace the Manufacturer Name and Product Name, CTI will update as per the Product catalog

                           

                          EG

                          Discovered CI-

                           

                          C - Software

                          T - Application

                          I – Third Part

                          Product Name – MS Office 2010

                          Manufacturer Name- MS Office

                           

                          NE:ProductNameAlias Form entries –

                           

                          ProductName-

                          Actual Name: Microsoft Office 2010

                          Alias Name : MS Office 2010

                           

                          Manufacturer –

                          Actual Name : Microsoft Office

                          Alias Name : MS Office

                           

                          In above case PN and MN will be replaced by Microsoft Office 2010 and Microsoft Office, CTI will not update (CTI will only update if there is any matching entry found in Product catalog)

                           

                          Scenario 2 :

                          Normalization Type – CTI

                          If you wish to replace the CTI values then only create catalog mapping.

                           

                          So the answer of your question is -“Is there any other way to replace the manf name and model name?”

                          Scenario #1

                           

                          Also please check the Josie’s reply.

                           

                          Thanks and Regards,

                          Abhijit Valvekar

                          • 10. Re: CataLog Mapping in Normalization
                            Amey Bagwe

                            Hi Abhijit,

                             

                            thanks for the description. I performed the following steps

                             

                            • created a CI, class BMC_Application, CTI -> Software +Application +Third Party, Product Name – MS Office 2010
                            • Manufacturer Name- MS Office.
                            • created only NE Product Name alias mappings,

                                      ProductName-

                                      Actual Name: Microsoft Office 2010

                                      Alias Name : MS Office 2010

                             

                                      Manufacturer –

                                      Actual Name : Microsoft Office

                                      Alias Name : MS Office

                             

                                      I have not created any entries in "catalog mappings", no entries exist in the product catalog either for the           above CTI combination.

                             

                            • created a normalization job, type ->Name & CTI Lookup, with "Allow new product catalog entry" = yes CI gets normalized "normalized and approved" with a new entry in product catalog. with "Allow new product catalog entry" = no CI does not get normalized "normalization failed". Also, in both the cases the PN and MN does not get replaced by Microsoft Office 2010 and Microsoft Office

                                    

                                      Message in Log File: Could not find any unique entry in the Product Catalog. Product Catalog Key: null,                                                  Model: MS Office 2010, Manufacturer: MS Office, Version: null, Patch: null

                            • If I create catalog mappings then only the PN MN gets changed.

                             

                            thanks.

                            • 11. Re: CataLog Mapping in Normalization
                              Josie George

                              Hi,

                               

                              The NE Product Name alias mappings created are not immdetialy reflected in NE Cache. If you need to see uitlize the mappings immediately then you would need a ar server restart which will reload the NE cache with the new mappings created, then these mappings will be taken into consideration when normalization a new CI. The Product Name and ManufacturerName of the CI will change as per the mappings provided.

                               

                              In the NE Product Name alias mapping form

                              Actual Name maps to  Product Name in Product Catalog &

                              Alias Name Maps to Model attribute in CI.

                               

                              Regards,

                              Josie George