Редактирование: Linux

<h3>Configuring Debian Linux:</h3>

<h5>Step 1. Install apt</h5>
<li>apt install vim 
<li>export PATH=$PATH:/sbin
<li>export PATH=$PATH:/usr/sbin
<li>apt install htop tcpdump mc ncdu pydf pwgen nmap nmon atop hwinfo curl aptitude screen locate -y
<br>

<h5>Step 2. Change default editor</h5>
<li>ls -l /etc/alternatives/editor
<li>update-alternatives --config editor
<li>Press <enter> to keep the current choice[*], or type selection number: 3 <choose 3>
<br>

<h3>Confluence postgres examples queries</h3>

<li>SELECT version(); - версия postgres
<li>\dt все таблицы активной базы
<li>SELECT * FROM cwd_user; вся таблица пользователей cwd_user
<li>SELECT * FROM cwd_user WHERE active = 'F'; вся таблица активных пользователей cwd_user
<li>SELECT id, user_name, display_name, lower_display_name, external_id FROM cwd_user; вся таблица пользователей cwd_user со столбцами...
<li>SELECT * FROM logininfo; все данные таблицы logininfo
<li>SELECT * FROM user_mapping; все данные таблицы user_mapping
<li>SELECT * FROM cwd_user;
<li>SELECT username FROM logininfo; username из столбца logininfo
<li>SELECT successdate, username FROM logininfo WHERE successdate < '2022-01-01' ORDER BY successdate; List active users who have not logged in since a specific date
<li>SELECT id, user_name, display_name, lower_display_name, external_id FROM cwd_user; по полям... из таблицы cwd_user
<li>SELECT successdate, prevsuccessdate, faileddate, username FROM logininfo li WHERE successdate > '2022-01-01' ORDER BY successdate;
<br>
<li>SELECT li.successdate, li.prevsuccessdate, li.faileddate, cu.user_name, display_name, cd.directory_name FROM logininfo li
JOIN user_mapping um ON um.user_key = li.username JOIN cwd_user cu ON um.username = cu.user_name JOIN cwd_directory cd ON cu.directory_id = cd.ID
WHERE successdate > '2022-01-01' ORDER BY successdate;
<br>
<li>SELECT cu.user_name, cd.directory_name, prevsuccessdate, li.successdate, faileddate, display_name FROM logininfo li
JOIN user_mapping um ON um.user_key = li.username JOIN cwd_user cu ON um.username = cu.user_name JOIN cwd_directory cd ON cu.directory_id = cd.id
WHERE cd.directory_name = 'tps.local' and successdate < '2022-01-01' ORDER BY successdate;
<br>
<h3>Other cases</h3>
<ol>
  <li>Microsoft</li>
  <li>Google</li>
  <li>Apple</li>
  <li>IBM</li>
</ol>

<ul>
 <li>Пункт 1.</li>
  <li>Пункт 2.
    <ul>
      <li>Подпункт 2.1.</li>
       <li>Подпункт 2.2.</li>
        </ul>
   </li>
</ul>