Microsoft KB Archive/269105

= SMS: SMS Provider Does Not Recognize DMTF Dates Generated by ODBC Adapter =

Article ID: 269105

Article Last Modified on 10/25/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Service Pack 2

-



This article was previously published under Q269105



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 &quot;where&quot; clause, such as

SELECT SMS_R_System.Name FROM &quot;root\SMS\site_102&quot;.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&quot;

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 &quot;+000&quot; time format; it recognized only the &quot;+***&quot; 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.

Additional query words: prodsms

Keywords: kbqfe kbhotfixserver kbbug kbfix KB269105

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.