InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 04:42:59 GMT20http://www.sqlservercentral.com/Forums/Topic1090893-391-1.aspxHere you go, wrote this up for you: [url=http://sqlchicken.com/2011/04/find-table-heaps-using-policy-based-management/]Find Heaps Using Policy-Based Management[/url]Fri, 08 Apr 2011 14:41:10 GMTSqlchickenhttp://www.sqlservercentral.com/Forums/Topic1090893-391-1.aspxthanks 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.Fri, 08 Apr 2011 14:40:52 GMTArtem Ervits (@dbist)http://www.sqlservercentral.com/Forums/Topic1090893-391-1.aspxYes. [url=http://twitter.com/sqlchicken]@SQLChicken[/url] 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/ms135681Fri, 08 Apr 2011 14:03:23 GMTtroubleshootingsqlhttp://www.sqlservercentral.com/Forums/Topic1090893-391-1.aspxI 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?ThanksFri, 08 Apr 2011 13:43:51 GMTArtem Ervits (@dbist)