5 Replies Latest reply on May 4, 2009 2:51 PM by jnathlich

    Stored Procedue to populate custom property

      Does anyone have any experience using a stored procedure on their SQL server to populate a custom property on a recurring schedule?

      For example, I want to create a custom property with a floating value that contains the delta of the volume space used over the past hour.  I want to populate this value every 60 minutes using a stored procedure which calcluates this delta.

      I have the SQL query for this and I do it outside of Orion in a static report.  I would like to move it into a custom property so I can alert based on this value.