• State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 96 subscribers
  • Views 1871 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Help with script to create IT Shop requests from direct assignment of Entitlements/System roles

QOS
over 6 years ago

We have several of system roles in our environment where membership/added users have been added via import to PersonHasEset table. So, the system role has been directly assigned and no IT Shop request has been created.

I need help to with a script of how to create IT Shop requests for some of those system roles. A script for selected System Roles so i can test this on some selected System Roles and one final script to create IT Shop requests of all System Role assignment where there are no IT Shop request already.

I have read the section in IT Shop manual "Methods for Transforming Direct Assignments into Requests" but I didn't get much out of it. So if someone could give me the script code for creating Requests out of selected System Roles and one for creating all system roles assignments to requests. 

Thanks in advance. 

Parents
  • 0 over 6 years ago

    Hi,

    You can create request in personwnatsorg by creating an shoppingcartorder(HandleObjectComponent - CallMethod).

    For that you need to assign an event to personhaseset table 

    where clause is as follows

    Dim f As ISqlFormatter = Connection.SqlFormatter
    Value = f.Comparison("XObjectKey", $XObjectKey$, ValType.String,VI.DB.CompareOperator.Equal ,VI.DB.FormatterOptions.None)

  • 0 over 6 years ago in reply to badebaji sayyad

    Hi and thanks for your answer.

    By doing this, this only will only affect new inserts to the PersonHasEset table, right?

Reply Children
No Data