TSP Lab	Sga-DiamS6 Query Server	DiamS6_CDR-QueryServer

Sga-DiamS6 Query Server
`("DiamS6_CDR-QueryServer")`

Basic operation
User interface
Configuration
Version history

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

User Interface

The main menu

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 (`DiamS6_CDR-QueryServer.ini`) file

The bottom status-line

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
- right-click: Put a line into the log with the used DLL and its version
Number of clients currently connected
Statistics about requests, record checking and finding

Configuration (DiamS6_CDR-QueryServer.ini) file settings

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-DiamS6$	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
	wDataFilesPeriod	15	Period of CDR files. It should be the same value as the one set in the CDR assembler's INI
	sDataFilesPath	d:\CDR	Path for CDR files
	sDataFileIndices	IMSI,MSISDN	List of indices where the Query Server would look for existing entry.
	sLocalIPAddress	10.111.0.110	This IP address is used where the module is listens to incoming
	wLocalTCPPort	7799	TCP port for the incoming connections
	dwQueryIntervalSec	31536000	CDR's are available for this time interval back from the current time
	dwMaxParallelWorkerThreadsPerQuery	8	Defines the number of threads used during non-indexed queries
	dwProcessAffinityMask	0xFFFFF	Sets the process affinity
	sCaption	DiamS6-CDR	Alternative caption text for easy distinguishing amongst multiple instances of this module
	sLogFilesPath	d:\LogFiles	Path for the LOG files

Version history

v0.97

(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.96

(n) Data file period can be modified for the saved records, the query server automatically detects and handles these changes.
(n) Non index-based queries can use multiple parallel threads and CPU cores (with optional limits for either of them) to provide more CPU-resource for the decryption and decompression processes.
(c) The optional configuration of the validity interval is replaced be the QueryInterval setting to limit the search intervals.
(n) ; The availability interval of data is shown in the status line, also printed into the log every quarter of an hour.
(n) The availability interval of data can also be remotely displayed in the "AutóZsóti" SW, as well as process heart-beats, uptime, etc.
(n) Checks existence of input (data) and output (log) folders at start-up.
(c) Password setting became the very last step of the start-up process.
(c) INI/[Validity Interval]/... → INI/[Advanced]/dwQueryIntervalSec
(c) INI/[Advanced]/sDataPath → sDataFilesPath
(c) INI/[Advanced]/wDataFilePeriod → wDataFilesPeriod
(n) INI/[Advanced]/dwMaxParallelWorkerThreadsPerQuery (default: use a maximum of 4 threads per query)
(n) INI/[Advanced]/dwProcessAffinityMask (default: use all)

v0.95

(n) Right mouse click prints version info for "Sga_CDR-QueryFilter.dll" into the log.

v0.94

(n) New record contents: 2*4 host and realm fields are added. (Old records are also maintained.)
(c) Record and hit counters in status line became QWORD instead of DWORD to avoid overflow.

v0.90

The initial release.

Sga-DiamS6 Query Server("DiamS6_CDR-QueryServer")

Table of Contents

Basic Operation

User Interface

The main menu

The bottom status-line

Configuration (DiamS6_CDR-QueryServer.ini) file settings

Version history

Sga-DiamS6 Query Server
`("DiamS6_CDR-QueryServer")`