Count of view types July 30, 2007 Posted by Garth Jones select type, count(type) as ‘count’ from v_SchemaViews group by type order by type Updated: February 25, 2016 at 12:02 pm Tags: Code, SMS, SQL, System Center ◀ List of all inventory views List all Oracle Software known by SMS SP3 AssetMetrix ▶ Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment Name * Email * Website