Query for user input items?

Alan_Foster · May 2018

Does anyone have a query on user input items, I have a request offering for new firewall request and would like to build a report of historical firewall request. I need to query the user input items like Source Server / IP Address, Destination Server / IP Address

, Port(s)

, etc. in the request offering the user enters this information which is added to the SR, MA and RA.

Roland_Kind · June 2018

Hi,

depending on your needs:

the info ist part of the viewmodell (in the Portal) : pageForm.viewModel.UserInput

or in PS Object (get-scsmclassinstance) .UserInput Property (XML formatted)

or in SCSM (ServiceManager DB View) MTV_System$WorkItem$ServiceRequest.[UserInput_75DF0BE8_3446_F616_6AC0_8510B74838AF] field

hope this helps

Justin_Workman · June 2018

@Alan_Foster

If you're looking to write a report, I think @Roland_Kind is on the right track with providing the UserInput field from the ServiceRequest table in the ServiceManager database. You'll still have to figure out how to parse the xml in that field though. If it were me, I'd probably use powershell to pull the desired work items and parse the userinput that way. This is a quick start:

$srClass = Get-SCSMClass -name system.workitem.servicerequest$

$requests = Get-SCSMObject -Class $srClass -Filter "userinput -like *"

$htmlOutput = "<html><body>"

foreach ($r in $requests) {

$htmlOutput += ("<h1><strong>" + $r.displayName + "</strong></h1>")

[xml]$UserInput = $r.UserInput

$htmlOutput += $UserInput.UserInputs.UserInput | select Question,Answer | ConvertTo-Html -Fragment

}

$htmlOutput | Out-File $env:USERPROFILE\Desktop\UserInput.html

Note that this will put an html "report" on your desktop. With a little bit of HTML styling, this could look quite nice for your needs.

Hope it helps.

Justin_Workman · May 2018

@Alan_Foster
Are you just looking for a way to parse the UserInput property of the resulting SRs from ROs?

Alan_Foster · June 2018

@Justin_Workman
These are the questions in the Request Offering, for a change to the firewall. previously this was managed with a spread sheet. I need a query to pull this info for a historical report. not sure where to find the user input data.

User Inputs

Question	Answer

Business Justification:	TEST, working on a report
Source IP Address or Name: (i.e. Server A, IP address, or All Workstations)	172.19.16.221
Port or service type: (i.e. Web-Browsing, SSL, MSSQL, port 80)	80
Destination IP Address or Name: (i.e. Server B, IP address, or All Workstations)	172.19.16.221
Is this connection required through VPN?	No
Is this permanent or temporary?	Temporary
If temporary what date do you want to remove access?	6/2/2018 12:00 AM
Does the firewall request grant access to users or groups?	Yes
Users that need access: (must select each user)	Foster, Alan
Groups that need access: (must select each group)	Accounting

Roland_Kind · June 2018

Hi,

depending on your needs:

the info ist part of the viewmodell (in the Portal) : pageForm.viewModel.UserInput

or in PS Object (get-scsmclassinstance) .UserInput Property (XML formatted)

or in SCSM (ServiceManager DB View) MTV_System$WorkItem$ServiceRequest.[UserInput_75DF0BE8_3446_F616_6AC0_8510B74838AF] field

hope this helps

Justin_Workman · June 2018

@Alan_Foster

If you're looking to write a report, I think @Roland_Kind is on the right track with providing the UserInput field from the ServiceRequest table in the ServiceManager database. You'll still have to figure out how to parse the xml in that field though. If it were me, I'd probably use powershell to pull the desired work items and parse the userinput that way. This is a quick start:

$srClass = Get-SCSMClass -name system.workitem.servicerequest$

$requests = Get-SCSMObject -Class $srClass -Filter "userinput -like *"

$htmlOutput = "<html><body>"

foreach ($r in $requests) {

$htmlOutput += ("<h1><strong>" + $r.displayName + "</strong></h1>")

[xml]$UserInput = $r.UserInput

$htmlOutput += $UserInput.UserInputs.UserInput | select Question,Answer | ConvertTo-Html -Fragment

}

$htmlOutput | Out-File $env:USERPROFILE\Desktop\UserInput.html

Note that this will put an html "report" on your desktop. With a little bit of HTML styling, this could look quite nice for your needs.

Hope it helps.

Query for user input items?

Best Answers

Answers

Query for user input items?

Best Answers

Answers

CIRESON COMMUNITY WEB SITE