一.主机资产管理
一需求分析：excel做公司内部资产记录如下:--但这样不方便 资产编号, ip, 主机名, 使用者, os, mem, cpu, 上架时间, 过保时间
所以开发web版,可以主机进行增，删，改，查
1.添加:方法如下
(1)人手工录入:
ssh ip
hostname
cat /proc/cpuinfo | grep processor | wc -l 查到它是几核
cat /proc/meminfo | grep MemTotal 去内存文件看内存
(2)主机内部安装了程序 agent => server 定时上报数据(ip, hostname, os, mem, cpu)
(3)写一程序扫描ip范围: ip, hostname, os (4)手工变自动化---自动远程获取:
上述四种方式就是通过excel导入(把excel文件上传服务器进行解析入库)text/csv/excel/xm => 导入 ip, hostname, os, mem, cpu
(5)其他第三方系统(如阿里云机器) => 调用它们的API => 导入
2.删除:
人工删除
自动删除(与第三方系统结合)
3.改:
人工改
自动改
4.查:
自己查
提供数据 => API(别人把你当第三方系统，你给别人提供数据，别人调你的api)
删除, 查询 => 人工
添加, 修改 => 自动
修改 => 人工
定义model => table
资产编号, ip, 主机名, 使用者, os, arch, mem, cpu, disk, 上架时间, 过保时间, 在线状态
机制推: 每周三所有人把作业发给我 agent采集 => server
拉: 每周三我找所有人要 扫描(ansible)
二.创建资产管理app
1. 创建app
(python36env) [ cmdb]$ python manage.py startapp asset
2. 启用app
settings INSTALLED_APPS asset.apps.AssetConfig
3. asset/urls.py
from django.urls import path
from . import views
app_name = ‘asset‘
urlpatterns = [
path(‘‘, views.index, name=‘index‘),
path(‘list/ajax/‘, views.list_ajax, name=‘list_ajax‘),
]
4. cmdb/urls.py根路由配置相关的url(/app名称/)分发给app
path(‘asset/‘, include(‘asset.urls‘)) 把app的url映射包进来
5. asset/models.py
6. 迁移数据库
python manage.py makemigrations
python manage.py migrate7.asset/views.py:
#encoding: utf-8
from django.http import JsonResponse
from django.shortcuts import render, redirect
from .models import Host
def index(request):
if not request.session.get(‘user‘):
return redirect(‘user:login‘)
return render(request, ‘asset/index.html‘)
def list_ajax(request):
if not request.session.get(‘user‘):
return JsonResponse({‘code‘ : 403, ‘result‘ : []})
result= [host.as_dict() for host in Host.objects.all()]
return JsonResponse({‘code‘ : 200, ‘result‘ : result})8.asset/urls.py:
#encoding: utf-8
from django.urls import path
from . import views
app_name = ‘asset‘
urlpatterns = [
#这里我是想访问根路径(http://127.0.0.1:9000/asset/)时直接请求此app的index，所以为空‘‘
path(‘‘, views.index, name=‘index‘),
path(‘list/ajax/‘, views.list_ajax, name=‘list_ajax‘),
]9.asset/models.py:
#encoding: utf-8
from django.db import models
from django.core.exceptions import ObjectDoesNotExist
from django.utils import timezone
import datetime
#要继承自models.Model
class Host(models.Model):
#这一块是我收集的:
name = models.CharField(max_length=128, null=False, default=‘‘)
ip = models.GenericIPAddressField(null=False, default=‘0.0.0.0‘)
mac = models.CharField(max_length=32, null=False, default=‘‘)
os = models.CharField(max_length=64, null=False, default=‘‘)
arch = models.CharField(max_length=16, null=False, default=‘‘)
mem = models.BigIntegerField(null=False, default=0)
cpu = models.IntegerField(null=False, default=0)
disk = models.CharField(max_length=512, null=False, default=‘{}‘)
#这一块是要进行输入的:
sn = models.CharField(max_length=128, null=False, default=‘‘)
user = models.CharField(max_length=128, null=False, default=‘‘)
remark = models.TextField(null=False, default=‘‘)
purchase_time = models.DateTimeField(null=False)
over_insurance_time = models.DateTimeField(null=False)
#这一块是我应用程序用的:
created_time = models.DateTimeField(null=False, auto_now_add=True)
last_time = models.DateTimeField(null=False)
@classmethod
def create_or_replace(cls, ip, name, mac, os, arch, mem, cpu, disk):
obj = None
try:
obj = cls.objects.get(ip=ip)
except ObjectDoesNotExist as e:
obj = cls()
obj.ip = ip
obj.purchase_time = timezone.now()
obj.over_insurance_time = timezone.now()
obj.name = name
obj.mac = mac
obj.os = os
obj.arch = arch
obj.mem = mem
obj.cpu = cpu
obj.disk = disk
obj.last_time = timezone.now()
obj.save()
return obj
def as_dict(self):
rt = {}
for k, v in self.__dict__.items():
if isinstance(v, (int, float, bool, str, datetime.datetime)):
rt[k] = v
return rt如下图迁移后就有了
