mirror of
https://github.com/jumpserver/jumpserver.git
synced 2025-08-17 05:37:47 +00:00
70 lines
2.3 KiB
Python
70 lines
2.3 KiB
Python
# -*- coding: utf-8 -*-
|
|
#
|
|
from collections import defaultdict
|
|
|
|
from django.db.models import Count
|
|
from django.http.response import JsonResponse
|
|
from rest_framework.views import APIView
|
|
|
|
from audits.models import PasswordChangeLog
|
|
from common.permissions import IsValidLicense
|
|
from common.utils import lazyproperty, get_logger
|
|
from rbac.permissions import RBACPermission
|
|
from reports.mixins import DateRangeMixin
|
|
|
|
__all__ = ['UserChangeSecretApi']
|
|
|
|
logger = get_logger(__file__)
|
|
|
|
|
|
class UserChangeSecretApi(DateRangeMixin, APIView):
|
|
http_method_names = ['get']
|
|
rbac_perms = {
|
|
'GET': 'audits.view_passwordchangelog',
|
|
}
|
|
permission_classes = [RBACPermission, IsValidLicense]
|
|
|
|
def get_change_password_metrics(self, queryset):
|
|
filtered_queryset = self.filter_by_date_range(queryset, 'datetime')
|
|
|
|
data = defaultdict(set)
|
|
for t, username in filtered_queryset.values_list('datetime', 'user'):
|
|
date_str = str(t.date())
|
|
data[date_str].add(username)
|
|
|
|
metrics = [len(data.get(str(d), set())) for d in self.date_range_list]
|
|
return metrics
|
|
|
|
@lazyproperty
|
|
def change_password_queryset(self):
|
|
queryset = PasswordChangeLog.objects.all()
|
|
return PasswordChangeLog.filter_queryset_by_org(queryset)
|
|
|
|
def get(self, request, *args, **kwargs):
|
|
data = {}
|
|
|
|
qs = self.filter_by_date_range(self.change_password_queryset, 'datetime')
|
|
|
|
total = qs.count()
|
|
change_password_top10_users = qs.values(
|
|
'user').annotate(count=Count('id')).order_by('-count')[:10]
|
|
|
|
change_password_top10_change_bys = qs.values(
|
|
'change_by').annotate(count=Count('id')).order_by('-count')[:10]
|
|
|
|
data['total_count_change_password'] = {
|
|
'total': total,
|
|
'user_total': qs.values('user').distinct().count(),
|
|
'change_by_total': qs.values('change_by').distinct().count(),
|
|
}
|
|
|
|
data['change_password_top10_users'] = list(change_password_top10_users)
|
|
data['change_password_top10_change_bys'] = list(change_password_top10_change_bys)
|
|
|
|
data['user_change_password_metrics'] = {
|
|
'dates_metrics_date': self.dates_metrics_date,
|
|
'dates_metrics_total': self.get_change_password_metrics(qs),
|
|
}
|
|
|
|
return JsonResponse(data, status=200)
|