Announcing two new 300-level TechNet webcasts on Service Manager 2010:
These two new webcasts add on to the Service Manager webcast series we originally announced and conducted. If you did miss any of the live webcasts, follow the hyperlink to access the recording.
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.
social.technet.microsoft.com/.../d50ac549-969c-405b-96bc-2c5f54e827b0