Открыть туннелирование через SSH

#/etc/ssh/sshd_config

AllowTcpForwarding yes
GatewayPorts yes

systemctl restart ssh

Collect All Members of On-Call Groups

A quick and dirty script to get all the members of on-call groups which can be further parsed in Excel
// 1. Get all on-call shifts's unique groups
var gr = new GlideRecord('cmn_rota');
gr.query();

var uniqueGroupsArray = []; 

while (gr.next()) {
    var group = gr.group + '';
    if (uniqueGroupsArray.indexOf(group) == -1) {
        uniqueGroupsArray.push(group);
    }
}

gs.info('On-Call Groups: ' + uniqueGroupsArray.length);
// 2. Get all unique group's unique users
var uniqueUsersArray = [];

for (var i=0;i<uniqueGroupsArray.length;i++) {
    var grUsers = new GlideRecord(

Cheat Sheet Per Bag Details

SELECT
    dbo.dmprod.pr_codenum,
    dbo.dmprod.pr_descrip,
    RTRIM(dbo.dmcats2.c2_name) + ': ' + RTRIM(dbo.dmunit.un_name) + CASE
        WHEN pr_descrip LIKE '%Tower%' THEN ' - Tower '
        WHEN pr_descrip LIKE '%Shipper%' THEN ' - Shipper '
        WHEN pr_descrip LIKE '%Walmart%' THEN ' - Walmart '
        WHEN pr_descrip LIKE '%Sam%' THEN ' - Sams '
        ELSE ''
    END AS [Group],
    RTRIM(dbo.dmpr5.p5_name) AS Brand,
    RTRIM(dbo.dmpr2.p2_name) AS Class,
    RTRIM(d

Cheat Sheet Per Bag

SELECT
    RTRIM(dbo.dmcats2.c2_name) + ': ' + RTRIM(dbo.dmunit.un_name) + CASE
        WHEN pr_descrip LIKE '%Tower%' THEN ' - Tower '
        WHEN pr_descrip LIKE '%Shipper%' THEN ' - Shipper '
        WHEN pr_descrip LIKE '%Walmart%' THEN ' - Walmart '
        WHEN pr_descrip LIKE '%Sam%' THEN ' - Sams '
        ELSE ''
    END AS [Group],
    RTRIM(dbo.dmpr5.p5_name) AS Brand,
    RTRIM(dbo.dmpr2.p2_name) AS Class,
    RTRIM(dbo.dmpr1.p1_name) AS Protein,
    RTRIM(dbo.dmd3.d3_val

Chart of Accounts

SELECT
    dbo.dmchrt.ch_id,
    LEFT (dbo.dmchrt.ch_account, 5) + '-' + SUBSTRING(CAST(dbo.dmchrt.ch_account AS varchar), 6, 2) + '-' + SUBSTRING(CAST(dbo.dmchrt.ch_account AS varchar), 8, 3) + '-' + SUBSTRING(CAST(dbo.dmchrt.ch_account AS varchar), 11, 1) AS ch_account,
    RTRIM (dbo.dmchrt.ch_name) AS ch_name,
    dbo.dmchrt.ch_type,
    cb2.d3_value AS CostingBucket,
    pl2.d3_value AS PLCategory
FROM
    dbo.dmchrt
    LEFT OUTER JOIN dbo.dtd2 AS cb ON cb.d2_recid = dbo.dmchrt.ch

Broker Deal Sheet Item Master Info

SELECT
    RTRIM(dbo.dmcats2.c2_name) + ': ' + RTRIM(dbo.dmunit.un_name) + CASE
        WHEN pr_descrip LIKE '%Tower%' THEN ' - Tower '
        WHEN pr_descrip LIKE '%Shipper%' THEN ' - Shipper '
        WHEN pr_descrip LIKE '%Walmart%' THEN ' - Walmart '
        WHEN pr_descrip LIKE '%Sam%' THEN ' - Sams '
        ELSE ''
    END AS [Group],
    dbo.dmcats2.c2_id AS [Subcategory ID],
    RTRIM(dbo.dmpr5.p5_name) AS Brand,
    RTRIM(dbo.dmpr2.p2_name) AS Class,
    RTRIM(dbo.dmpr1.p1_

Broker Deal Entry Sales Rep

SELECT
  TOP (1000) RTRIM(dbo.dmsman.sm_fname) AS [First Name],
  RTRIM(dbo.dmsman.sm_lname) AS [Last Name],
  dbo.dmsman.sm_id,
  RTRIM(dbo.dmsgrp.sg_name) AS [Group],
  dbo.dmsgrp.sg_id,
  RTRIM(dbo.dmsman.sm_city) + ', ' + RTRIM(dbo.dmsman.sm_state) AS Lookup,
  Email.d2_value AS RepEmail
FROM
  dbo.dmsman
  INNER JOIN dbo.dmsgrp ON dbo.dmsgrp.sg_id = dbo.dmsman.sm_sgid
  LEFT OUTER JOIN dbo.dtd2 AS Email ON Email.d2_recid = dbo.dmsman.sm_id
  AND Email.d2_d1id = 185
WHERE
  (db

BOM Green Yield v2

SELECT
  s4.pr_codenum AS partnum,
  s4.pr_descrip AS partdescrip,
  SUM(
    (
      (
        (stage3.bo_quant / stage3.re_yield) * (stage2.bo_quant / stage2.re_yield)
      ) * (stage1.bo_quant / stage1.re_yield)
    ) * (stage0.bo_quant / stage0.re_yield)
  ) AS s0tot,
  SUM(
    (stage3.bo_quant / stage3.re_yield) * (stage2.bo_quant / stage2.re_yield)
  ) AS s2tot,
  1 AS One
FROM
  dbo.dmprod AS s4
  INNER JOIN (
    SELECT
      rs4.re_prid,
      bs3.bo_prid,
      rs

BOM Green Yield

SELECT
  s4.pr_codenum AS partnum,
  s4.pr_descrip AS partdescrip,
  SUM(
    (
      (
        (stage3.bo_quant / stage3.re_yield) * (stage2.bo_quant / stage2.re_yield)
      ) * (stage1.bo_quant / stage1.re_yield)
    ) * (stage0.bo_quant / stage0.re_yield)
  ) AS s0tot
FROM
  dbo.dmprod AS s4
  INNER JOIN (
    SELECT
      rs4.re_prid,
      bs3.bo_prid,
      rs4.re_yield,
      bs3.bo_quant
    FROM
      dbo.dmrev AS rs4
      INNER JOIN dbo.dmbom AS bs3 ON rs4.re_id =

Bags Sold v2

SELECT
    Sold.pr_codenum AS SoldPart,
    Sold.pr_descrip AS SoldDescrip,
    dbo.dmpr3.p3_name AS Stage,
    Bag.pr_codenum AS Part,
    Bag.pr_descrip AS Descrip,
    dbo.dmpr5.p5_name AS Brand,
    dbo.dmpr2.p2_name AS Class,
    dbo.dmpr1.p1_name AS Protein,
    dbo.dttord.to_shipped AS Shipped,
    SUM(dbo.dtord.or_qship) AS ShippedQty,
    dbo.dmbom.bo_quant,
    dbo.dmrev.re_yield,
    dbo.dmbom.bo_quant / dbo.dmrev.re_yield AS Bags
FROM
    dbo.dtord
    INNER JOIN dbo.

Bags Sold Sams Club

SELECT
    dbo.dmship.sh_name AS Store,
    dbo.dmprod.pr_codenum AS Part,
    dbo.dmprod.pr_descrip AS Descrip,
    dbo.dmpr3.p3_name AS Stage,
    dbo.dmpr5.p5_name AS Brand,
    dbo.dmpr2.p2_name AS Class,
    dbo.dmpr1.p1_name AS Protein,
    dbo.dmprod.pr_reorder AS Min1,
    dbo.dmprod.pr_maxquan1 AS Max1,
    dbo.dttord.to_shipped AS Shipped,
    SUM(dbo.dtord.or_qship) AS ShippedQty
FROM
    dbo.dtord
    INNER JOIN dbo.dmprod ON dbo.dtord.or_prid = dbo.dmprod.pr_id
    IN

Bags Sold By Month

SELECT
  Sold.pr_codenum AS SoldPart,
  Sold.pr_retail AS SoldRetail,
  Sold.pr_descrip AS SoldDescrip,
  dbo.dmpr3.p3_name AS SoldStage,
  dbo.dmbill.bi_id,
  dbo.dmbill.bi_name AS BTCust,
  dbo.dmship.sh_id,
  dbo.dmship.sh_name AS STCust,
  rep.RepID,
  rep.RepName,
  Bag.pr_codenum AS BagPart,
  Bag.pr_retail AS BagRetail,
  Bag.pr_descrip AS BagDescrip,
  Bag.pr_user1 AS BagFlavor,
  prodtype.d3_value AS BagProdType,
  dbo.dmpr5.p5_name AS BagBrand,
  dbo.dmpr2.p2_name AS B

Bags Sold

SELECT
    Sold.pr_codenum AS SoldPart,
    Sold.pr_descrip AS SoldDescrip,
    dbo.dmpr3.p3_name AS Stage,
    Bag.pr_codenum AS Part,
    Bag.pr_descrip AS Descrip,
    dbo.dmpr5.p5_name AS Brand,
    dbo.dmpr2.p2_name AS Class,
    dbo.dmpr1.p1_name AS Protein,
    dbo.dttord.to_shipped AS Shipped,
    SUM(dbo.dtord.or_qship) AS ShippedQty,
    dbo.dmbom.bo_quant,
    dbo.dmrev.re_yield,
    dbo.dmbom.bo_quant / dbo.dmrev.re_yield AS Bags
FROM
    dbo.dtord
    INNER JOIN dbo.

Approaching Year

SELECT
  dbo.dmprod.pr_codenum,
  dbo.dmprod.pr_descrip,
  dbo.dmunit.un_name,
  lessyear.less,
  lessyear.less * dbo.dmprod.pr_fixstan AS lessdol,
  lessthirty.thirty,
  lessthirty.thirty * dbo.dmprod.pr_fixstan AS thirtydol,
  lesssixty.sixty,
  lesssixty.sixty * dbo.dmprod.pr_fixstan AS sixtydol,
  lessninety.ninety,
  lessninety.ninety * dbo.dmprod.pr_fixstan AS ninetydol
FROM
  dbo.dmprod
  INNER JOIN dbo.dmunit ON dbo.dmprod.pr_unid = dbo.dmunit.un_id
  LEFT OUTER JOIN (
  

2. Text to Speech with HuggingFace.js Inference

# Text to Speech with HuggingFace.js Inference

**model:** [`espnet/kan-bayashi_ljspeech_vits`](https://huggingface.co/espnet/kan-bayashi_ljspeech_vits)

`hf-logo.svg`
```svg
<svg xmlns="http://www.w3.org/2000/svg" width="95" height="88" fill="none">
	<path fill="#FFD21E" d="M47.21 76.5a34.75 34.75 0 1 0 0-69.5 34.75 34.75 0 0 0 0 69.5Z"/>
	<path fill="#FF9D0B" d="M81.96 41.75a34.75 34.75 0 1 0-69.5 0 34.75 34.75 0 0 0 69.5 0Zm-73.5 0a38.75 38.75 0 1 1 77.5 0 38.75 38.75 0 0 1-77.5 0Z"/>
	<path 

28022024

inicio{
"host":"2110046DFF7EF761FB4A2061E24E",
"porta":"65DB51D1"
}fim