|
|
楼主 |
发表于 2023-4-19 14:26:15
|
显示全部楼层
如果facts用了本地缓存,-f 指定缓存目录即可。
4 T+ x: H/ |3 L# y/ X6 ^& Z x
' N, a" F3 M9 A" b. M4 [3 {# R$ `' T8 D$ ?+ M4 t3 S/ F! k
ansible-cmdb -f /path/to/facts/dir > overview.html4 c9 O7 x/ Y1 {
以资产列表得形式统计出ansible主机信息。2 h3 V( G: H" H" v
- O/ X; ]! r0 J+ B) ?- Z1 f# E9 e$ [4 ~: c1 X, Z( D2 u' g0 J
# ansible-cmdb -t txt_table --columns name,os,ip,mem,cpus out/ P8 K0 w$ p1 w
Name OS IP Mem CPUs
$ S* k" Q5 }: N7 J--------- ---------- -------------- --- ---- % Q$ o9 v, r) P6 D) z4 n8 p
localhost CentOS 7.6 192.168.77.130 1g 1
4 s+ Z# v4 ~; E r, \输出csv格式的主机信息。
% q/ i1 l2 `$ q/ Q1 s: J
$ ] m- M; X& l, Z7 {3 J/ b! d }/ x' ]* o3 |
# ansible-cmdb -t csv out/
6 A: z" i2 }! |& H/ e"Name","OS","IP","Arch","Mem","MemFree","MemUsed","CPUs","Virt","Disk avail"
b% R8 X" g5 M/ y"localhost","CentOS 7.6","192.168.77.130","x86_64/x86_64","1g","0g","1g","1","VMware/guest","28.0g, 0.0g") ^: V( n0 G" ~7 c( ? ?
输出sql文件,导入数据到mysql或者SQLite。* y6 l/ {% G3 r. Z- ~1 r
) `1 ] m* L+ t1 x- k2 X0 i
$ H, L5 x4 s G2 c# ansible-cmdb -t sql out/
/ c% l0 A1 C/ X- uDROP TABLE IF EXISTS hosts;7 w5 D" m, A+ M4 T+ Z# k
CREATE TABLE hosts (
' R' _+ O H6 R! x# d8 p name VARCHAR(255),; A/ h) i$ W! R
fqdn VARCHAR(255),/ X& L. y, X, p! M# r2 D e2 p. B
main_ip VARCHAR(15),
; l) H4 M3 l* Y5 S6 I6 `% } os_name VARCHAR(80),
2 @$ r' z2 y, e( N/ W7 u os_version VARCHAR(40),8 b% r9 d1 B! E6 H3 _7 c- Z
system VARCHAR(40),
8 v u- C& i' h8 w) V0 u1 k; p kernel VARCHAR(40),* O5 s' i& m# m( M" ]
arch_hardware VARCHAR(12),
2 _# o6 r/ o' Q4 U; t arch_userspace VARCHAR(12),
0 V) Y, R" `2 Q D" E virt_type VARCHAR(20),% C( w' u: M) [
virt_role VARCHAR(20),
+ e# i) m$ B1 F cpu_type VARCHAR(60),( D6 a6 S! N0 z n- l+ d- W1 p, T* D
vcpus INT,8 j- G) J' k1 e% m. O( F* s
ram FLOAT,8 B; J( Z- g; M" R% F
disk_total FLOAT,
* ~8 M, h6 N7 t$ y) J disk_free FLOAT
0 ^* o$ t4 O( } s* z);/ |/ ` O7 D c \+ f6 g
D3 L( c# x% k3 s: f& x w INSERT INTO hosts (
+ q2 q( D1 m% G& \0 ? name,
8 K6 F7 @9 v' \# v fqdn, e9 I% J" L0 L; `1 R! e
main_ip,# z4 G. w& S6 ~* j
os_name,
1 u$ w3 V. ~5 F* T# S0 B, k3 W3 | os_version,
" t& H9 X. B' r& { system,- }6 Y [) }3 x* \+ Z! J% t
kernel,( l$ s7 j/ ]2 n( G# t) d& j
arch_hardware,; i* E8 }! t2 B. y1 m ]
arch_userspace,
# r7 G v; j1 u) B6 l1 E virt_type,6 `! o" B4 L1 N e
virt_role, ~+ f3 \6 Q$ U
cpu_type,
6 N* l4 h6 u O6 m* u' M' W vcpus,/ @5 Y6 U( c4 E' r7 b- T+ \ r
ram,
# B, s4 x8 G% S: C, g" m% K disk_total,
1 x6 o4 C* H1 ^* Q( y/ p disk_free
2 e9 |; a- @ R8 _9 y" B; H- f ) VALUES (6 a! o9 K! w) u5 _, }
"localhost",: q. J( f4 ?% H6 `
"a23-202-231-167.deploy.static.akamaitechnologies.com",
2 u! ~' ~+ ~) v6 a* g "192.168.77.130",8 Y' Y5 Z& i# f5 o
"CentOS",
' i' W! Z0 [. X8 z, b2 I! S. G2 D* ~. Q "7.6",: q9 q Z! c7 I4 L, |0 a9 @
"Linux",
/ D( A9 t" [4 @3 L9 f "5.1.11-1.el7.elrepo.x86_64",4 ^9 N+ u6 ^2 K9 d; c$ @. J1 f
"x86_64",( I3 a. `! Y9 @+ V6 ~
"x86_64",# H& X5 R) r9 s8 T5 a9 X# o) ]
"VMware",8 [" d. X1 r4 W2 r# z$ C$ }) Q
"guest",+ g6 [7 k# _- Y$ [. u9 k! I8 M
"Intel(R) Core(TM) i3-4160 CPU @ 3.60GHz", `4 b( Y) S; d6 r
1,
# W1 B% o* f) P& x Z& h% o 0.9,
K# j% s. r+ j 29.8,! R8 ~4 n! p1 p2 D2 J' S! q# E
27.4$ W8 ^7 ]. s% E) p
);
! Q" i2 v; r* p: r2 W0 `2 O, Z其他模板格式。
6 i. w2 m- E6 L+ J& N& S3 J( d" s3 e! d
5 P# E6 `7 ?2 V& s$ U6 ^, I( h
ansible-cmdb -t json out/
! T4 R' q6 D0 B- q$ Z! ^* Zansible-cmdb -t markdown out/ |
|