Type Projections Management Pack

October 25, 2013 Posted by Alexander Axberg

(Last update, 2014-09-09)

A couple of years ago, Travis released some excellent Management Packs containing several different Type Projections for a specific type of Work Items, which you could use to speed up the Query in your views instead of using the “(advanced)” type projections. Very useful.

The one for Change Requests is located here: http://blogs.technet.com/b/servicemanager/archive/2011/09/19/new-change-request-type-projections-management-pack.aspx
and for Incidents: http://blogs.technet.com/b/servicemanager/archive/2010/12/02/faq-why-is-my-custom-incident-view-so-slow.aspx

So what I’ve done is to gather all of these  type projections and put them all in the same Management Pack (and added some own too).

The Management Pack i sealed, so you can use these type projections in any view you want, regardless of what Management Pack the view is stored in. You can download it at the bottom of the post.

It will probably be updated in the future with more useful type projections

The following type projections are included in the pack:

Incident (Primary Owner)
Incident (Affected User)
Incident (Assigned To User)
Incident (Created By User)
Incident (Resolved By User)
Incident (Closed By User)
Incident (Assigned and Affected User)
Incident (Assigned To, Affected, and Primary Onwer User)
Incident (Assigned To, Affected, Primary Owner, Created By User)
Incident (Assigned To, Affected, Primary Owner, Created By, Resolved By User)
Incident (Assigned To, Affected, Primary Owner, Created By, Resolved By, Closed By User)
Incident (Created By, Resolved By, Closed By)
Incident (Created By, Assigned To, Resolved By, Closed By)
Incident (Created By, Assigned To, Primary Owner, Resolved By, Closed By)
Incident (Related Work Items)
Incident (Related Work Items, Assigned To, Affected User)
Incident (Related Knowledge Articles)
Incident (Affected Services)
Incident (Affected Configuration Items)
Incident (Related Manual Activities)
Incident (Affected User, Assigned To, Related CIs – both ways)
Incident (Affected User, Assigned To, SLA)
Incident (SLA, Affected, Assigned To)
Incident (SLA, Affected, Assigned To, Affected Services)
Problem (Assigned To)
Problem (Affects Service)
Problem (Related WorkItems)
Change Request (Created By, Assigned To, Affected User)
Change Request (Created By User)
Change Request (Assigned To User)
Change Request (Affected User)
Change Request (Assigned To, Affected User)
Change Request (Created By, Affected User)
Change Request (Created By, Assigned To User)
Change Request (Activities)
Change Request (Related Work Items)
Change Request (Related Configuration Items)
Change Request (File Attachments)
Change Request (Knowledge Articles)
Change Request (Activity, Assigned To)
Service Request (Assigned To, Affected User)
Service Request (Activity)
Service Request (Related Configuration Items)
Service Request (Affected User)
Service Request (Assigned To)
Service Request (Related Work Items)
Service Request (Activity, Assigned To)
Service Request (SLA, Affected, Assigned To, Affected Items)
Service Request (Knowledge Articles)
Service Request (Affected Items)
Service Request (File Attachment)
Service Request (Assigned To, Affected User, Created By)
User (Manager, Reporting)
Manual Activity (Created By, Assigned To)
Manual Activity (Parent WI Assigned To)
Manual Activity (Parent WI Assigned To, Assigned To)
Service (Owned By, Service Customers, Affectes Users)

Lumagate.TypeProjections1.0.0.26

13 Responses to Type Projections Management Pack

  1. Dries says:

    Thx for this, was looking for an update on the original MP from Travis.

  2. Mike says:

    Is it possible to get the Affected Config Items for Service Requests?

  3. RW says:

    For related or contained activities it seems you can filter on these but not add them to the display. I want a view that shows each activity and its progress under each change. I thought the Change Request (Activities) would do this but may be I need a different kind of TypeProjection. Any thoughts?

    • Hi
      The “Contains Activity” relation used for connecting the Activities to the Change is a many-to-one relation, and these types of relations are not selectable under Display when editing a view, just because they can contain several objects.
      This is by-design in the console, so it’s not a limitation in the Type Projection.

      /Alex

  4. Christopher says:

    Hi,
    I was wondering if it was possible to create a view of manual activities with a column of the assigned user on the service request it was associated with.

    Thanks for any help in advance,
    Warmest Regards,
    Chris

  5. Martin says:

    Perfect work but I have problem with Incident (SLA, Affected, Assigned To)and
    Incident (SLA, Affected, Assigned To, Affected Services). I cannot use SLA information in views as a Display Columns. I do not know why. I can use it as a criteria. Is there any way how to use it in display columns?

    Thanks

    • Hi,

      That’s correct, the console is unable to display SLA information for display columns, so the only way is to create the columns is by writing them directly in XML in the Management Pack.

      regards
      Alex

  6. Pingback: Creating a View for the Primary Owner - AutoMagically - Site Home - TechNet Blogs

  7. Pingback: How to create a Basic Configuration Item View and Type Projection showing Computers with their Primary User and Custodian (owner) - Stay Classy, With System Center Ramblings from San Diego - Site Home - TechNet Blogs

  8. Ray says:

    Hi, Could you add one more type projection?
    I need Service Request with (Assigned To, Affected User and Created By)

    Thanks,
    Ray

  9. Khaledmgz says:

    Hi Alexander,
    Good Job.

    I have a question, how can I create similar type projection MP for the customized “User-Picker” fields?

    Many Thanks in Advance and Best Regards

Leave a Reply

Your email address will not be published. Required fields are marked *

*