meta data for this page
  •  

Különbségek

A kiválasztott változat és az aktuális verzió közötti különbségek a következők.

Összehasonlító nézet linkje

Előző változat mindkét oldalonElőző változat
Következő változat		Előző változat
shell:riportok:q_se [2024/11/06 17:59] – adminshell:riportok:q_se [2024/11/28 11:45] (aktuális) – admin
Sor 27: Sor 27:
 <WRAP prewrap> <WRAP prewrap>
 <file> <file>
-def scr q_se "SELECT SESSION_ID, substr(CLIENT_NAME,1,20) as NODE_NAME, substr(char(start_time),1,19) AS START_TIME,substr(char(days(current_timestamp) - days(start_time)),1,2) AS ""(D)"" ,substr(char((current_timestamp - start_time)hours),1,2) AS ""(HH)"", substr(char((current_timestamp - start_time)minutes),1,2) AS ""(MM)"", substr(STATE,1,10) as STATE,WAIT_SECONDS, cast(float(bytes_sent) /1024/1024 AS DEC(12,2)) AS ""Sent MB"", cast((cast(bytes_sent as dec(18,0))/cast(timestampdiff(2,char(current_timestamp-start_time)) as decimal(18,0))) / 1024 / 1024 AS DEC (10,2)) AS ""Sent MB/s"",cast(float(bytes_received) /1024/1024 AS DEC(10,2)) AS ""Rec. MB"", cast((cast(bytes_received as dec(18,0))/cast(timestampdiff(2,char(current_timestamp-start_time)) as decimal(18,0))) / 1024 / 1024 AS DEC (10,2)) AS ""Rec. MB/s""  FROM sessions WHERE SESSION_TYPE='Node'"+DEFINE SCRIPT  Q_SE "SELECT SESSION_ID, substr(CLIENT_NAME,1,20) as NODE_NAME, substr(char(start_time),1,19) AS START_TIME,TRANSLATE('a bc:de:fg', DIGITS(current_timestamp - start_time), '_______abcdefgh_____',' ') as RUNTIME, substr(STATE,1,10) as STATE,WAIT_SECONDS, cast(float(bytes_sent)/1024/1024 AS DEC(12,2)) AS ""Sent MB"", cast((cast(bytes_sent as dec(18,0))/cast(timestampdiff(2,char(current_timestamp-start_time+1)) as decimal(18,0))) / 1024 / 1024 AS DEC (10,2)) AS ""Sent MB/s"",cast(float(bytes_received) /1024/1024 AS DEC(10,2)) AS ""Rec. MB"", cast((cast(bytes_received as dec(18,0))/cast(timestampdiff(2,char(current_timestamp-start_time+1)) as decimal(18,0))) / 1024 / 1024 AS DEC (10,2)) AS ""Rec. MB/s""  FROM sessions WHERE SESSION_TYPE='Node'"
 </file> </file>
 </WRAP> </WRAP>