{"name":"NumberOfUnclassifiedColumnsInSQLDataCatalog","description":"Shows the number of columns present in SQL Data Catlog which have no tags and on tables where the row count is greater than zero.","tsql":"SELECT COUNT(*)\r\nFROM dbo.Columns col\r\nLEFT JOIN dbo.Tables tab\r\nON tab.Id = col.TableId\r\nWHERE tab.[RowCount] <> 0\r\nAND col.Id NOT IN\r\n(\r\nSELECT ColumnId FROM dbo.ColumnTags\r\n);","instances":false,"databases":{"mode":1},"frequency":86400,"metricenabled":true,"noalertremark":"No alert required","frequency_comment":"seconds (collected every day)","rateofchange":false,"aboveorbelow":"above","_thresholds_high":{"selected":false},"_thresholds_medium":{"selected":false},"_thresholds_low":{"selected":false},"collections":1,"alertenabled":true,"targetentitytype":0}