Web interface for SGA-DB

• Features
• Available data
• User interface
  • The user authentication page
  • The location information request page
  • The "IMEI↔IMSI↔MSISDN" request page
  • The IMSI prefix list
  • The operator prefix list

• Provides an easy-to-use web interface to access historical and current location data of subscribers
• Historical and current "IMSI↔MSISDN" and "IMEI↔IMSI" assigments can also be retrieved
• Requires user authentication
• Uses simple web technics so it can be used with any web browsers
• Location queries can be invoked for an IMSI value
• IMSI prefix name and operator prefix name lists are accessible

Data source system	Available data
2G CS ("BSSAP") 2G PS ("GPRS") 3G CS/PS ("RANAP") CS Fallback ("SGsAP") 4G PS ("S1AP")	Info date and time in local time IMSI value and operator name MSISDN IMEI Cell info event cell ID cell name
2G/3G roaming ("MAP")	Info date and time in local time IMSI value and operator name MSISDN IMEI VLR GT address operator name event result
4G roaming ("Diameter")	Info date and time in local time IMSI value and operator name MSISDN IMEI MME MME ID (mncXXX.mccXXX) operator name event result

Important: Due to regulatory reasons data at most back to 1 year (365 days) can be accessed.

User's Interface

Page elements

• User name, Password, Reason: User should use his/her credentials to access the location database service and give a reason of usage
• Log on: User can log on with the provided authentication data
• Reset: Empties input fields

Page elements

• Header
  • Log out 'username': User can leave the session by pressing this button
  • Switch to IMEI↔IMSI↔MSISDN queries: User can switch to the IMEI↔IMSI↔MSISDN queries page
  • Remaining time: Page expiration time is 15 minutes in case of user inactivity. Session remaining time is indicated
• Query inputs
  • IMSI: The subscriber's identifier for what the search will be done
  • from ... until: The beginning and the end of the time frame is defined. Exclamation marks set current time as the start/end time
  • 'EndOfDlg' events: End-Of-Dialog events can be included or excluded from the result
  • Search historical DB: Data are being looked up in the historical database
  • Search current info: Data are being looked up in the current info database
• Results
  • The table contains the available location data (for details see Available data section)
• Query executed in NN ms, found XX results: Status info about the search

The "IMEI↔IMSI↔MSISDN" request page

Page elements

• Header
  • Log out 'username': User can leave the session by pressing this button
  • Switch back to CellInfo DB queries: User can switch to the CellInfo DB queries page
  • Remaining time: Page expiration time is 15 minutes in case of user inactivity. This time show the remaining time
• Query inputs
  • IMSI or MSISDN or IMEI: User can define an IMSI or an MSISDN or an IMEI as the basis of the query
  • Search IMSI↔MSISDN: Press to find MSISDN / IMSI values for the given IMSI / MSISDN
  • Search IMSI↔IMEI: Press to find IMEI / IMSI values for the given IMSI / IMEI
• Results
  • The result table contain the available historical and current data
• Query executed in NN ms, found XX results: Status info about the search