We create custom fields in our Bigfix console. (Change Request, Functional Group) as shown in attached pic.
We need to be able to pull this data into WebReports. How do we create the needed relevance to pull the data that we need? Thank you in advance for your assistance.
Orbiton,
Thank you for the info. I left out a detail… We need to be able to pull this data in a custom html report.
So we need relevance statements as my understanding… Our current relevance statement is:
<?relevance concatenations of trs
of (td of html (""
& (if (exists name of computer of it) then (name of computer of it) else ("Name Missing")) & "")
& td of (if (exists id of action of it) then (id of action of it as string) else ("ID Missing"))
& td of html ("" & (if (exists name of action of it) then (name of action of it) else ("Action Name Missing")) & "")
& td of (if (exists state of action of it) then (state of action of it) else ("Action State Missing"))
& (if (exists status of it) then (if (status of it = bes action status fixed) then (td of (html "" & status of it as string & html "")) else (if (status of it = bes action status failed or status of it = bes action status error) then (td of (html "" & status of it as string & html "")) else (td of (status of it as string)))) else (td of "Action Status Missing"))
& td of (if (exists time issued of action of it) then (((year of it as string & "-" & month of it as two digits & "-" & day_of_month of it as two digits) of date (local time zone) of it & " " & (two digit hour of it as string & ":" & two digit minute of it as string & ":" & two digit second of it as string) of time (local time zone) of it) of time issued of action of it) else ("Issued Time Missing"))
& td of (if (exists start date of action of it and exists start time_of_day of action of it) then (((year of it as string & "-" & month of it as two digits & "-" & day_of_month of it as two digits) of date (local time zone) of it & " " & (two digit hour of it as string & ":" & two digit minute of it as string & ":" & two digit second of it as string) of time (local time zone) of it) of ((start date of it as string & " " & start time_of_day of it as string) as local time) of action of it) else (if (exists time issued of action of it) then ((((year of it as string & "-" & month of it as two digits & "-" & day_of_month of it as two digits) of date (local time zone) of it & " " & (two digit hour of it as string & ":" & two digit minute of it as string & ":" & two digit second of it as string) of time (local time zone) of it) of time issued of action of it)) else ("No Start Date")))
& td of (if (exists end date of action of it and exists end time_of_day of action of it) then (((year of it as string & "-" & month of it as two digits & "-" & day_of_month of it as two digits) of date (local time zone) of it & " " & (two digit hour of it as string & ":" & two digit minute of it as string & ":" & two digit second of it as string) of time (local time zone) of it) of ((end date of it as string & " " & end time_of_day of it as string) as local time) of action of it) else ("No End Date"))
& td of (if (exists issuer of action of it and exists name of issuer of action of it) then (name of issuer of action of it) else ("Issued By Missing")))
of results whose (status of it = bes action status fixed)
of bes actions whose(
(exists end date of it and now > ((end date of it as string & " " & end time_of_day of it as string & " " & local time zone as string) as time) and now - ((end date of it as string & " " & end time_of_day of it as string & " " & local time zone as string) as time) < 120*day)
and
(
(name of it does not contain "CHG2") /*comment */
and (name of it does not contain "CHG3")
and (name of it does not contain "Reboot")
and (name of it does not contain "Custom Action")
and (name of it does not contain "pa =")
and (name of it does not contain "Post-Group Action")
and (name of it does not contain "Workstation Baseline")
and (name of it does not contain "Server Baseline")
and (name of it does not contain "Catchup Baseline")
and (name of it does not contain "Third Party Baseline")
and (name of it does not contain "Change 'pa' Setting")
and (name of it does not contain "Change 'Change Request' Setting")
and (name of it does not contain "Change 'Function' Setting")
and (name of it does not contain "Change 'Functional Group' Setting")
and (name of it does not contain "Change 'Patch Assignment Group' Setting")
and (name of it does not contain "Multiple Action Group")
and (name of it does not contain "patch group =")
and (name of it does not contain "Pre-Group Action")
and (name of it does not contain "RHEL Baseline")
and (name of it does not contain "Reset Change")
and (name of it does not contain "reset pa")
and (name of it does not contain "RESET PA")
and (name of it does not contain "set change request")
and (name of it does not contain "Set Change Request")
and (name of it does not contain "Set pa")
and (name of it does not contain "scada x")
and (name of it does not contain "SCADA PA X")
and (name of it does not contain "set PA SCADA")
and (name of it does not contain "set patch group")
and (name of it does not contain "set PAG")
and (name of it does not contain "Change 'Contact' Setting")
and (name of it does not contain "Change 'CIP Group' Setting")
and (name of it does not contain "Change 'Change Request' Setting")
and (name of it does not contain "Change 'BCA Asset' Setting")
and (name of it does not contain "scada pa= ")
and (name of it does not contain "Splunk")
and (name of it does not contain "Tripwire")
and (name of it does not contain "CIP")
and (name of it does not contain "BCA")
and (name of it does not contain "Symantec")
and (name of it != "Blank Action")
and (name of it != "Change Multiple Settings")
)
)
?>
Orbiton,
Thank you for the info. I left out a detail… We need to be able to pull this data in a custom html report.
So we need relevance statements as my understanding… Our current relevance statement is:
<?relevance concatenations of trs
of (td of html (""
& (if (exists name of computer of it) then (name of computer of it) else ("Name Missing")) & "")
& td of (if (exists id of action of it) then (id of action of it as string) else ("ID Missing"))
& td of html ("" & (if (exists name of action of it) then (name of action of it) else ("Action Name Missing")) & "")
& td of (if (exists state of action of it) then (state of action of it) else ("Action State Missing"))
& (if (exists status of it) then (if (status of it = bes action status fixed) then (td of (html "" & status of it as string & html "")) else (if (status of it = bes action status failed or status of it = bes action status error) then (td of (html "" & status of it as string & html "")) else (td of (status of it as string)))) else (td of "Action Status Missing"))
& td of (if (exists time issued of action of it) then (((year of it as string & "-" & month of it as two digits & "-" & day_of_month of it as two digits) of date (local time zone) of it & " " & (two digit hour of it as string & ":" & two digit minute of it as string & ":" & two digit second of it as string) of time (local time zone) of it) of time issued of action of it) else ("Issued Time Missing"))
& td of (if (exists start date of action of it and exists start time_of_day of action of it) then (((year of it as string & "-" & month of it as two digits & "-" & day_of_month of it as two digits) of date (local time zone) of it & " " & (two digit hour of it as string & ":" & two digit minute of it as string & ":" & two digit second of it as string) of time (local time zone) of it) of ((start date of it as string & " " & start time_of_day of it as string) as local time) of action of it) else (if (exists time issued of action of it) then ((((year of it as string & "-" & month of it as two digits & "-" & day_of_month of it as two digits) of date (local time zone) of it & " " & (two digit hour of it as string & ":" & two digit minute of it as string & ":" & two digit second of it as string) of time (local time zone) of it) of time issued of action of it)) else ("No Start Date")))
& td of (if (exists end date of action of it and exists end time_of_day of action of it) then (((year of it as string & "-" & month of it as two digits & "-" & day_of_month of it as two digits) of date (local time zone) of it & " " & (two digit hour of it as string & ":" & two digit minute of it as string & ":" & two digit second of it as string) of time (local time zone) of it) of ((end date of it as string & " " & end time_of_day of it as string) as local time) of action of it) else ("No End Date"))
& td of (if (exists issuer of action of it and exists name of issuer of action of it) then (name of issuer of action of it) else ("Issued By Missing"))
& td of (if (exists change request of it) then (change request of it) else ("Change Request Missing")))
of results whose (status of it = bes action status fixed)
of bes actions whose(
(exists end date of it and now > ((end date of it as string & " " & end time_of_day of it as string & " " & local time zone as string) as time) and now - ((end date of it as string & " " & end time_of_day of it as string & " " & local time zone as string) as time) < 120*day)
and
(
(name of it does not contain "CHG2") /*comment */
and (name of it does not contain "CHG3")
and (name of it does not contain "Reboot")
and (name of it does not contain "Custom Action")
and (name of it does not contain "pa =")
and (name of it does not contain "Post-Group Action")
and (name of it does not contain "Workstation Baseline")
and (name of it does not contain "Server Baseline")
and (name of it does not contain "Catchup Baseline")
and (name of it does not contain "Third Party Baseline")
and (name of it does not contain "Change 'pa' Setting")
and (name of it does not contain "Change 'Change Request' Setting")
and (name of it does not contain "Change 'Function' Setting")
and (name of it does not contain "Change 'Functional Group' Setting")
and (name of it does not contain "Change 'Patch Assignment Group' Setting")
and (name of it does not contain "Multiple Action Group")
and (name of it does not contain "patch group =")
and (name of it does not contain "Pre-Group Action")
and (name of it does not contain "RHEL Baseline")
and (name of it does not contain "Reset Change")
and (name of it does not contain "reset pa")
and (name of it does not contain "RESET PA")
and (name of it does not contain "set change request")
and (name of it does not contain "Set Change Request")
and (name of it does not contain "Set pa")
and (name of it does not contain "scada x")
and (name of it does not contain "SCADA PA X")
and (name of it does not contain "set PA SCADA")
and (name of it does not contain "set patch group")
and (name of it does not contain "set PAG")
and (name of it does not contain "Change 'Contact' Setting")
and (name of it does not contain "Change 'CIP Group' Setting")
and (name of it does not contain "Change 'Change Request' Setting")
and (name of it does not contain "Change 'BCA Asset' Setting")
and (name of it does not contain "scada pa= ")
and (name of it != "Blank Action")
and (name of it != "Change Multiple Settings")
)
)
?>
I’m not sure how that would make sense, as “Change Request” should be a computer property, not an action property, so if you re retrieving the property result from a computer, the same CR would show up on every action result for that computer, regardless of whether that specific action had anything to do with that CR.
Regardless, “Change Request” is a BES Property, so you’d have to loop through values of (results (BES property, BES computer)) for each computer.
