Statistics on logged calls
Best Answers
-
Geoff_Ross Cireson Consultant O.G.Hi Martin,
Totally possible (we're talking about dashboard designer right?)
Create a SQL chart with a SQL query, bringing in the work items you want to chart from the WorkItem table. Make sure you include Id (this is needed if you want to drill into the chart) and CreatedBy in your select statement and then group by CreatedBy.
Just shout if you need any more help with this.
Geoff
5 -
Geoff_Ross Cireson Consultant O.G.Martin.
It came in version 6. You an check the version at the top of the admin settings page.
If you have an older version (and can't upgrade) this is still possible via a custom page but if the sort of thing you would need a professional services engagement for.
Geoff5
Answers
Totally possible (we're talking about dashboard designer right?)
Create a SQL chart with a SQL query, bringing in the work items you want to chart from the WorkItem table. Make sure you include Id (this is needed if you want to drill into the chart) and CreatedBy in your select statement and then group by CreatedBy.
Just shout if you need any more help with this.
Geoff
It came in version 6. You an check the version at the top of the admin settings page.
If you have an older version (and can't upgrade) this is still possible via a custom page but if the sort of thing you would need a professional services engagement for.
Geoff
Ah! We're way behind! We're on Current Portal Version: 5.0.5.0 . I'll need to check first if we can upgrade then.
Wow, yes that is quite behind. I recommended you at least get to the latest hotfix for that version. 5.0.10. It will be a bit more stable than 5.0.5
I would also suggest you build a test SCSM environment or at least a test portal server + database to try version 6.
Geoff
List of versions with links to the UR updates: http://social.technet.microsoft.com/wiki/contents/articles/4226.system-center-service-manager-list-of-build-numbers.aspx
OR... it means that you are looking at the version generated by the authoring tool (assuming no update of those MP's as you have upgraded your servers) or simply the minimum version shown within certain management pack references.
I'll jump back out of the conversation now, but I couldn't sit back and not say something about this one.
v6 does not require a specific version of Service Manager so you are good to go right now but as per @Tom_Hendricks I would seriously recommend patching to UR9 ASAP. if you really are running that version.
The best place to look to confirm is in Programs and Features, look for the version number of Service Manager. Don't look in Help -> About as that always shows 7.5.3079.0
Also check across all your management servers, data warehouse management server and console installations as the only thing worse than an old version, is a miss-match of versions.
The UR patches are cumulative, so you only need to apply the latest across everything to get in a good place.
We've gone off topic here but as Tim indicated, this is kind of important.
As for the dashboarding, feel free to get back in touch when you are on v6 (even in your test environment) and we can figure this one out.
Geoff