- 积分
- 16843
在线时间 小时
最后登录1970-1-1
|

楼主 |
发表于 2023-4-19 14:26:15
|
显示全部楼层
如果facts用了本地缓存,-f 指定缓存目录即可。5 |& ]5 V5 |4 y/ G) {6 I* G; C; U& t$ Q
) r# h6 ~+ }5 r; W- v' O5 ^- Z6 \$ t( `* V' V) s& ?
ansible-cmdb -f /path/to/facts/dir > overview.html
; Y6 \ x- o8 h9 a9 V以资产列表得形式统计出ansible主机信息。
0 b& |& S j _* p9 F2 |) w/ }% g$ o" D- N5 K8 G
5 I3 s ~" ?. e+ I2 ^0 G+ w# ansible-cmdb -t txt_table --columns name,os,ip,mem,cpus out/. [9 \' D' c p ?5 I: i: Q
Name OS IP Mem CPUs 8 [+ o7 Q8 ]- }& C0 ^6 `
--------- ---------- -------------- --- ----
! {1 S* q% M/ E. I) Vlocalhost CentOS 7.6 192.168.77.130 1g 1
& [7 I4 k+ i* y9 k$ L' t( K7 a3 j输出csv格式的主机信息。- X7 h# z, l. C6 ~
& d/ i1 I+ v1 K
5 Q$ J- e) }7 J Q( L% `# ansible-cmdb -t csv out/ 6 i& f; E* u$ b% R8 F
"Name","OS","IP","Arch","Mem","MemFree","MemUsed","CPUs","Virt","Disk avail"7 u0 c- a4 }' x: l4 e
"localhost","CentOS 7.6","192.168.77.130","x86_64/x86_64","1g","0g","1g","1","VMware/guest","28.0g, 0.0g"; R8 @$ `+ m) K% p: ^
输出sql文件,导入数据到mysql或者SQLite。6 q3 {$ c0 A* O
& r( G/ S1 ?* @6 ], {
. G. U" h+ p6 l$ y0 ]8 }+ ]# ansible-cmdb -t sql out/7 R3 S8 u& Q T1 T
DROP TABLE IF EXISTS hosts;
, K" P0 C6 i) U) Y) l7 MCREATE TABLE hosts (
7 Y( ~ _7 j" ?9 h4 [ name VARCHAR(255),
$ ?% A: A+ C1 Y; o7 b fqdn VARCHAR(255),
8 d5 O# l+ Y7 N# @ main_ip VARCHAR(15),
$ D1 D. H7 A* N( ~* @ os_name VARCHAR(80),
$ {& A3 s; J" j+ i- k4 ~$ H os_version VARCHAR(40),
/ N2 B) t+ H1 Y! J9 b! r system VARCHAR(40),- ~+ ~4 M0 f, f# }+ e. f/ C
kernel VARCHAR(40),/ V, Q: k; S: z# }
arch_hardware VARCHAR(12),
8 b7 z( W; n# O& D arch_userspace VARCHAR(12),6 @3 u9 f( I7 X! t: N
virt_type VARCHAR(20),
- l' J* c, k6 \$ \! S( P3 _ virt_role VARCHAR(20),# e1 l1 `) B0 ~; v5 ]) A# x# t
cpu_type VARCHAR(60),+ u- o- |+ N6 b$ {
vcpus INT,
/ d5 u1 I* ~; X: d) O ram FLOAT,
$ H0 J8 x% z% Y/ A disk_total FLOAT,
. |$ D: Y; g5 F' K& k$ q8 L; _ disk_free FLOAT
- {6 \! M% k2 B9 K; X, K);% R2 M8 u/ T! K- {; c2 d
4 h: X3 A' `! l% d9 F INSERT INTO hosts (
/ K2 M% f R9 f& @2 W" D. c3 H name,
$ @; x1 K8 S$ p0 B; h( S fqdn,
/ V0 M4 R- p, N, O4 t, V; O% w/ [ main_ip,1 h& H) z$ q' y+ @* x K7 G6 [" X9 g" l
os_name,
. L/ z- ?3 `- h! {: o0 U: y/ E os_version,& f; M0 F7 c' D+ m! |6 q
system, Z$ ^2 d6 N3 |7 l
kernel,
* m3 M" Z$ @6 ~: [ arch_hardware,
0 E5 W1 M! t7 M$ L6 ] arch_userspace,
1 {& _, ?8 m- y( a2 F' H virt_type,' P1 I- r2 p& h& O
virt_role,- i$ E( q5 t% v0 H
cpu_type,: o$ K f' l# V
vcpus,
' L; I9 F% t" e7 X" N) c) W8 _ ram,1 q) a* _3 @: S; E
disk_total,( W8 c, e# W2 i2 X
disk_free
; H' U/ N" Y! X& Z ) VALUES (5 I$ b2 S7 ?; h5 @0 L
"localhost",
6 p7 u' s1 c9 G* w, G1 R3 p. Z "a23-202-231-167.deploy.static.akamaitechnologies.com",
$ c7 j r$ {2 @2 \' } ?7 | "192.168.77.130",. l6 K$ i" n2 [ P6 ~) \ W9 @
"CentOS",0 |) C/ y4 j8 K2 x7 p
"7.6",
) y7 u4 v: [3 `$ H5 d- M1 h% P "Linux",
2 [' C5 Q/ f F8 }( M& \0 Q "5.1.11-1.el7.elrepo.x86_64",
+ K' }. n s/ W* f j9 z "x86_64",/ }: e; ^3 n! `5 b. @# e
"x86_64",& a! x. i3 c5 y& k' Q6 \* @
"VMware",4 D, g; L2 { ^* q3 N: f0 {0 v
"guest",- E+ |4 W/ F5 T1 S
"Intel(R) Core(TM) i3-4160 CPU @ 3.60GHz",+ w7 _9 E, ~# v* C2 B) R
1,2 L" }/ Y9 @# C" N# a4 ^% Q+ u
0.9,
8 e4 h8 j0 ?! E2 E8 s o 29.8,
. U7 l* | p- L8 b! u" d 27.4
7 _3 `3 `' W2 W% l1 P );
5 c+ X5 z; L M8 V7 e E3 i2 V其他模板格式。: Q1 j# j) `5 o
- w! A+ B1 {5 J, W/ W9 {6 r
0 r9 _5 P0 {4 q! a% G
ansible-cmdb -t json out/
3 t G! O- v3 r" Bansible-cmdb -t markdown out/ |
|