3 Replies Latest reply: Oct 15, 2012 12:49 AM by Sagar RSS

    Get IT Resource name from Resource name

      I have some Resource name (example AD User) and I need to get IT Resource name of this resource.
      How I can do this using APIs?
        • 1. Re: Get IT Resource name from Resource name
          Dhananjay Neeraj2
          It is not possible straight forward...
          However, there is a way...

          You can use SQL Query....

          Use Join --> Resource (OBJ table) --> Then PKG table (For Provisioning Process Definition) --> TOS table --> Then SDK_KEY --> SDK table (Process Form)--> Then SDC (Means Column Name of Process Form) -->. SDC_KEY --> Then SDP --> (SDP table means Process Form Column Name's properties) --> Then SVR_KEY...

          Happy SQL Query Writing....
          • 2. Re: Get IT Resource name from Resource name
            Nishith Nayan
            There is no Direct method to achieve this. Because IT resource is no where attached with RO. IT Resource is attached wih Process form .
            So, It can be achieved by 2-3 API/method.
            Write approach is to have a sql query as other poster has suggested here.
            • 3. Re: Get IT Resource name from Resource name
              If resource is provisioned, then one way can be -

              Use getProcessFormData method of tcFormInstanceOperationsIntf
              Once process form data is available with you, iterate through the data and get required IT Resource.

              To use this method you need to provide process instance key.

              Refer below link for more details-