4.7.1 Query elements

The SDS Maintenance Query page consists of query entry dialogue boxes and results display. Not all elements of the entry dialogue boxes or query results may be used once the Data type is selected. All elements available through Query entry dialogue boxes are presented in Table 4-19. All elements available through Query results display, in alphabetical order, are presented in Table 4-20.

Table 4-19 Query Entry Elements

Element Description Data Input Notes
Data Type of data to include in query

Format: list

Range: MSISDN, IMSI, MSISDN Prefix, IMSI Prefix, MSISDN Blacklist, IMSI Blacklist, NAI Host, NAI User, Wildcard NAI User, Destination, Counts, Counts by Destination, DB Level

Default: MSISDN

Start Address Starting address of data to be included in this query (applies to MSISDN, IMSI, MSISDN Prefix, IMSI Prefix, MSISDN Blacklist and IMSI Blacklist query requests only)

Format: digits only

Range: 8 - 15 digits for MSISDN or MSISDN Blacklist, 10 - 15 for IMSI or IMSI Blacklist, 1 - 15 for MSISDN or IMSI Prefix

End Address Ending address of data to be included in this query (applies to MSISDN, IMSI, MSISDN Prefix, IMSI Prefix, MSISDN Blacklist and IMSI Blacklist query requests only)

Format: digits only

Range: 8 - 15 digits for MSISDN or MSISDN Blacklist, 10 - 15 for IMSI or IMSI Blacklist, 1 - 15 for MSISDN or IMSI Prefix

Default: blank

NAI Host NAI Host to query applies to NAI users only NAI Host defaults to the first one configured in the table.
Server Server on which to run the query

Format: alphanumeric

Range: up to 35 characters

Default: local server

Table 4-20 Query Results Elements

Result Element Description Data Value Selected
AAA AAA Destination record (with type= aaa) or blank for none MSISDN, IMSI, NAI User, Wildcard NAI User, MSISDN Prefix, IMSI Prefix
DB Level Numeric value of Database level DB Level
Destination(s) Unique text used to identify a Destination Counts, Counts by Destination
External Identifier Number of subscribers with external identifiers Counts, Counts by Destination
FQDN A 1-255 character string for the Diameter FQDN for the Destination. The value can be null Destination
Host A unique string of 1 -64 characters for NAI Host Name NAI User, Wildcard NAI User, NAI Host
IMSI(s) A unique string of 10-15 decimal digits identifying the IMSI IMSI, Counts, Counts by Destination
IMSI Blacklist A unique string of 10-15 decimal digits identifying the IMSI Blacklist value IMSI Blacklist, Counts
IMSI Prefix A unique string of 1-15 decimal digits identifying the IMSI Prefix IMSI Prefix, Counts, Counts by Destination
IMS HSS IMS HSS Destination record (with type= imsHss) or blank for none MSISDN, IMSI, NAI User, Wildcard NAI User, MSISDN Prefix, IMSI Prefix
LTE HSS LTE HSS Destination record (with type= lteHss) or blank for none MSISDN, IMSI, NAI User, Wildcard NAI User, MSISDN Prefix, IMSI Prefix
MSISDN(s) A unique string of 8-15 decimal digits identifying the MSISDN MSISDN, Counts, Counts by Destination
MSISDN Blacklist A unique string of 8-15 decimal digits identifying the MSISDN Blacklist value MSISDN Blacklist, Counts
MSISDN Prefix A unique string of 1-15 decimal digits identifying the MSISDN Prefix MSISDN Prefix, Counts, Counts by Destination
MTC HSS MTC HSS Destination record (with type-mtcHss) or blank for none MSISDN, IMSI, NAI User, Wildcard NAI User, MSISDN Prefix, IMSI Prefix
NAI Host Number of NAI hosts Counts
NAI User A string of 1-64 characters for the NAI User Name NAI User, Counts, Counts by Destination
Name A unique string of 1-32 characters to identify the Destination Destination
OCS OCS Destination record (with type= ocs) or blank for none MSISDN, IMSI, NAI User, Wildcard NAI User, MSISDN Prefix, IMSI Prefix
OfCS OFCS Destination record (with type= ofcs) or blank for none MSISDN, IMSI, NAI User, Wildcard NAI User, MSISDN Prefix, IMSI Prefix
PCRF PCRF Destination record (with type= pcrf) or blank for none MSISDN, IMSI, NAI User, Wildcard NAI User, MSISDN Prefix, IMSI Prefix
Realm A 1-255 character string for the Diameter Realm for the Destination. The value can be null Destination
Type Destination type Destination
USERDEF1 UserDef1 Destination record (with type= userDef1) or blank for none MSISDN, IMSI, NAI User, Wildcard NAI User, MSISDN Prefix, IMSI Prefix
USERDEF2 UserDef2 Destination record (with type= userDef2) or blank for none MSISDN, IMSI, NAI User, Wildcard NAI User, MSISDN Prefix, IMSI Prefix
Wildcard NAI User A string of 1-64 characters for the wild carded NAI User Name. Wildcard NAI User, Counts, Counts by Destination