Querying Sysman Schema

Target Type Summaries

-- Target Types by Count Descending
select target_type, count(*) from mgmt_targets group by target_type order by 2 desc;

-- Target Types by Name
select target_type, count(*) from mgmt_targets group by target_type order by 1;

References

Sagar Patil article on Querying SYSMAN schema