PBM - Enable the ability to pass more parameters to ExecuteSql() - by Phil Brammer

Status : 


Sign in
to vote
ID 649944 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 3/7/2011 8:29:02 AM
Access Restriction Public


It would be great if it were possible to pass parameters to the ExecuteSql() function when building a custom PBM condition.

For instance, the Databases facet does not allow the ability to check for offline databases because they must be accessible in order for a policy to be evaluated.

So, if I want to write a custom condition to check for this, I would like to be able to do:
ExecuteSql('numeric','select status from sys.databases where database_id = @ID')

where @ID is the property available under the Database facet.
Sign in to post a comment.
Posted by Eric [MSFT] on 6/4/2012 at 11:09 AM
This report is closed as a duplicate since there is a tracking item for the same request from customer.

Best Regards,
Posted by Hongfei [MSFT] on 3/9/2011 at 5:19 PM
Hello Phil,

Thank you for submitting the feedback. We will consider it for next major release. Meanwhile, the workaround is to have the (database, status) pair written to a string and return it.