10 VLR Tables
This provides the details of VLR tables.
Note:
FTRA cannot determine if EAGLE supports SFAPP. Hence, the csv report of rtrv-vlr-prof and rtrv-vlr-roaming commands is only generated through FTRA, when user manually adds the commands in FTRA.10.1 VLR-PROF (rtrv-vlr-prof)
The report lists all the attributes of VLR_PROF table.
Output content refers to rtrv-vlr-prof in the Table 10-1.
Table 10-1 Output Content for rtrv-vlr-prof
| Field Name | Description | Data |
|---|---|---|
| VLRIDX | VLR index | Integer |
| VLRNb | VLR Number | ASCII TEXT |
| FILTER | Filter on VLR table (allowlist/blocklist) | ASCII TEXT |
| AGEOFLOC | Whether age of location is supported | ASCII TEXT |
| LASTUEACTIVITY | Whether last activity is supported | ASCII TEXT |
| REFCNT | Number of times the entry is referenced | Integer |
Example output file: vlr_prof_20170624_0311
Abbreviated example output file format:
CLLI,SWREL,DBLEVEL,DBDATE,DBTIME,RPTDATE,RPTIME,TZ,RPTDATA,NUMENTRIES,MAXENTRIES,PCNTFULL
tekelecstp,,4,6/24/2017,3:11:24,6/24/2017,3:12:55,IST,VLR PROFILES,2,50001,1%
VLRIDX,VLRNb,FILTER,AGEOFLOC,LASTUEACTIVITY,REFCNT
1,12345,whitelist ,no ,no ,1
2,56780,whitelist ,no ,no ,1
Maximum File Size
System header + Report header + Report data
250 + 62 + 62 X 50000 = 3,100,312 bytes10.2 VLR-ROAMING (rtrv-vlr-roaming)
The report lists all the attributes of VLR_ROAM table.
Output content refers to rtrv-vlr-roaming in the Table 10-2.
Table 10-2 Output Content for rtrv-vlr-roaming
| Field Name | Description | Data |
|---|---|---|
| OLD_VLR | The logical name of the device associated with the indicated IP address | ASCII TEXT |
| NEW_VLR | The IP address associated with the hostname. | ASCII TEXT |
| TIME | Realm associated with the diameter hostname. Diameter hostname are those hostnames specified by associations with adapter = DIAM. | ASCII TEXT |
Example output file: vlr_roaming_20170624_0311
Abbreviated example output file format:
"CLLI","SWREL","DBLEVEL","DBDATE","DBTIME","RPTDATE","RPTIME","TZ","RPTDATA","NUMENTRIES","MAXENTRIES","PCNTFULL"
"tekelecstp","","4","2017-06-24","03:11:24","2017-06-24","03:12:55","IST","VLR ROAMING","1","1000001","1%"
"OLD_VLR","NEW_VLR","TIME"
"56780","12345","10"
Maximum File Size
System header + Report header + Report data
250 + 27 + 45X1000000 = 45,000,277 bytes