SCCM2007 DCM Reporting Issue in Multi-Language environments
In SCCM2007, the Configuration Baselines or Items do store the LocaleID (Language Code) from the System where they are created.
If you have the SCCM Admin Console installed on a System with a different OS Language than the language of SCCM on the Primary Server, be aware that Configuration Baselines and Items created on that System will not work properly (mainly Web-Reporting)...
Most of the DCM Reports are linked with the View "v_LocalizedCIProperties_SiteLoc" which does lookup for ConfigItems with the same LocaleID as on the SCCM Server.
SQL statement of v_LocalizedCIProperties_SiteLoc:
select loc.*
from SMSData sms
cross apply fn_LocalizedCIProperties(sms.LocaleID) loc
The View will not report instances if the CI's do have a different LocaleID.
Workaround1:
Change the Queries of the DCM reports to use the view "v_LocalizedCIProperties" instead of "v_LocalizedCIProperties_SiteLoc"...
Workaround2:
Change the LocaleID of the CI's by editing the SQL table "CI_LocalizedProperties" to the same LocaleID as in dbo.SMSData.LocaleID....
Workaround3:
Modify the CI's (like changing the name) with the Admin Console on the SCCM Server (this will create an additional object in dbo.CI_LocalizedProperties)...