global_stats.rb
No OneTemporary
Actions

Subscribers

None

File Metadata

	class GlobalStats
	include ActionView::Helpers::NumberHelper

	def stats
	{
	Clients: Client.count,
	Jobs: Job.count,
	FileSets: FileSet.count,
	Schedules: Schedule.count,
	TotalBytes: number_to_human_size(Job.sum(:job_bytes)),
	TotalFiles: number_to_human(Job.sum(:job_files),
	units: { thousand: :K, million: :M, billion: :G },
	precision: 5, significant: false),
	Volumes: Media.count,
	VolumesSize: number_to_human_size(Media.sum(:VolBytes)),
	Pools: Pool.count,
	DatabaseSize: number_to_human_size(db_size, precision: 2, significant: false)
	}
	end

	private

	def db_size
	ActiveRecord::Base.connection.
	execute("select sum(data_length + index_length) from information_schema.TABLES where TABLE_SCHEMA='bacula';").
	first.first.to_f
	rescue
	0
	end
	end
	#Database Size