Kaseya KDB - Data Backup logs Dataset

Follow

With this query, you can create a dataset that will give you the KDB logs from Kaseya. you can then get the latest successfull, backup, backup size, backup journal, etc...

SELECT DISTINCT

vvdb_KDBLOG.agentGuid AS 'agentGuid',

vvdb_KDBLOG.MachineId AS 'Machine Id',

vvdb_KDBLOG.ComputerName AS 'Computer Name',

vvdb_KDBLOG.ReverseGroupName AS 'Reverse GroupName',

vvdb_KDBLOG.GroupName AS 'GroupName',

vvdb_KDBLOG.OperatingSystem AS 'Operating System',

vvdb_KDBLOG.OSInformation AS 'OS Information',

vvdb_KDBLOG.CurrentUser AS 'Current User',

vvdb_KDBLOG.LastLoggedOnUser AS 'Last User',

vvdb_KDBLOG.[Task Status] AS 'Task Status',

vvdb_KDBLOG.[Task Description] AS 'Task Description',

vvdb_KDBLOG.[Task Type] AS 'Task Type',

vvdb_KDBLOG.[Task Start Time] AS 'Task Start Time',

vvdb_KDBLOG.[Task End Time] AS 'Task End Time',

vvdb_KDBLOG.[Task Duration] AS 'Task Duration',

vvdb_KDBLOG.[Number Of Files In Backupset] AS 'Number Of Files In Backupset',

vvdb_KDBLOG.[Number Of Files Transferred] AS 'Number Of Files Transferred',

vvdb_KDBLOG.[Total Data Transferred Bytes] AS 'Total Data Transferred Bytes',

vvdb_KDBLOG.[Total Data Storage Used Raw Bytes] AS 'Total Data Storage Used Raw Bytes',

vvdb_KDBLOG.[Total Data Storage Used Actual Bytes] AS 'Total Data Storage Used Actual Bytes',

vvdb_KDBLOG.[Total Data Transferred Gb] AS 'Total Data Transferred Gb',

vvdb_KDBLOG.[Total Data Storage Used Raw Gb] AS 'Total Data Storage Used Raw Gb',

vvdb_KDBLOG.[Total Data Storage Used Actual Gb] AS 'Total Data Storage Used Actual Gb',

vvdb_KDBLOG.[Exception Count] AS 'Exception Count',

CASE

WHEN ((vvdb_KDBLOG.OperatingSystem = 'Windows 2000' and vvdb_KDBLOG.OSInformation not like 'Professional%') OR vvdb_KDBLOG.OperatingSystem = 'Windows 2003' OR vvdb_KDBLOG.OperatingSystem = 'Windows 2008' OR vvdb_KDBLOG.OperatingSystem = 'Windows 2012') THEN 'Server'

ELSE 'Workstation'

END AS 'Machine Type'

FROM vvdb_KDBLOG INNER JOIN vMachine ON vvdb_KDBLOG.agentGuid = vMachine.agentGuid

INNER JOIN machGroup mg ON mg.orgFK = {client_service_id} AND mg.reverseName = vMachine.groupName

INNER JOIN kasadmin.org k ON k.id = mg.orgFK