SMS: SMS Provider Does Not Recognize DMTF Dates Generated by ODBC Adapter (269105)

SYMPTOMS

The SMS provider does not recognize Distributed Management Task Force (DMTF) dates that are generated by the Windows Management Instrumentation (WMI) Open Database Connectivity (ODBC) adapter.

CAUSE

All dates and times in WMI use the format designed by the DMTF. When the WMI ODBC driver is presented with a SQL query that uses a DATETIME field in the "where" clause, such as

SELECT SMS_R_System.Name FROM "root\SMS\site_102".SMS_R_System SMS_R_System
WHERE (SMS_R_System.AgentTime>{ts '2000-06-01 00:00:00.000000'})

it converts the query to WMI Query Language (WQL) format with the DATETIME field in DMTF format:

SELECT Name FROM SMS_R_System
WHERE AgentTime > 2000601000000.000000+000"

This WQL query does not work in the SMS provider for two reasons:

Literal values compared against SMS_R_System.AgentTime are not treated as time values.
The provider does not recognize the "+000" time format; it recognized only the "+***" format.

RESOLUTION

To resolve this problem, obtain the latest service pack for Systems Management Server version 2.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

288239 SMS: How to Obtain the Latest Systems Management Server 2.0 Service Pack

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Systems Management Server 2.0 Service Pack 3.