[SQL & SCOM] Retrieve discovered inventory for a class from OperationManager DB

Retrieve table used (and view) used to store the informations for your class

select TypeName, ManagedTypeTableName, ManagedTypeViewName, IsDeleted  from ManagedType
where TypeName LIKE 'MyClassName'

Result will be like :

TypeName	ManagedTypeTableName	ManagedTypeViewName	IsDeleted
MyClassName	MT_CLS1_O	MTV_CLS1_N	0

Discovered inventory can be also retrieved by using the view :

select * from MTV_CLS1_N

This posting is provided "AS IS" with no warranties.