Expansion "map prompts"
Roman_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.
0
Best Answers
-
Nick_Flint
Customer Advanced IT Monkey ✭✭✭
@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.1 -
Geoff_Ross
Cireson Consultant O.G.
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:
https://www.youtube.com/watch?v=w1TQSSJmozc
Geoff
1 -
Geoff_Ross
Cireson Consultant O.G.
Hi Roman,
Unfortunately, custom properties do not get cached to the ServiceManagement database.
You can query ServiceManager directly though.
Geoff5
Answers
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
@Geoff_Ross
Thank you for the information provided, I will try to make this extension.
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
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
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
My class is called Sandpit.ServiceRequest.Extensions.UserInput.Class
Unfortunately, custom properties do not get cached to the ServiceManagement database.
You can query ServiceManager directly though.
Geoff