Hi all.
Does anyone have a good KPI report?
I'm looking for something like this..
ClientJob TypeBackup ObjectClient StatusDays For Backup CalculationDays Backup SuccessfulSuccess Rate (%)Fileserver01MS-WindowsWIN_FSExisting Object (Backed up fo...
Hi all.
I need some help with my backup report, to group statuscode for each server if it have failed more times.
Also i can't find a solution on only get erros where no backup have return statuscode 0 or 1. ex. backup job have failed at 10:00 but ...
Hello everyone
I try to create a SQL query that shows clientname, policyname, schedulename, bytesWritten, filesBackedUp.
But since almost all jobs running as multistream backup jobs and I make a
WHERE id = parentjobid, the schdulename only apper...
Anybody who knows how to translate this tablet into something readable?
Output example:
122193504000000000;122194077000000000;122193504000000000;122194077000000000;122193504000000000;122194077000000000;122193504000000000;122194077000000000;1221935040...
Hi all.
I'm hoping for some help with this sql query, am I missing some logic in the report I want.
What I want is a report of all servers there don't have a successful backup in the last 24 hours, if a backup job failed and then completed successful...
You can do thisSELECT
B.friendlyname as 'Master Server',
A.id as 'Job ID',
A.clientName as 'Client',
A.policyName as 'Policy',
UTCBigIntToNomTime(A.startTime) as 'Start Time',
lookup_JobState.name as 'Job State'
FROM "domain_Job" A , "domain_masters...
Hi,We are using this SQL query and send it daily at a specific time.SELECT
B.friendlyname as 'Master Server',
A.id as 'Job ID',
A.clientName as 'Client',
A.policyName as 'Policy',
UTCBigIntToNomTime(A.startTime) as 'Start Time',
lookup_JobState.name ...
Hi,You can try this.Gives you how many successfully completed and failed over the past month.SELECT
count(A.clientname) AS "Successfully restored",
( SELECT count(clientname) AS "failed restored" FROM domain_Job where type = '2' and statusCode != '0'...
Is this what you need
example of the line
AND A.clientName LIKE 'moon%' OR A.clientName LIKE ' sun% '
SELECT DISTINCT A.clientName as 'Client Name', A.policyName as 'Policy Name',
LIST( DISTINCT A.statuscode) as 'Status Code',
( select ...