OK so here's the SQL Server 2000 inventory MOF edit. It's not as pretty as the SQL 2005 one, but it gets the job done. I honestly don't remember if the display name registry key for SQL Server 2000 shows the installation edition if it's not Standard Edition (this display name only shows SQL Server 2000 and I inventoried a SQL Server 2000 Standard installation here).
These edits work with SMS 2003 as well as Configuration Manager 2007 and I've actually modified the edits to account for SMS 2003 in this posting (the #pragma namespace change lines aren't needed for Configuration Manager 2007 as the data classes are in a totally separate file (Configuration.mof) from the reporting classes (SMS_def.mof)).
This inventory modification will tell you at least if a computer has the full version of SQL Server 2000 installed, just the client tools, or both.
Hope it helps,
Data Class
#pragma namespace ("\\\\.\\root\\cimv2 ")
//-----------------------------------
// Begin SQL Server 2000 Data
//-----------------------------------
[DYNPROPS]
Class SQLServer2K
{
[Key] String Component = "";
String DisplayName;
String ClientToolsVersion;
};
//Declare the instances
[DYNPROPS]
Instance of SQLServer2K
{
Component = "SQL Server Installation";
[PropertyContext("local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\80\\MSSQLLicenseInfo\\MSSQL8.00|DisplayName"),
Dynamic, Provider("RegPropProv")] DisplayName;
};
[DYNPROPS]
Instance of SQLServer2K
{
Component = "SQL Server Client Tools Version";
[PropertyContext("local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\80\\Tools\\ClientSetup\\CurrentVersion|CurrentVersion"),
Dynamic, Provider("RegPropProv")] ClientToolsVersion;
};
Reporting Class
#pragma namespace ("\\\\.\\root\\cimv2\\SMS")
//-------------------------------------
// Begin SQL 2000 Reporting Class
//-------------------------------------
[SMS_Report (TRUE),
SMS_Group_Name ("SQL Server 2000"),
SMS_Class_ID ("MICROSOFT|SQLServer2K|1.0")]
Class SQLServer2K : SMS_Class_Template
{
[SMS_Report (TRUE),Key] String Component;
[SMS_Report (TRUE)] String DisplayName;
[SMS_Report (TRUE)] String ClientToolsVersion;
};
Resource Explorer screen shot:
You can get this MOF edit (as a .txt file) by right clicking HERE and selecting Save As...