daily pastebin goal
14%
SHARE
TWEET

Untitled

a guest Feb 13th, 2018 75 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <form>
  2.    <label>L3 recreate model Activity</label>
  3.    <description>Lists the models in descending order of last time used in the L3 recreate workspaces and their sizes for archival purposes</description>
  4.    <fieldset submitButton="false"></fieldset>
  5.    <row>
  6.      <panel id="singleValuePanel1">
  7.        <title>Models in Selected Workspace Set</title>
  8.        <input type="dropdown" token="set" searchWhenChanged="true">
  9.          <label>Workspace Set</label>
  10.          <default>8a81948243cb6a7f0143d9ff2be97e34</default>
  11.          <initialValue>8a81948243cb6a7f0143d9ff2be97e34</initialValue>
  12.          <fieldForLabel>workspaceName</fieldForLabel>
  13.          <fieldForValue>workspaceGuid</fieldForValue>
  14.          <search>
  15.            <query>workspaceGuid=8a81b09c53248e3d0153f1cab02d7dc5 OR workspaceGuid=8a81948243cb6a7f0143d9ff2be97e34 OR workspaceGuid=8a819488482885c901483c882c6c4fa9 OR workspaceGuid=8a81b0945ef8a5c0015f255c3f8e44a2 | dedup workspaceGuid | stats count by workspaceGuid | lookup model-all workspaceGuid</query>
  16.            <earliest>-24h@h</earliest>
  17.            <latest>now</latest>
  18.          </search>
  19.        </input>
  20.        <input type="text" token="sizeGB" searchWhenChanged="true">
  21.          <label>Size Threshold(GB)</label>
  22.          <default>1</default>
  23.        </input>
  24.         <html>
  25.           <style>
  26.            .dashboard-row .dashboard-panel .panel-element-row {
  27.                overflow: auto;
  28.                max-height: 600px;
  29.             }
  30.              #singleValuePanel1{
  31.                width: 65% !important;
  32.              }
  33.           </style>
  34.         </html>
  35.        <table>
  36.          <search>
  37.            <query>index=core sourcetype=core $set$ GET_LOGGED_IN_USER=1
  38.  | eval lastseen=strftime(_time, "%m-%d-%Y %H:%M:%S")
  39.  | stats first(lastseen) by modelGuid
  40.  | sort + lastseen
  41.  | lookup model-all modelGuid output modelName as "Model Name" workspaceName as "Workspace Name"
  42.  | lookup model-dc5prod modelGuid output activeState memoryUsage
  43.  | eval "Model Size(GB)" = round(memoryUsage / 1073741824,4)
  44.  | search "Model Size(GB)" >$sizeGB$
  45.  | search activeState!=ARCHIVED
  46.  | table "Workspace Name", "Model Name", activeState, first(lastseen), "Model Size(GB)"</query>
  47.            <earliest>-60d</earliest>
  48.            <latest>now</latest>
  49.            <sampleRatio>1</sampleRatio>
  50.          </search>
  51.          <option name="count">50</option>
  52.          <option name="dataOverlayMode">none</option>
  53.          <option name="drilldown">none</option>
  54.          <option name="percentagesRow">false</option>
  55.          <option name="rowNumbers">false</option>
  56.          <option name="totalsRow">false</option>
  57.          <option name="wrap">true</option>
  58.        </table>
  59.      </panel>
  60.      <panel id="singleValuePanel2">
  61.        <title>Space Remaining in Each Workspace</title>
  62.        <html depends="$hiddenForCSS$">
  63.          <style>
  64.            #singleValuePanel2{
  65.              height: 200px !important;
  66.              width: 35% !important;
  67.            }
  68.          </style>
  69.        </html>
  70.        <table>
  71.          <search>
  72.            <query>workspaceGuid=8a81b09c53248e3d0153f1cab02d7dc5 OR workspaceGuid=8a81948243cb6a7f0143d9ff2be97e34 OR workspaceGuid=8a819488482885c901483c882c6c4fa9 OR workspaceGuid=8a81b0945ef8a5c0015f255c3f8e44a2
  73.  | fields + workspaceSize, workspaceGuid
  74.  | lookup workspace-dc5prod workspaceGuid output name
  75.  | stats latest(workspaceSize) by name
  76.  | appendcols
  77.      [| inputlookup workspace-dc5prod where workspaceGuid=8a81b09c53248e3d0153f1cab02d7dc5 OR workspaceGuid=8a81948243cb6a7f0143d9ff2be97e34 OR workspaceGuid=8a819488482885c901483c882c6c4fa9 OR workspaceGuid=8a81b0945ef8a5c0015f255c3f8e44a2
  78.      | eval sizeAllowance= sizeAllowance/ 1073741824
  79.      | stats values(sizeAllowance) by name ]
  80.  | convert num(latest(workspaceSize)) as workspaceSize, num(values(sizeAllowance)) as sizeAllowance
  81.  | eval "Space Remaining(GB)"=sizeAllowance-workspaceSize
  82.  | table name "Space Remaining(GB)" workspaceSize sizeAllowance
  83.  | rename workspaceSize as "Space Used(GB)" sizeAllowance as "Size Allowance(GB)"</query>
  84.            <earliest>-24h</earliest>
  85.            <latest>now</latest>
  86.            <sampleRatio>1</sampleRatio>
  87.          </search>
  88.          <option name="count">50</option>
  89.          <option name="dataOverlayMode">none</option>
  90.          <option name="drilldown">none</option>
  91.          <option name="percentagesRow">false</option>
  92.          <option name="rowNumbers">false</option>
  93.          <option name="totalsRow">false</option>
  94.          <option name="wrap">true</option>
  95.        </table>
  96.      </panel>
  97.      <panel id="singleValuePanel">
  98.        <title>Lookup Model Name and Size</title>
  99.        <input type="text" token="mGuid">
  100.          <label>Model Guid</label>
  101.        </input>
  102.        <html>
  103.          <style>
  104.            #singleValuePanel{
  105.              max-height: 300px !important;
  106.              width: 35% !important;
  107.            }
  108.          </style>
  109.          </html>
  110.        <table>
  111.          <search>
  112.            <query>| inputlookup model-all
  113.  | where modelGuid="$mGuid$"
  114.  | eval "Model Size(GB)"=round(lastModelSizeBytes/1000000000, 2)
  115.  | fields + customerName workspaceName modelName "Model Size(GB)"
  116.  | rename workspaceName as "Workspace Name" customerName as "Customer" modelName as "Model Name"</query>
  117.            <earliest>-24h</earliest>
  118.            <latest>now</latest>
  119.            <sampleRatio>1</sampleRatio>
  120.          </search>
  121.          <option name="count">1</option>
  122.          <option name="dataOverlayMode">none</option>
  123.          <option name="drilldown">none</option>
  124.          <option name="percentagesRow">false</option>
  125.          <option name="rowNumbers">false</option>
  126.          <option name="totalsRow">false</option>
  127.          <option name="wrap">true</option>
  128.        </table>
  129.      </panel>
  130.    </row>
  131.  </form>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top