09-09-2014 03:32 AM
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.
Solved! Go to Solution.
09-25-2014 03:28 AM
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
09-09-2014 05:04 AM
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...
--Tom
09-09-2014 05:48 AM
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:
If I apply at the Report the policyName filter |Contains"_abc_"| The results of report will be the seguents:
I would that results are these:
Thanks
Valerio
09-09-2014 09:17 AM
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
09-10-2014 05:19 AM
Ok Tom,
Many thanks!
09-24-2014 11:54 AM
Valerio,
Were you able to open a support case and have this reviewed by engineering / backline?
--Tom
09-25-2014 03:28 AM
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
09-26-2014 12:17 PM
Valerio,
Thank you for the update... great information....
---Tom