How to monitor if a meta index key is full in the NetWitness Platform
Issue
Each meta key that is indexed in the RSA NetWitness Platform has a valueMax value associated with it. This is the maximum number of unique values that can be stored in the index for this meta key.This is defined in the index-concentrator.xml and index-concentrator-custom.xml values on a Security Analytics concentrator.
For example:
If this value is exceeded, then the additional unique values will not be able to be seen when investigating, although it will still be recorded in the session information.
It is therefore important to be alerted if the index for the meta key is full.
In some cases, the number of unique values for a key may exceed any setting of ValueMax that is used. For example, if you were to index URLs seen by the system then the index for this meta key would become quickly full due to the large number of unique possible values. For source ports and destination ports for a TCP session then there is a maximum of 65536 possible values so the valueMax is set to this value.
When a meta key is full the following will be seen in /var/log/messages on the concentrator:Tasks
We wish to be alerted if a metakey becomes full so that we can plan accordingly. To do this1. Install the RSA Security Analytics Parsers from RSA Link here: Live Services Management Guide for 12.5.1
2. Add the following message to the RSA Security Analytics parser above the tag.
level="1"
parse="1"
parsedefvalue="1"
tableid="1"
id1="Index:45"
id2="Index"
eventcategory="1612010000"
content="<@event_description:Index Key Full>[warning] Index key <metakey> has reached max capacity of <fld2> values and will ignore new values for this slice."/>
4. Add the following to your Log Decoder at /etc/netwitness/ng/envision/etc/table-map-custom.xml
5. When the Index Key becomes full the event description "Index Key Full" will become populated.
percentage used. Note: Horizontal is not compatible with appendHeaders.
Resolution
If an index key does become full then there are several options.
- Create more index slices
- Increase the valueMax value for the IndexKey
- Switch off indexing for the key
- Do nothing - it may not be practical to capture all unique values for the key or it may be that all possible unique values have been captured.
The best option will depend on your environment and what you wish to achieve, so please contact RSA Customer Support if further advice is required.
Attached to this article is a pair of scripts to help report on your current index slices. Please note the index-profile.pl script is meant for 10.X releases while the
index-profile.py is meant for 11.X releases. Please download and follow the instructions of the one that best fits your environment.
For Customers using version 10.X:
Please use the index-profile-10.X.zip file. This contains a perl script.
Usage: ./index-profile.pl concentrator_ip [out_file_name]
For example, to take an index profile snapshot every 30 min create a cron job for every concentrator as follows:
0,30 * * * * /root/index-profile-1.2.pl <Concentrator1_IP> index-snap-1.csv >> index-snap-1.csv
# Concentrator 2
0,30 * * * * /root/index-profile-1.2.pl <Concentrator2_IP> index-snap-2.csv >> index-snap-2.csv
This will generate a CSV file which then can be easily analyzed, so the optimal values of ValueMax, save.session.count or the index save scheduler can be worked out.
The sample output:
- Column 1: Session
- Column 2: sourcefile
- Column 3: sinterface
- Column 4: content
- Column 5: policy.name
- Column 6: device.name
- Column 7: email
- Column 8: tld
- Column 9: city.src
- Column 10: alias.host
- Column 11: category
- Column 12: udp.srcport
- Column 13: event.computer
- Column 14: country.src
- Column 1: 9472259
- Column 2: 0.00%
- Column 3: 0.00%
- Column 4: 0.00%
- Column 5: 4.45%
- Column 6: 0.00%
- Column 7: 0.00%
- Column 8: 0.00%
- Column 9: 4.65%
- Column 10: 2.81%
- Column 11: 5.87%
- Column 12: 0.00%
- Column 13: 0.10%
- Column 14: 2.13%
- Column 1: 26421267
- Column 2: 0.00%
- Column 3: 0.00%
- Column 4: 0.00%
- Column 5: 9.58%
- Column 6: 0.00%
- Column 7: 0.00%
- Column 8: 0.00%
- Column 9: 6.70%
- Column 10: 5.43%
- Column 11: 7.23%
- Column 12: 0.00%
- Column 13: 0.10%
- Column 14: 2.38%
- Column 1: 18719236
- Column 2: 0.00%
- Column 3: 0.00%
- Column 4: 0.00%
- Column 5: 8.11%
- Column 6: 0.00%
- Column 7: 0.00%
- Column 8: 0.00%
- Column 9: 6.30%
- Column 10: 4.20%
- Column 11: 6.66%
- Column 12: 0.00%
- Column 13: 0.10%
- Column 14: 2.40%
- Column 1: 33624165
- Column 2: 0.00%
- Column 3: 0.00%
- Column 4: 0.00%
- Column 5: 13.62%
- Column 6: 0.00%
- Column 7: 0.00%
- Column 8: 0.00%
- Column 9: 7.69%
- Column 10: 6.38%
- Column 11: 7.70%
- Column 12: 0.00%
- Column 13: 0.10%
- Column 14: 2.55%
- Column 1: 48796236
- Column 2: 0.00%
- Column 3: 0.00%
- Column 4: 0.00%
- Column 5: 0.00%
- Column 6: 0.00%
- Column 7: 0.00%
- Column 8: 0.00%
- Column 9: 0.00%
- Column 10: 0.00%
- Column 11: 0.00%
- Column 12: 0.00%
- Column 13: 0.00%
- Column 14: 0.00%
- Column 1: 62908505
- Column 2: 0.00%
- Column 3: 0.00%
- Column 4: 0.00%
- Column 5: 32.48%
- Column 6: 0.00%
- Column 7: 0.00%
- Column 8: 0.00%
- Column 9: 9.54%
- Column 10: 9.91%
- Column 11: 8.94%
- Column 12: 0.00%
- Column 13: 0.10%
- Column 14: 2.71%
- Column 1: 76682159
- Column 2: 0.00%
- Column 3: 0.00%
- Column 4: 0.00%
- Column 5: 40.05%
- Column 6: 0.00%
- Column 7: 0.00%
- Column 8: 0.00%
- Column 9: 10.34%
- Column 10: 11.36%
- Column 11: 9.39%
- Column 12: 0.00%
- Column 13: 0.10%
- Column 14: 2.78%
- Column 1: 88894056
- Column 2: 0.00%
- Column 3: 0.00%
- Column 4: 0.00%
- Column 5: 44.02%
- Column 6: 0.00%
- Column 7: 0.00%
- Column 8: 0.00%
- Column 9: 11.11%
- Column 10: 12.70%
- Column 11: 9.73%
- Column 12: 0.00%
- Column 13: 0.10%
- Column 14: 2.81%
- Column 1: 100426583
- Column 2: 0.00%
- Column 3: 0.00%
- Column 4: 0.00%
- Column 5: 50.97%
- Column 6: 0.00%
- Column 7: 0.00%
- Column 8: 0.00%
- Column 9: 11.59%
- Column 10: 13.84%
- Column 11: 10.04%
- Column 12: 0.00%
- Column 13: 0.10%
- Column 14: 2.84%
- Column 1: 115804180
- Column 2: 0.00%
- Column 3: 0.00%
- Column 4: 0.00%
- Column 5: 57.16%
- Column 6: 0.00%
- Column 7: 0.00%
- Column 8: 0.00%
- Column 9: 12.19%
- Column 10: 15.27%
- Column 11: 10.38%
- Column 12: 0.00%
- Column 13: 0.10%
- Column 14: 2.86%
- Column 1: 129613715
- Column 2: 0.00%
- Column 3: 0.00%
- Column 4: 0.00%
- Column 5: 65.50%
- Column 6: 0.00%
- Column 7: 0.00%
- Column 8: 0.00%
- Column 9: 12.68%
- Column 10: 16.49%
- Column 11: 10.65%
- Column 12: 0.00%
- Column 13: 0.10%
- Column 14: 2.89%
- Column 1: 141790056
- Column 2: 0.00%
- Column 3: 0.00%
- Column 4: 0.00%
- Column 5: 68.83%
- Column 6: 0.00%
- Column 7: 0.00%
- Column 8: 0.00%
- Column 9: 13.14%
- Column 10: 17.69%
- Column 11: 10.95%
- Column 12: 0.00%
- Column 13: 0.10%
- Column 14: 2.93%
- Column 1: 153489616
- Column 2: 0.00%
- Column 3: 0.00%
- Column 4: 0.00%
- Column 5: 72.53%
- Column 6: 0.00%
- Column 7: 0.00%
- Column 8: 0.00%
- Column 9: 13.53%
- Column 10: 18.86%
- Column 11: 11.12%
- Column 12: 0.00%
- Column 13: 0.10%
- Column 14: 2.94%
- Column 1: 161713547
- Column 2: 0.00%
- Column 3: 0.00%
- Column 4: 0.00%
- Column 5: 74.81%
- Column 6: 0.00%
- Column 7: 0.00%
- Column 8: 0.00%
- Column 9: 13.77%
- Column 10:
Product Details
RSA Product Set: Security Analytics, NetWitness Logs & Network
RSA Product/Service Type: Concentrator, Log Decoder
Platform: CentOS 6, CentOS 7
Approval Reviewer Queue
Technical approval queue
Attachments:
index-profile-10.X.zip