Knowledge Base Article

OpsCenter common custom reports

Here I will be posting custom reports, that were created by me or other forum members. All correction, improvements and optimizations to the code below are highly appreciated. If you have some useful...
Published 10 years ago
Version 1.0
Backup and Recovery
OpsCenter
nmatlock's avatar
nmatlock
Level 1
10 years ago

*This procedure used in some of my reports, make sure to add it.

Awesome post, this will be very helpful. I have a couple of questions.

  • How do you add a stored procedure.
  • Is there a way to use local variable within a query?

I have been trying to write a script with a local variable something like:

declare @averageJobSize bigint
select @averageJobSize = (select sum(domain_JobArchive.byteswritten/(1024*1024)) from domain_JobArchive where datediff(day,UTCBigIntToNomTime(domainJobArchive.endTime),getdate())<= 1)
select @averageJobSize

 

Also is there a way to view stored procedures?