TSP Lab	Sga-MAP Query Server	Sga-MAP_CDR-QueryServer

The MAP CDR Query Server
`("Sga-MAP_CDR-QueryServer")`

Basic Operation

Reads CDR database
Uses authentication to ensure that clients only with proper right can initiate a query
Receives and serves queries from the SGA CDR Viewer client module
Uses Sga_CDR-QueryFilter.dll for CDR filtering
Logs connections, queries and database file operations
Can decrypt records if CDR Database is encrypted

Menu	Menuitem	Shortcut(s)	Meaning
[Log]
	Find line containing...	(Ctrl-F)	Finds text in log window
	Find next matching line	(F3)	Finds next occurrence of text in log window
	Details		Detail level of logging (Off, Normal, Detailed, or Debug). Note: F12 key sets log detail level to 'Off'.
[Actions]
	Allow client connection	(Ctrl-A, or )	Allow `CDR Query` clients to connect and query
	Flush counters		Writes status line counters into the log
	Flush & reset counters		Writes the counters into the log and zeroes them
[Options]
	Auto scroll	(ScrollLock, or )	Allow automatic scrolling of the log screen
	Save settings		Save actual settings into the configuration (`Sga-MAP_CDR-QueryServer.ini`) file

Data avail.: Indicates how many days of data available
GMT: 2020.03.10. 12:00 -- 2021.02.12. 12:00: Shows the time of the latest and the newest available data files
Uptime: time elapsed since module has been started up;
- Hovering over: start date and time
- left-click: kernel and user time
- righ-click: put a line into the log with the used DLL's and their versions
Clients: Number of clients currently connected
Statistics about requests, record checkings and results

Section	Entry	Example	Meaning
[Position]
	iLeft	140	Position of the program module on the display screen
	iTop	72	Position of the program module on the display screen
	iWidth	995	Position of the program module on the display screen
	iHeight	694	Position of the program module on the display screen
[Options]
	bAutoScroll	True	(Refer to the `[Options]/Auto scroll` menuitem!)
[Sga-7N Authorizer]
	sRemoteIPaddress	40.30.20.10	IP address of the SgaAutho module
	sQSuserName	$QS-MAP$	Used as the QS identifier while retrieving Oracle ("client") password from the SgaAutho module
[Advanced]
	wLogDetailLevel	3	(Equals to the listed order; refer to the `[LOG]/Details menuitem!)`
	dwMaxLinesInLogWindow	1000	Number of lines in the log window on screen
	sDataPath	d:\MAPCDR	Path for MAP CDR files
	wDataFilePeriod	15	Period of MAP CDR files. It should be the same value as `Sga-MAP_CDR-Assembler.ini/[Advanced]/wOutFilePeriod`.
	sLogFilesPath	d:\LogFiles	Path for the LOG files
	sDataFileIndices	IMSI,MSISDN	List of indices where the Query Server would look for existing entry.
	sLocalIPAddress	10.20.30.78	Optional local IP address setting
	wLocalTCPport	7799	TCP port for the incoming connections
	sCaption	MSS1_MAP	Alternative caption text for easy distinguishing amongst multiple instances of this module
	dwQueryIntervalSec	31536000	CDR's are available for this time interval back from the current time

v0.92

(c) Retrieve password from the "SGA-7N / Authorizer", see INI / [Sga-7N Authorizer] section for details.
(n) New INI entries:
- [Sga-7N Authorizer]/sRemoteIPaddress
- [Sga-7N Authorizer]/sQSuserName
(c) INI/[Advanced]/sClientPassword entry removed
(c) [Actions]/Re-enter client password menu item removed

v0.91

(n) Automatic handling of DAT files generated with different time period (e.g., 5 min, 15 min) settings.

v0.90