Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Not able to Evaluate policies on Multiple servers PBM SQL 2008 Expand / Collapse
Author
Message
Posted Monday, November 30, 2009 4:32 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:52 PM
Points: 417, Visits: 764
Im trying to evaluate policies on multiple instances but I'm keep getting "No targets found" message. In my Serverlist condition, selected the following.

Facet: Server
Condition: @InstanceName ='InstanceName1'
OR
@InstanceName ='InstanceName2'

Am i doing right? anybody alreay worked on this? Please help me out.

Thanks
Jay.


Thanks
Jay
http://www.sqldbops.com
Post #826417
Posted Tuesday, December 1, 2009 3:28 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:49 AM
Points: 1,155, Visits: 4,643
Possible Errors

* No targets found
The target set could be empty due to any of the following reasons:
o There are no targets on the instance of SQL Server of the type specified by the policy.
o The server restriction might exclude the instance of SQL Server that contains the target.
o If the policy is on an object in a database (for example a table, view, or user) the database might not subscribe to the category of the policy.
o The target-set filter might exclude all targets on this instance of SQL Server.
o The target server type is different from the server type on which the policy is evaluated. For example, in the Database Engine, if you try to evaluate a policy that has been created for Analysis Services, you will receive an empty target set


See the MS link:
Evaluate Policies


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #826540
Posted Thursday, December 3, 2009 1:11 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:52 PM
Points: 417, Visits: 764
Thanks for your tip Muthu.

I'm able to evaluate the policy on multiple instances through registered servers group. Also I'm looking for the purpose of Server facet on Server Restriction column.

If anybody worked or have examples please update me.

Thanks
Jay.


Thanks
Jay
http://www.sqldbops.com
Post #828469
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse