How to check if a resource plan is checked out in the PSI. RRS feed

  • Question

  • I've tried searching before but I couldn't find a clear cut way of telling if a resource plan is checked out or not.

    One thing I found is the ReadResourcePlanStatus method but this does not tell you if a plan is checked out or not.

    It only has states Absent, Working (in a draft state) and Published (in a published state).

    Looking at SQL Server, I found a column called RESPLAN_CHECKOUTBY in dbo.MSP_RESOURCE_PLANS and I think this is perfect for what I need. If it is null then that means its checked in and if not then it is checked out.

    What is the easiest way of accessing this through the Resource Plan service?

    Wednesday, February 12, 2014 7:38 PM

All replies

  • Hi.

    There is no PSI function which exactly returns the checkout status of a Resource Plan.

    Anyhow you can use the CheckOut ResourcePlan method. If it fails you know that the plan is already checked out.

    ResourcePlan.CheckOutResourcePlan Method:

    ResourcePlan reference:


    Sunday, March 9, 2014 2:34 PM