meta data for this page
  •  

Keresés

A keresés eredményét lentebb láthatod.

Teljes szöveg:

TSM napi riport shell szkript @shell:riportok
43 Találatok, Utolsó módosítás:
as decimal(6,2))) as GB from nodes as nn, summary where (end_time between current_timestamp - 24 hours an... 24/1024/1024 as dec(12,2)) as \"GB\" FROM summary WHERE end_time>current_timestamp-24 hours and activity<... cc_time)) as \"LAST SEEN\" from EVENTS a, nodes b where (a.scheduled_start >=current_timestamp - 3 days) ... 4/1024 AS DEC(10,2)) AS \"Rec. MB\" FROM sessions WHERE SESSION_TYPE='Node' and (current_timestamp - star
Hasznos TSM SQL lekérdezések
80 Találatok, Utolsó módosítás:
uted in the following order: - FROM clause - WHERE clause - GROUP BY clause - HAVING clause - ... as "MGMT CLASS without OBJECTS" from mgmtclasses where class_name not in (select distinct class_name fro... select distinct node_name,class_name from backups where node_name='NODE' select distinct node_name,class_name from archives where node_name='NODE'</file> Megőrzési időkkel: SE
TSM kliens riport shell szkript @shell:riportok
3 Találatok, Utolsó módosítás:
okból veszi, aminek a formátuma: email cím; (sql WHERE feltétel az events, mint "e" táblából) order by <... tatus,1,11) end ) end as \"RESULT\" from events e where (current_timestamp - 24 hours)<e.scheduled_start ... cc_time)) as \"LAST SEEN\" from EVENTS e, nodes n where (e.scheduled_start >=current_timestamp - 3 days)
Szebb 'q session' kimenet @shell:riportok
2 Találatok, Utolsó módosítás:
only=y -commadel -displ=list -se=$TSMSERVER "$SQL WHERE SESSION_TYPE='Node'" | awk -F',' '{printf "%10s ... ) / 1024 / 1024 AS DEC (10,2)) AS ""Rec. MB/s"" FROM sessions WHERE SESSION_TYPE='Node'" </file> </WRAP>
Include-exclude használat @doksik_leirasok
1 Találatok, Utolsó módosítás:
2) cannot work? If you run 'select * from backups WHERE node_name='NODE NAME'', you will see the outputs