Change Management dashboard

Hi

For the service manager/cireson portal environment I am working in. We are developing a change management dashboard that pulls data directly from the service manager database. We're wondering however, has anyone else made a dashboard like this? Also we're worried about the impact to the database and portal performance something like this would be. Currently the CPU on the DB server runs at about 90 percent through out the whole business day. I haven't been told the interval of how often the data would be accessed but my guess is every half an hour. The information we'd be pulling out is:

Change ID

Change Title

Activity Type (Manual/Review)

Activity Status

Activity Title

Activity Assigned User

Change Assigned User

Priority

Category

Affected User

Change Support Group

Scheduled Start Date

Scheduled Downtime Start Date

Activity Created Date

3 replies