Expansion "map prompts"

Roman_NepomniashchiiRoman_Nepomniashchii Customer IT Monkey ✭
When creating Request Offering, I have "Map Prompts". I have only default fields examples: "Status", "Priority", "Title", "Description". I need create customs fields and create table in DB, where value from custom fields will be recorded. How can this be done? I know that cireson did something similar in the application Advance Request Offering, but they create one field, I need create custom field for each form in my request. Thank you all for your help.

Tagged:

Best Answers

Answers

  • Nick_FlintNick_Flint Customer Adept IT Monkey ✭✭
    Accepted Answer
    @Roman_Nepomniashchii It sounds like you need to extend the Service Request work item to add your custom properties. There is a pretty good guide here: https://gallery.technet.microsoft.com/Guide-SCSM-Extending-Work-65f29540 that may help. 
  • Geoff_RossGeoff_Ross Cireson Consultant Super IT Monkey ✭✭✭✭✭
    Accepted Answer
    Hi @Roman_Nepomniashchii,

    Agree with @Nick_Flint you need to add a custom ManagementPack to extend the Service Request Class. Another method to the Authoring Tool, is the Visual Studio Authoring Extenstions (VSAE)

    Download: https://www.microsoft.com/en-gb/download/details.aspx?id=30169
    Wiki (focuses on SCOM but same principals): https://social.technet.microsoft.com/wiki/contents/articles/5236.visual-studio-authoring-extensions-for-system-center-2012-operations-manager.aspx
    Good video by my friend @Lee_Berg:

    Geoff

  • Roman_NepomniashchiiRoman_Nepomniashchii Customer IT Monkey ✭
    @Nick_Flint
    @Geoff_Ross
    Thank you for the information provided, I will try to make this extension.
  • Roman_NepomniashchiiRoman_Nepomniashchii Customer IT Monkey ✭
    edited August 21
    @Geoff_Ross
    I expanded the class, made a new field "TESTFIELD" and mapping a data field to it, but I do not see in which database table the field I created was created "TESTFIELD". maybe the reason is that I'm using Advance Request offireing? sorry for my English

  • Geoff_RossGeoff_Ross Cireson Consultant Super IT Monkey ✭✭✭✭✭
    Roman,

    Are you looking in the actual SQL Database using SQL Server Management Studio?
    Your new class will have its own table, referencing the BaseId of the SR and your new column. You will need to Join to the main SR Table. There will also be a SQL View that does that for you.

    Or do you mean, you cannot see the data on the SR form. In which case you need to also customise the form to show that field. This is very easy for Portal and much harder for console. Which are you using?

    Geoff
  • Roman_NepomniashchiiRoman_Nepomniashchii Customer IT Monkey ✭
    edited August 21
    @Geoff_Ross
    It's about the actual base in the managemant studio. "Your new class will have its own table, referencing the BaseId of the SR and your new column" - what name this new table, where it? 

    About SR form I understand, I need management studio, Thank's
  • Geoff_RossGeoff_Ross Cireson Consultant Super IT Monkey ✭✭✭✭✭
    The name of the table will be based on the name of the class (the internal name, not display name) 



    My class is called Sandpit.ServiceRequest.Extensions.UserInput.Class
  • Roman_NepomniashchiiRoman_Nepomniashchii Customer IT Monkey ✭
    edited August 21
    @Geoff_Ross ;And it is possible as that to transfer this table in a DB servicemanagement? Does the cache builder service migrate by default the extension of the class to DB servicemanagement? I need to sample from the database
Sign In or Register to comment.