|
|
楼主 |
发表于 2023-4-19 14:26:15
|
显示全部楼层
如果facts用了本地缓存,-f 指定缓存目录即可。
& F0 n1 a# J5 i- m1 ^ ~! o3 P1 d0 p9 l b5 ]2 b% M) \# A) @
: k! | p) H5 U7 d/ t4 q$ aansible-cmdb -f /path/to/facts/dir > overview.html
) I: I# d5 a+ @: h& H J以资产列表得形式统计出ansible主机信息。1 V( }( j1 l/ e, ]+ M
+ A1 Q' n8 t/ d6 S3 {. O2 H1 c
/ R) D4 a; A- N" a# ansible-cmdb -t txt_table --columns name,os,ip,mem,cpus out/6 y& T3 s, _6 E4 k, \; r- C* h
Name OS IP Mem CPUs
* v8 Y3 T6 p) y, ~--------- ---------- -------------- --- ----
5 b3 s) J3 o; Z( F$ alocalhost CentOS 7.6 192.168.77.130 1g 1 * C& ~& K& t9 o1 S
输出csv格式的主机信息。# b9 F/ a5 N/ W0 g
6 A6 d; }, {1 i5 _- k* h& c- A+ d7 C8 j5 F; n. t1 R
# ansible-cmdb -t csv out/
% e$ D- V& L {- z% x; L' v"Name","OS","IP","Arch","Mem","MemFree","MemUsed","CPUs","Virt","Disk avail"6 Y2 Y) _1 v1 v' O
"localhost","CentOS 7.6","192.168.77.130","x86_64/x86_64","1g","0g","1g","1","VMware/guest","28.0g, 0.0g"
. N; r# W" b& t7 m7 I8 @# I输出sql文件,导入数据到mysql或者SQLite。
* t/ e, y* {3 W& B9 k
& B% W5 _0 }, l+ T" W
7 N1 h2 c) A. v! D1 D+ f9 K# ansible-cmdb -t sql out/
- W Y, b" K. j- X6 Z8 c1 w0 XDROP TABLE IF EXISTS hosts;: A$ Q% H0 T' q8 G9 y$ ?: y
CREATE TABLE hosts (
/ L4 D4 M. L3 z% p4 | name VARCHAR(255),6 G& @5 j2 ^5 ?+ J' |& i5 Y
fqdn VARCHAR(255),% _/ C ]0 R( N/ r
main_ip VARCHAR(15),
7 G0 W' g! p1 ^. M ?8 ~ os_name VARCHAR(80),
' h7 N( i L2 u5 E os_version VARCHAR(40),
; W3 g, k/ _$ I! O: x, Q system VARCHAR(40),
3 x! l% o6 D% i kernel VARCHAR(40),/ |! o6 E0 ~4 A9 Q3 f9 y
arch_hardware VARCHAR(12),
0 C7 [% r/ i" O0 l2 h4 B arch_userspace VARCHAR(12),- Z+ M' D0 j# N- W
virt_type VARCHAR(20),; Y: _9 s" F' \2 S' W8 F G2 P
virt_role VARCHAR(20),
M" I* i: m) K$ c1 X cpu_type VARCHAR(60),& m& h) g' b$ _
vcpus INT,) t' Q5 n4 Y& j6 f7 L/ p/ {
ram FLOAT,7 P' e: G7 F2 c) J; o9 B/ y
disk_total FLOAT,
4 R: ~0 E+ U. E( B$ z9 W disk_free FLOAT Z; T+ O! y1 z, k+ w
);
1 N0 ?5 z# o1 o2 t; f6 O9 b( c! m+ P+ O
INSERT INTO hosts (
$ G* R9 }: Z% v$ ?9 B name,' z; X+ K+ K0 W9 d
fqdn,9 j9 `* X) |- B- M2 E" x D
main_ip,
. t( j% A9 s7 F. @3 G, d os_name,5 [, a- Y4 j$ h, O4 a
os_version,9 @+ n9 h! _: Q/ i% K* x" t
system,
5 O g: b) s u$ _ kernel,7 w9 x- o F' f1 q! j
arch_hardware,
6 ]# Y% P5 F( H* F arch_userspace,
; E8 z2 @# I5 a) Z virt_type,
& `- E' e4 o+ g2 p virt_role,. ^- |# Z2 k& i
cpu_type,
* e! R5 P, h9 c; p vcpus,
5 H# G. `( M5 G% Y ram,: C* a% t7 n* p) U: n
disk_total,7 ?( Q$ q' [$ K, d" L
disk_free
8 ^0 w& Y5 B" ~7 K* q ) VALUES (
/ Q8 L5 B- N/ P "localhost",
% [( G0 h# i# W% |3 u "a23-202-231-167.deploy.static.akamaitechnologies.com",
% J( D* b( F9 C2 t7 ~1 e "192.168.77.130",: u& f/ F# [. ?8 f8 F
"CentOS",
; }7 b" v! u1 ~2 L u "7.6",) ?0 K, E8 p# g
"Linux",
1 r! p( L: F& w9 A; @ "5.1.11-1.el7.elrepo.x86_64",
* B- _/ b# q3 F "x86_64",7 z) Q" ~/ ]" @- f; m* F' n+ V
"x86_64",5 T \9 o5 V; s! a
"VMware",
3 e/ ~: h2 n" M _1 L' S "guest",
4 N. T: l3 d! ~. K. ~ "Intel(R) Core(TM) i3-4160 CPU @ 3.60GHz",8 p3 _' Y- z# `0 T) E
1,
6 j$ h) E( b( U 0.9,
* }5 i. `0 X W8 n 29.8,8 o; G+ N: s- g3 r7 J
27.4; q. C" \' X7 ?8 s9 _) I
);6 Q# _2 Q2 Z" ?: _9 A# e ]& H
其他模板格式。
* p/ l! q2 T. ~* I2 Y) @& o, A2 O- B) D2 |" M! K" m& A
2 u+ a/ n. m! i5 Zansible-cmdb -t json out/
8 f/ |$ ]1 K5 @. x( _ansible-cmdb -t markdown out/ |
|