Linux: различия между версиями
Перейти к навигации
Перейти к поиску
Дополнительные пакеты для Linux:
apt install sudo vim
export PATH=$PATH:/sbin
export PATH=$PATH:/usr/sbin
apt install htop tcpdump mc ncdu pydf pwgen nmap nmon atop hwinfo curl aptitude screen locate -y
editor
ls -l /etc/alternatives/editor
update-alternatives --config editor
Press <enter> to keep the current choice[*], or type selection number: 3 <choose 3>
Conf
Conf
\dt все таблицы активной базы
SELECT * FROM cwd_user; вся таблица пользователей cwd_user
SELECT * FROM cwd_user WHERE active = 'F'; вся таблица активных пользователей cwd_user
SELECT id, user_name, display_name, lower_display_name, external_id FROM cwd_user; вся таблица пользователей cwd_user со столбцами...
SELECT * FROM logininfo; все данные таблицы logininfo
SELECT * FROM user_mapping; все данные таблицы user_mapping
SELECT * FROM cwd_user;
SELECT username FROM logininfo; username из столбца logininfo
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
SELECT id, user_name, display_name, lower_display_name, external_id FROM cwd_user; по полям... из таблицы cwd_user
SELECT successdate, prevsuccessdate, faileddate, username FROM logininfo li WHERE successdate > '2022-01-01' ORDER BY successdate;
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;
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;
Строка 1: | Строка 1: | ||
− | Дополнительные пакеты для Linux: | + | <li>Дополнительные пакеты для Linux: |
− | apt install sudo vim | + | <li>apt install sudo vim |
− | export PATH=$PATH:/sbin | + | <li>export PATH=$PATH:/sbin |
− | export PATH=$PATH:/usr/sbin | + | <li>export PATH=$PATH:/usr/sbin |
− | apt install htop tcpdump mc ncdu pydf pwgen nmap nmon atop hwinfo curl aptitude screen locate -y | + | <li>apt install htop tcpdump mc ncdu pydf pwgen nmap nmon atop hwinfo curl aptitude screen locate -y |
− | editor | + | <li>editor |
− | ls -l /etc/alternatives/editor | + | <li>ls -l /etc/alternatives/editor |
− | update-alternatives --config editor | + | <li>update-alternatives --config editor |
− | Press <enter> to keep the current choice[*], or type selection number: 3 <choose 3> | + | <li>Press <enter> to keep the current choice[*], or type selection number: 3 <choose 3> |
Строка 16: | Строка 16: | ||
<li><strong>Conf</strong> | <li><strong>Conf</strong> | ||
− | \dt все таблицы активной базы | + | <li>\dt все таблицы активной базы |
− | SELECT * FROM cwd_user; вся таблица пользователей cwd_user | + | <li>SELECT * FROM cwd_user; вся таблица пользователей cwd_user |
− | SELECT * FROM cwd_user WHERE active = 'F'; вся таблица активных пользователей cwd_user | + | <li>SELECT * FROM cwd_user WHERE active = 'F'; вся таблица активных пользователей cwd_user |
− | SELECT id, user_name, display_name, lower_display_name, external_id FROM cwd_user; вся таблица пользователей cwd_user со столбцами... | + | <li>SELECT id, user_name, display_name, lower_display_name, external_id FROM cwd_user; вся таблица пользователей cwd_user со столбцами... |
− | SELECT * FROM logininfo; все данные таблицы logininfo | + | <li>SELECT * FROM logininfo; все данные таблицы logininfo |
− | SELECT * FROM user_mapping; все данные таблицы user_mapping | + | <li>SELECT * FROM user_mapping; все данные таблицы user_mapping |
− | SELECT * FROM cwd_user; | + | <li>SELECT * FROM cwd_user; |
− | SELECT username FROM logininfo; username из столбца logininfo | + | <li>SELECT username FROM logininfo; username из столбца logininfo |
− | 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 successdate, username FROM logininfo WHERE successdate < '2022-01-01' ORDER BY successdate; List active users who have not logged in since a specific date |
− | SELECT id, user_name, display_name, lower_display_name, external_id FROM cwd_user; по полям... из таблицы cwd_user | + | <li>SELECT id, user_name, display_name, lower_display_name, external_id FROM cwd_user; по полям... из таблицы cwd_user |
− | SELECT successdate, prevsuccessdate, faileddate, username FROM logininfo li WHERE successdate > '2022-01-01' ORDER BY successdate; | + | <li>SELECT successdate, prevsuccessdate, faileddate, username FROM logininfo li WHERE successdate > '2022-01-01' ORDER BY successdate; |
− | SELECT li.successdate, li.prevsuccessdate, li.faileddate, cu.user_name, display_name, cd.directory_name FROM logininfo li | + | <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 | 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; | WHERE successdate > '2022-01-01' ORDER BY successdate; | ||
− | SELECT cu.user_name, cd.directory_name, prevsuccessdate, li.successdate, faileddate, display_name FROM logininfo li | + | <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 | 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; | WHERE cd.directory_name = 'tps.local' and successdate < '2022-01-01' ORDER BY successdate; |