Hi
I am trying to use examples given with Single Value Decorations, but i am not able to get it working correctly. Every example is given with searchString:
<searchString>| stats count as value | eval value = 550 | rangemap field=value none=0-99 low=100-199 guarded=200-299 elevated=300-399 high=400-499 severe=500-599 default=none</searchString>
When I try to use it with my simple "search", it doesn't work
<dashboard stylesheet="single_decorations.css">
<label>test</label>
<row>
<panel>
<title>test</title>
<single>
<search>
<query> | dbquery ORACLE_SVCM "SELECT count(problems) FROM db1 WHERE STATUS!='closed''" </query>
| stats count as value | eval value | rangemap field=value none=0-99 low=100-199 guarded=200-299 elevated=300-399 high=400-499 severe=500-599 default=none
<earliest>0</earliest>
<option name="classField">range</option>
<option name="field">value</option>
</search>
Anyone could give me some help to advance?
Hi jbuesco,
this makes no sense:
<query> | dbquery ORACLE_SVCM "SELECT count(problems) FROM db1 WHERE STATUS!='closed''" </query>
| stats count as value | eval value | rangemap field=value none=0-99 low=100-199 guarded=200-299 elevated=300-399 high=400-499 severe=500-599 default=none
The stats
part of the search is outside the query
tag. Since I don't have any of your events available I can only assume that the following might work for you:
<query>
| dbquery ORACLE_SVCM "SELECT count(problems) FROM db1 WHERE STATUS!='closed''"
| stats count as value
| rangemap field=value none=0-99 low=100-199 guarded=200-299 elevated=300-399 high=400-499 severe=500-599 default=none
</query>
Hope this helps ...
cheers, MuS