cancel
Showing results for 
Search instead for 
Did you mean: 

OPS - create custom report by part of policy name

Valerio_S
Level 3
Partner Accredited

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Valerio_S
Level 3
Partner Accredited

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

View solution in original post

7 REPLIES 7

tom_sprouse
Level 6
Employee Accredited Certified

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
Level 3
Partner Accredited

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
Level 6
Employee Accredited Certified

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

 

Valerio_S
Level 3
Partner Accredited

Ok Tom,

Many thanks!

tom_sprouse
Level 6
Employee Accredited Certified

Valerio,

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

--Tom

 

 

 

Valerio_S
Level 3
Partner Accredited

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

tom_sprouse
Level 6
Employee Accredited Certified

Valerio,

Thank you for the update... great information.... 

---Tom