Example: TDWM.WorkloadInfoV - Teradata VantageCloud Lake

This example lists existing workloads in the ruleset 'FirstConfig' and their attributes.

Query

SELECT WorkloadId, WorkloadName, WorkloadType AS WDType, 
       WorkloadStatus AS Status, WorkloadEvalOrder AS EvalOrder, 
       WorkloadDescription AS Description
  FROM TDWM.WorkloadInfoV 
 WHERE RulesetName = 'TestConfig' 
ORDER BY WorkloadEvalOrder;

Output

 WorkloadId  WorkloadName      WDType     Status  EvalOrder  Description
-----------  ---------------   ---------  ------  ---------  ------------------------------------
         13  WD-MapsMover      TSHigh     E               1
        683  TDaaS_Critical    SLG1       E               2  SLG Tier 1 for TDaaS users
        682  TDaaS_Important   SLG2       E               3  SLG Tier 2 for TDaaS users
        681  TDaaS_High        TSHigh     E               4  Timeshare High for TDaaS users
        680  TDaaS_Low         TSLow      E               5  Timeshare Low WD for TDaaS users
        679  TDaaS_Medium      TSMed      E               6  Timeshare Medium for TDaaS users
         15  T-WD              TSTop      E               7
         16  H-WD              TSHigh     E               8
         17  M-WD              TSMed      E               9
         18  L-WD              TSLow      E              10
         48  Tactical-WD       Tactical   E              11  Default Tactical WD for AcctStr $TA*
         52  TC                Tactical   E              12  Default Tactical WD for total EPT 
         51  TT                TSTop      E              13  Default Timeshare Top WD for ... 
         50  MM                TSMed      E              14  Default Timeshare Medium WD for ... 
         49  LL                TSLow      E              15  Default Timeshare Low WD for ... 
         14  WD-Default        TSMed      E              16