Nagios批次更換管理員

urgel_babay發表於2016-05-11
Nagios批次更換管理員


select * from host where host_alias like "%name%"
select host_name, host_alias from host where host_name LIKE "%172.2.129.61%";

替換:
UPDATE host
SET host_alias = (
REPLACE (
host_alias,
"name1",
"name2"
)
)
WHERE
host_name LIKE "%中心%";

增加:
UPDATE host
SET host_alias = (
concat (
host_alias,
"/name"
)
)
WHERE
host_name LIKE "%129.61%";



來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/30936525/viewspace-2097965/,如需轉載,請註明出處,否則將追究法律責任。

相關文章