Scripting
Read More
Comma separated list of system processes
Run this command from a console window ps axo “%u,%U,%p,%a,%z”
Scripting
Read More
Liste opp alle prosesser som kjører på systemet, uten duplikater
# ps ahx –format=%c | sort -u
Scripting
Read More
Find duplicate usernames in /etc/passwd
# cat /etc/passwd | awk -F: ‘{print $1}’ | sort | uniq -c | grep -v 1 # cat /etc/shadow | awk -F: ‘{print $1}’ | sort | uniq -c | grep -v 1 # awk -F: ‘{ print $1, $5}’ /etc/passwd
Scripting
Read More
mySQL and Stored Triggers
This is an example on how you an use stored triggers in mySQL /* test_workaround.sql */ USE test ; DROP TABLE IF EXISTS `addresses`; CREATE TABLE `addresses` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `created_on` DATETIME NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `updated_on` DATETIME NOT NULL DEFAULT ‘0000-00-00 00:00:00′, `mac_address` CHAR(17) NOT NULL DEFAULT ’00:16:DD:xx:xx:xx’, /* […]