none
Linked Risks to tasks RRS feed

  • Question

  • Hi I would like to pull a simple report list out of the Reporting database of tasks linked to risks is this possible and which tables should I look at?

    Thanks

    Steve

    Monday, July 18, 2016 11:52 AM

Answers

  • Hi,

    You have the "dbo.MSP_WssRiskToTaskLinks_UserView" in the RDB which contains the following information including the related task/project UID. If you retrieve those UID and join it with the epm userview UID, it should return what you need.

    • AssignedToResource
    • Category
    • ContingencyPlan
    • Cost
    • CostExposure
    • CreateByResource
    • CreatedDate
    • Description
    • DueDate
    • Exposure
    • Impact
    • IsFolder
    • ItemRelativeUrlPath
    • MitigationPlan
    • ModifiedByResource
    • ModifiedDate
    • NumberOfAttachments
    • Owner
    • Probability
    • ProjectUID
    • RelatedProjectUID
    • RelatedTaskUID
    • RelationshipTypeID
    • RiskID
    • Status
    • Title
    • TriggerDescription
    • TriggerTask

    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    Monday, July 18, 2016 12:04 PM
    Moderator

All replies

  • Hi,

    You have the "dbo.MSP_WssRiskToTaskLinks_UserView" in the RDB which contains the following information including the related task/project UID. If you retrieve those UID and join it with the epm userview UID, it should return what you need.

    • AssignedToResource
    • Category
    • ContingencyPlan
    • Cost
    • CostExposure
    • CreateByResource
    • CreatedDate
    • Description
    • DueDate
    • Exposure
    • Impact
    • IsFolder
    • ItemRelativeUrlPath
    • MitigationPlan
    • ModifiedByResource
    • ModifiedDate
    • NumberOfAttachments
    • Owner
    • Probability
    • ProjectUID
    • RelatedProjectUID
    • RelatedTaskUID
    • RelationshipTypeID
    • RiskID
    • Status
    • Title
    • TriggerDescription
    • TriggerTask

    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    Monday, July 18, 2016 12:04 PM
    Moderator
  • thanks Guillaume, this has worked perfectly!

    cheers

    Steve

    Monday, July 18, 2016 12:58 PM