Hello
I am a beginner with VBR and made now some tests with VBR, my first question is over a sql query for that I have received the following sql command,
But if I use this command I always receive error that the sql query statement was not good, I don’t really know where I should insert the included params,
Therefore I would ask you can anybody check my sql command, I don’t know with what I should change the cracter ? in this statement,
Sorry I am not a sql specialist
params: [2009-07-29 09:54:31.936, 9, 2009-07-29 09:54:31.936, 2009-07-29 09:54:31.936, 2, 0, 0]
SELECT YEARS(backupFinalJobEndTime) AS yearXCol, MONTH(backupFinalJobEndTime) AS monthXCol, DAY(backupFinalJobEndTime) AS dayXCol, backupFinalJobClientObjectID
AS reportColumn0, reportColumn0DisplayTable.objectPrimaryDisplayName AS reportColumn0Display, backupFinalJobStatus AS reportColumn1, backupFinalJobLevel
AS reportColumn2, backupPolicyName AS reportColumn3, backupFinalJobBackupScheduleID AS reportColumn4, reportColumn4DisplayTable.backupScheduleName
AS reportColumn4Display, SUM(CAST(backupSubJobSize AS NUMERIC(30, 6))) AS reportColumn5, (3) AS dataGroupID FROM Object reportColumn0DisplayTable, BackupSchedule
reportColumn4DisplayTable, BackupFinalJob, BackupSubJob, BackupPolicy WHERE DATEDIFF(day, backupFinalJobEndTime, ?) <= ? and backupFinalJobEndTime <= ? AND
DATEDIFF(day, backupFinalJobEndTime, ?) >= ? AND backupFinalJobClientObjectID = reportColumn0DisplayTable.objectID AND backupFinalJobBackupScheduleID = reportColumn4DisplayTable.backupScheduleID
AND backupFinalJobType IN (?) AND backupFinalJobDataType IN (?) AND backupPolicyID = backupFinalJobBackupPolicyID AND backupFinalJobID = backupSubJobBackupFinalJobID
GROUP BY yearXCol, monthXCol, dayXCol, reportColumn0, reportColumn0Display, reportColumn1, reportColumn2, reportColumn3, reportColumn4, reportColumn4Display ORDER BY 1, 2, 3, 6 DESC, 7 DESC, 12
bye
Oezkan