Using SDK Criteria for Querying Instances

Criteria offers a way of querying over instances and types with a specific filter. This post covers the different ways of using criteria to query instances. Querying over instances involves querying over specific instances or instances that are part of a relationship in a projection. There are two different classes that offer these functionalities.  …


Using ObjectQueryOptions – Configuring Object Retrieval from the CMDB, Part II

Using ObjectQueryOptions – Configuring Object Retrieval from the CMDB Part II   This is a continuation of my previous post on Microsoft.EnterpriseManagement.Common.ObjectQueryOptions. The previous post introduced the basics of object retrieval from the CMDB. In this post, I want to explain how you to get back results from the CMDB sorted in some order using ObjectQueryOptions….

0

Using Under Operator for List Queries

Suppose you want to query all hardware related incidents using the following criteria:  <Criteria xmlns=”http://Microsoft.EnterpriseManagement.Core.Criteria/”>  <Expression>    <SimpleExpression>      <ValueExpressionLeft>        <Property>$Context/Property[Type=’System.WorkItem.Incident’]/Classification$</Property>      </ValueExpressionLeft>      <Operator>Equal</Operator>      <ValueExpressionRight>        <Value>{9C46171F-64A2-B33A-FBD3-D3ED9881CDF6}</Value>      </ValueExpressionRight>    </SimpleExpression>  </Expression></Criteria>   In the above, “9C46171F-64A2-B33A-FBD3-D3ED9881CDF6″ is the ID of list “IncidentClassificationEnum.Hardware”. This criteria works as expected as long as “IncidentClassificationEnum.Hardware” does not have any child lists appended.  However, you may want…

0

Using ObjectQueryOptions – Configuring Object retrieval from the CMDB

What are some of the things you would want to think about before you query and retrieve objects from the CMDB? Here are some of them, a.      How many objects are you expecting in the database for your criteria? How will the count affect your read performance? b.      Do you want your results sorted? c.      Do you…

0

Service Manager 2010 SDK Documentation Released!

The Service Manager 2010 Software Development Kit (SDK) documentation is now released on MSDN.  There are some good code samples and most importantly all the reference documentation for the API layer. MSDN also now supports community contributions.  Please feel free to add your own comments, examples, code samples, etc! http://msdn.microsoft.com/en-us/library/gg469708.aspx


Troubleshooting the Data Warehouse: An overview

I know that troubleshooting the data warehouse can be a bit intimidating. Sometimes even figuring out where to begin to look can be difficult. In this series of blog posts, I am going to help you figure out how to troubleshoot the data warehouse. I’ll use this post as an index with links to all…


Troubleshooting the Data Warehouse: Custom data warehouse extensions don’t appear in the data warehouse

This is the latest in “Troubleshooting the Data Warehouse” series. The goal of this series is to not only help you troubleshoot specific issues you may be experiencing but also teach you more about the data warehouse. For a complete list of posts in the series, check out Troubleshooting the Data Warehouse: An overview.  …


Troubleshooting the Data Warehouse: Data Warehouse isn’t getting new data or jobs seem to run forever

This is the latest in “Troubleshooting the Data Warehouse” series. The goal of this series is to not only help you troubleshoot specific issues you may be experiencing but also teach you more about the data warehouse. For a complete list of posts in the series, check out Troubleshooting the Data Warehouse: An overview.  …


Troubleshooting the Data Warehouse: ETL failures due to login issues

This is the latest in “Troubleshooting the Data Warehouse” series. The goal of this series is to not only help you troubleshoot specific issues you may be experiencing but also teach you more about the data warehouse. For a complete list of posts in the series, check out Troubleshooting the Data Warehouse: An overview.  …


Troubleshooting the Data Warehouse: Job(s) fail after importing a custom management pack

This is the latest in “Troubleshooting the Data Warehouse” series. The goal of this series is to not only help you troubleshoot specific issues you may be experiencing but also teach you more about the data warehouse. For a complete list of posts in the series, check out Troubleshooting the Data Warehouse: An overview.  …