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

Policy Based Management - is it possible to combine Facets? Expand / Collapse
Author
Message
Posted Friday, April 8, 2011 1:43 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 5, 2012 8:08 AM
Points: 19, Visits: 136
I need to run a policy and exclude a certain set of servers that have databases that contain heaps. Is there a way to combine more than one facet or condition in a policy?

Thanks
Post #1090893
Posted Friday, April 8, 2011 2:03 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 11:42 AM
Points: 20, Visits: 64
Yes. @SQLChicken already replied to this on the #sqlhelp hashtag on Twitter. Create condition for facet TABLE and use property of @HasClusteredIndex = True.

Reference: http://msdn.microsoft.com/en-us/library/ms135681


This posting is provided "AS IS" with no warranties, and confers no rights.
My Blog: TroubleshootingSQL
Twitter: @banerjeeamit
Post #1090907
Posted Friday, April 8, 2011 2:40 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 5, 2012 8:08 AM
Points: 19, Visits: 136
thanks I just got it to work also, I was doing it a mad scientist way when I could've just added hasclusterdindex with hascompressedpartitions, thanks for the reply.
Post #1090939
Posted Friday, April 8, 2011 2:41 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 14, 2014 3:50 AM
Points: 137, Visits: 650
Here you go, wrote this up for you: Find Heaps Using Policy-Based Management

=============================================================
/* Backups are worthless, Restores are priceless */

Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
Post #1090940
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse