Forum Discussion

Valerio_S's avatar
Valerio_S
Level 3
11 years ago
Solved

OPS - create custom report by part of policy name

Hello everyone. 
I need to create a custom report that will give me information about the policies, using as search filter a part of the policy name. 
the problem is that if I insert the filter "policy => policy name => Conteins = _abd_" the generated report also includes policies that contain the name "_abdC_" or "_Cabd_" 
How can I make sure that the search includes only those policies that contain exactly the characters "_abd_"?

thanks and regards

 

Valerio

 

Edit: I edited this post...the example was wrong.

Backup and Recovery
OpsCenter
Windows Server (2003-2008)
  • Valerio_S's avatar
    Valerio_S
    11 years ago

    Yes Tom,
    And a solution was found:
    Whereas SQL calculates the "_" character not as a text character, to make sure that this character is considered "text" must be put in square brackets.
    example "[_]abc[_]"

    greetings

    Valerio

7 Replies

  • tom_sprouse's avatar
    tom_sprouse
    Level 6
    11 years ago

    Valerio,

    What version of OpsCenter are you running, and which platform?
    I will test this in a 7.6.0.3 lab running Windows 2008 x64, and let you know my results...using examples...

    • Policy_ab_Test
    • Policy_abc_Test
    • Policy_abcd_Test
    • Policy_abcde_Test
    • ------------------------------
    • Policy_abd_Test
    • Policy_abde_Test
    • Policy_abdef_Test
    • Policy_abx_Test

     

    --Tom

     

  • Valerio_S's avatar
    Valerio_S
    Level 3
    11 years ago

    OkTom,
    Tanks..

    -OPSCenter Analytics 7.6.0.1
    -Windows 2008 R2 E x64

    In the meantime, I do another example to explain the problem better:

    I have 6 policies:

    • Policy_abc_test
    • Lol_pes_test
    • Prod_fabc_test
    • Test_abc_policy
    • Rol_jki_test
    • Test_abct_cert

    If I apply at the Report the policyName filter |Contains"_abc_"| The results of report will be the seguents:

    • Policy_abc_test
    • Prod_fabc_test
    • Test_abc_policy
    • Test_abct_cert

    I would that results are these:

    • Policy_abc_test
    • Test_abc_policy

     

    Thanks

     

    Valerio

     

     

     

  • tom_sprouse's avatar
    tom_sprouse
    Level 6
    11 years ago

    Valerio,

    I do see your behavior, in my lab.

    It appears the underscore is acting as a wildcard character and returning additional results.

    I have tried multiple variants and continue to experience the behavior you described.

    Please open a case with our support team to have this reviewed by engineering.

    You can provide this forum thread to the TSE if needed, and they can contact me directly for any information needed for escalation.

    --Tom

     

  • tom_sprouse's avatar
    tom_sprouse
    Level 6
    11 years ago

    Valerio,

    Were you able to open a support case and have this reviewed by engineering / backline?

    --Tom

     

     

     

  • Valerio_S's avatar
    Valerio_S
    Level 3
    11 years ago

    Yes Tom,
    And a solution was found:
    Whereas SQL calculates the "_" character not as a text character, to make sure that this character is considered "text" must be put in square brackets.
    example "[_]abc[_]"

    greetings

    Valerio