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