pbianchino Absent Member.
Absent Member.
862 views

Storing float numbers in Sentinel


Hi all, we are having the following situation: We are developing a
Collector to audit data from a financial application through a text
file. This file contains fields in float numeric format so the problem
is that, as far as we know, there is not float customer variable in
Sentinel (we only found numeric/integer format variables) to store this
value in order to operate with it.

In this context, is there a way to store in sentinel db float numbers?
What would be the best practice to do this?

Thanks in advance,
Kind regards.


--
pbianchino
------------------------------------------------------------------------
pbianchino's Profile: https://forums.netiq.com/member.php?userid=1993
View this thread: https://forums.netiq.com/showthread.php?t=57078

0 Likes
6 Replies
Knowledge Partner
Knowledge Partner

Re: Storing float numbers in Sentinel

See response in the Sentinel forum; I do not know of any float fields, but
string fields are abundant.


--
Good luck.

If you find this post helpful and are logged into the web interface,
show your appreciation and click on the star below...
0 Likes
brandon-langley Absent Member.
Absent Member.

Re: Storing float numbers in Sentinel

ab;2446940 wrote:
See response in the Sentinel forum; I do not know of any float fields, but
string fields are abundant.


--
Good luck.

If you find this post helpful and are logged into the web interface,
show your appreciation and click on the star below...


Assuming you are on Sentinel 7.4, you can use CV201 through CV205 to store Floating-point numbers. Also, if you need larger-number precision to store byte values, there are now three fields for input, output, and total bytes - also in 7.4 and newer.
0 Likes
pbianchino Absent Member.
Absent Member.

Re: Storing float numbers in Sentinel


Hi Brandon, thanks a lot for the information! I actually didn't know the
existence of these fields. In this context, I have two new questions:

1. How do you know the fields CV201 to CV205, I mean, If I check on the
below link, the last Customer Variable is CV200, so I assume the site
must be not updated, correct? Do you know if there is another web page
where we can see all last Sentinel variables version?

https://www.novell.com/developer/plugin-sdk/event_schema.html

2. Have you tested this floating variables in Sentinel (Lucene) queries
for range conditions [ ] {}. In example, if we use cv201:[1.5 TO 7.5],
do you know if this works fine?

Thanks in advance,
Regards


--
pbianchino
------------------------------------------------------------------------
pbianchino's Profile: https://forums.netiq.com/member.php?userid=1993
View this thread: https://forums.netiq.com/showthread.php?t=57078

0 Likes
brandon-langley Absent Member.
Absent Member.

Re: Storing float numbers in Sentinel

pbianchino;2447805 wrote:
Hi Brandon, thanks a lot for the information! I actually didn't know the
existence of these fields. In this context, I have two new questions:

1. How do you know the fields CV201 to CV205, I mean, If I check on the
below link, the last Customer Variable is CV200, so I assume the site
must be not updated, correct? Do you know if there is another web page
where we can see all last Sentinel variables version?

https://www.novell.com/developer/plugin-sdk/event_schema.html

2. Have you tested this floating variables in Sentinel (Lucene) queries
for range conditions [ ] {}. In example, if we use cv201:[1.5 TO 7.5],
do you know if this works fine?

Thanks in advance,
Regards


--
pbianchino
------------------------------------------------------------------------
pbianchino's Profile: https://forums.netiq.com/member.php?userid=1993
View this thread: https://forums.netiq.com/showthread.php?t=57078


1) The best place to look at the schema is in the sentinel UI by going to the upper-right hand corner and looking at 'tips' - this will list the schema available to that instlalation.

2) I don't....I'd like to assume that it will work as intended, but if you see different please open an issue on it.
0 Likes
pbianchino Absent Member.
Absent Member.

Re: Storing float numbers in Sentinel


Thanks a lot for your help Brandon! I'll check point 2 and if it is
necessary (hope it isn't) I'll open an issue.
Regards


--
pbianchino
------------------------------------------------------------------------
pbianchino's Profile: https://forums.netiq.com/member.php?userid=1993
View this thread: https://forums.netiq.com/showthread.php?t=57078

0 Likes
pbianchino Absent Member.
Absent Member.

Re: Storing float numbers in Sentinel


Thanks for your feedback ab!


--
pbianchino
------------------------------------------------------------------------
pbianchino's Profile: https://forums.netiq.com/member.php?userid=1993
View this thread: https://forums.netiq.com/showthread.php?t=57078

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.