Observium database view and edit.

gistfile1.txt

## velg database
# use observium

## list kollonner
# DESC `devices`;

## finn brukte verdier, i 'disable'
#SELECT DISTINCT `disabled` FROM `devices`;

##   finn alle som er diablet.
#SELECT `device_id`, `hostname` FROM `devices`  WHERE `disabled` = '1';

## finn alle enhet som tilhør anlegg:
# SELECT `device_id`, `hostname`, `disabled` FROM `devices`  WHERE `hostname` like '%knappe%' ;

## erstatt
#select er kun for lesing

#UPDATE `devices` SET `disabled` = '0' WHERE `hostname` like '%knappe%';

## disable

# UPDATE `devices` SET `disabled` = '1' WHERE `hostname` like '%knappe%';