Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

SQL Query Veritas Backup Reporter

Updated: 21 May 2010 | 1 comment
ADmiNX's picture
0 0 Votes
Login to vote

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

Discussion Filed Under:

Comments

payners's picture
10
Aug
2009
0 Votes 0
Login to vote

You need to put parameters

You need to put parameters into your query where the ?'s are.

The parameters used when you ran the report through the GUI were listed right above in the log you retrieved this from:

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]