Querying Server Configuration from the MOM Operations DB

For Day 4, just a quick heads-up on where to find useful data in the Onepoint database... MOM 2005 uses computer attributes to determine server roles (and thus group membership and rule assignment). Did you know that you can query this information from directly from the Onepoint database to retrieve server attributes for reporting purposes? For example, to pull a list of agent-managed servers and IP addresses, try the query below. select DISTINCT b.Name as Server,c.Value as [IP Address] from Instance ajoin computer b on a.instanceID = b.idComputerjoin attribute c on a.instanceID = c.instanceIDjoin classattribute d on c.classattributeID = d.classattributeIDwhere d.Description = 'IP Address for Computer' and c.Value is not NULLorder by b.Name asc And you can do this for a huge variety of attributes based on the description field in the classattribute table. You can even add your own computer attributes to collect this data for subsequent query (see my post from a few months back on gathering Active Directory Site Membership). Later this week I'll see if I can work in a query using derived tables to build a more complete server configuration report.