CA Service Management

 View Only
  • 1.  Create a data partition

    Posted 18 days ago

    Hi everyone,

    I would like to create a data partition where the user can see the CI's from 3 different families or the CI's configured on user register (environment). 

    So, I tried this configuration:

    ((family.sym = 'Hardware.Estação de trabalho') AND (cntref.cnt =@root.id)) OR ((family.sym = 'Hardware.Impressora') AND (cntref.cnt =@root.id)) OR ((family.sym = 'Hardware.Monitor')) or cntref.cnt =@root.id

    But this condition result in a Cartesian product. 

    So, I tried this configuration: 

    ((family.sym = 'Hardware.Estação de trabalho' or family.sym = 'Hardware.Impressora' or family.sym = 'Hardware.Monitor') and (cntref.cnt =@root.id)) OR
    ((family.sym = 'Hardware.Estação de trabalho' or family.sym = 'Hardware.Impressora' or family.sym = 'Hardware.Monitor') and (cntref.cnt != @root.id)) 

    As can see below, It's saved without error:

    But when I try to search the CI's, none of them is showed. 

    Anyone has idea to solve this problem?  



    ------------------------------
    Regards,
    Felipe Nunes
    ------------------
    IT Analyst
    Prodabel
    ------------------------------


  • 2.  RE: Create a data partition

    Posted 17 days ago

    Hi,

    Try this :

    family.sym IN ('Hardware.Estação de trabalho', 'Hardware.Impressora', 'Hardware.Monitor') OR cntref.cnt IN (@root.id)

    Regards




  • 3.  RE: Create a data partition

    Posted 17 days ago

    Hi Jean,

    First of all, thank you for your replay.

    I tried as you suggested, but result in a Cartesian product. 



    ------------------------------
    Regards,
    Felipe Nunes
    ------------------
    IT Analyst
    Prodabel
    ------------------------------



  • 4.  RE: Create a data partition

    Posted 16 days ago

    Hello Felipe,

    Check these KD:

    https://knowledge.broadcom.com/external/article/15895

    https://knowledge.broadcom.com/external/article?articleId=50056



    ------------------------------
    Best regards.
    LinkedIn:
    https://pt.linkedin.com/in/thiago-23-oliveira
    ------------------------------



  • 5.  RE: Create a data partition

    Posted 11 days ago

    Hi @thiagooliveira,

    I've already seen this KD before open the case. 

    Thanks for you support.



    ------------------------------
    Regards,
    Felipe Nunes
    ------------------
    IT Analyst
    Prodabel
    ------------------------------



  • 6.  RE: Create a data partition

    Broadcom Employee
    Posted 17 days ago

    Hi,

    did you check the SQL statement if it realize what are you looking for?

    I hope this helps,

    Vito



    ------------------------------
    Vito Francesco Mazzotta
    Regional Technology Officer | EMEA South Italy
    Broadcom
    mobile: +39 335 8485131


    vitofrances.mazzotta@broadcom.com | broadcom.com

    linkedin.com/in/vito-francesco-mazzotta-802918
    ------------------------------



  • 7.  RE: Create a data partition

    Posted 11 days ago

    Hi Vito, 

    I don't know how to create de sql query for this condition. Has any idea? 



    ------------------------------
    Regards,
    Felipe Nunes
    ------------------
    IT Analyst
    Prodabel
    ------------------------------



  • 8.  RE: Create a data partition

    Posted 12 days ago

    Hi @Felipe Nunes,

    I think that exist a little bit complex way, as previously show example in the link below:

    Data partition generating a Cartesian product

    You should split the logic on 2 restrictions. Follow the link logic, can be implemented as:

    (cntref.cnt = @root.id) AND (family.sym = 'Hardware.Estação de trabalho')) OR
    ((cntref.cnt != @root.id) AND (family.sym = 'Hardware.Estação de trabalho')) OR
    ((cntref.cnt = @root.id) AND (family.sym != 'Hardware.Estação de trabalho'))

    AND second restriction:

    ((cntref.cnt = @root.id) AND (family.sym = 'Hardware.Impressora')) OR
    ((cntref.cnt != @root.id) AND (family.sym = 'Hardware.Impressora')) OR
    ((cntref.cnt = @root.id) AND (family.sym != 'Hardware.Impressora'))

    Case it's works fine, you can improve implementation for 1 restriction more complex. 



    ------------------------------
    Regards,
    Felipe Vandrilho

    Linkedin: https://www.linkedin.com/in/vandrilho/
    ------------------------------



  • 9.  RE: Create a data partition

    Posted 11 days ago

    Hi @Felipe V,

    First of all, thank you for your replay.

    I did as you suggested, and I could save the condition. But when I search for CI's, only shows one CI in my environment (And I have 3 CI's in my environment). 

    I don't know if I can do this. I will create another data partition and separate the condition. 



    ------------------------------
    Regards,
    Felipe Nunes
    ------------------
    IT Analyst
    Prodabel
    ------------------------------