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.

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 bytes

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