re: New System Center Service Manager Webcasts

Fletcher Kelly — Mon, 07 Mar 2011 15:54:06 GMT

Hi,

I just managed to find the webcast on reporting. Amazing!!!!

I just hit a snag and my query is returning enum values and not the "string" values of my incident classifications.

The code belwo returns the correct information.

SELECT Strings.DisplayName AS Classification, COUNT(*) AS Incidents

FROM IncidentDimvw Incident

Join IncidentClassificationvw Classification ON Incident.Classification_IncidentClassificationId = Classification.IncidentClassificationId

Join DisplayStringDimvw Strings ON Classification.EnumTypeId = Strings.BaseManagedEntityId

WHERE Strings.LanguageCode = 'ENU'

GROUP BY Strings.DisplayName

Any help would be greatly appreciated.

Here is a link to the question is posted on the forum.