Home Dashboard Directory Help
Search

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


Status: 

Active


1
0
Sign in
to vote
Type: Suggestion
ID: 649944
Opened: 3/7/2011 8:29:02 AM
Access Restriction: Public
0
Workaround(s)
view

Description

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.
Details
Sign in to post a comment.
Posted by Microsoft 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,
Eric
Posted by Microsoft 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.


Hongfei

Sign in to post a workaround.