managedentity, managedentitytype etc

Discussion:

(too old to reply)

m***@yahoo.com

2009-05-07 21:46:29 UTC

Could some one know and tell me what are all these managedentity*.*
tables and views are?
Is there any doc regarding the database of SCOM?
I am desperatley looking for ways to find out which tables or view has
computer/server display names.

Thanks a lot

Pete Zerger (MVP)

2009-05-07 23:05:23 UTC

Permalink

The database schema for the operational database is not published. Any reason
you would not simply do this through Powershell?

If you are looking for data warehouse samples for reporting, check the OpsMgr
Report Authoring Guide or some of Daniel Savage blog posts

http://blogs.technet.com/momteam/archive/2008/04/11/using-the-data-warehouse-part-2-event-data.aspx

Regards,

Pete Zerger, MCSE(Messaging) | MCTS(SQL 2005) | MCTS(Opsmgr) | MVP - Opsmgr

MP Catalog: http://www.systemcenterforum.org/mps
Tools: http://www.systemcenterforum.org/tools
User Group: http://www.systemcenterusergroup.com

Post by m***@yahoo.com
Could some one know and tell me what are all these managedentity*.*
tables and views are?
Is there any doc regarding the database of SCOM?
I am desperatley looking for ways to find out which tables or view has
computer/server display names.
Thanks a lot

Andrew T, Qualcomm

2009-05-08 17:48:23 UTC

Permalink

The table you're looking for is BaseManagedEntity. The fields you're
interested in are:
BaseManagedEntityID: this is the GUID that SCOM07 uses to refer to the
entity.
BaseManagedTypeID: this is the type of object the entity refers to (I'll
leave it up to you to figure out what's what)
FullName: The ugly full-path/name for an entity (like
Microsoft.Windows.Server.2003.LogicalDisk:dbasandbox2.na.qualcomm.com;C:)
DisplayName: The short or friendly name for an entity.

There's a huge warning, though, this table has MUCH MORE than just the
machines in it, like individual logical drives, groups, database instances,
and other ugliness. You can do a JOIN'ed query with the ManagedType table to
find just Windows systems, etc.
--
Andrew T, Qualcomm

Vitaly Filimonov [MSFT]

2009-05-17 18:20:47 UTC

Permalink

We do not support people querying Operational (OperationsManager) db
directly. However, we do support querying the DW as long as you query views.
The view you're looking for is vManagedEntity - that thing contains all the
objects in the system (computers, groups, logical disks, etc).

If you'd like to query for particular type of object you can examin
vManagedENtityType view and join to vManagedEntity and set
ManagedEntityTypeRowId to a value you want.

Naturally, some other views have important information. Those are
vManagedENtityProperty and vManagedEntityPropertySet for object properties
and vManagedEntityManagementGroup to see lifetime of the object.

If you want to query, say, all members of a certain group, you'll need to
understand that objects have "relationships" between them. That's
vRelationship view. Say, given a group that contains computers you can get
ID of the group by querying vManagedEntity view by DisplayName (of the
group) and figuring out its ManagedEntityRowId. Then query vRelationship
where SourceManagedEntityRowId is equal to your group's Id and
TargetManagedEntityRowId will give you the computer's Ids. There are some
caveats to this process (if your group contains subgroups of if you are
looking for logical disks on computers in a group, etc) but the process
generally is the same.

Thanks,
Vitaly
--
-------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm