| Page Properties | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
| # | Requirement | User Story | Importance | Challenge | Notes |
|---|---|---|---|---|---|
| 1 | Mid Server | Update Mid-Server Parameters |
| ||
| 2 | security patch Level |
To capture the attribute security patch level. We will need to use 'OPatch' and 'lsinventory' commands which lists all the patches applied to the oracle db and then parse the latest patch that has been applied. You will have to add a 'extension section' to the oracle pattern, to add extra steps to run this command, and then parse the output, to extract the value you want to put in the attribute/ field of the CI. Here is the pattern.
|
Probes
| Oracle Probes |
|---|
Oracle Instance
|
...
| License Type | u_license_type | false | String | (empty) | 40 | false | |
| SDR # | u_last_sdr_number | false | Integer | (empty) | 40 | false | |
| Justification | justification | false | String | (empty) | 80 | false | |
| Oracle Home | oracle_home | false | String | (empty) | 255 | false | |
| Functional Owning Organization | u_functional_owning_org | false | String | (empty) | 40 | false | |
| Edition | edition | false | String | (empty) | 100 | false | |
| Hosting | u_hosting | false | String | (empty) | 40 | false | |
| Assigned to | assigned_to | false | Reference | User | 32 | false | |
| Target Cloud Deployment | u_target_cloud_deployment | false | String | (empty) | 40 | false | |
| DR Plan Next Testing Date | u_dr_plan_next_test | false | Date | (empty) | 40 | false | |
| DR Plan Next Approval Date | u_dr_plan_next_approval | false | Date | (empty) | 40 | false | |
| Subcategory | subcategory | false | String | (empty) | 40 | false | |
| Assigned | assigned | false | Date/Time | (empty) | 40 | false | |
| Invoice number | invoice_number | false | String | (empty) | 40 | false | |
| Data Types | u_data_security_classification | false | List | Data Security Classification Type | 1,024 | false | |
| SID | sid | false | String | (empty) | 40 | false | |
| Created | sys_created_on | false | Date/Time | (empty) | 40 | false | |
| Project Number and Name | u_project_number_and_name | false | String | (empty) | 40 | false | |
| Checked out | checked_out | false | Date/Time | (empty) | 40 | false | |
| Running process | running_process | false | Reference | Running Process | 32 | false | |
| Attributes | attributes | false | String | (empty) | 65,000 | false | |
| Domain Path | sys_domain_path | false | (empty) | (empty) | 255 | false | |
| Updated | sys_updated_on | false | Date/Time | (empty) | 40 | false | |
| Business Criticality | u_business_criticality | false | String | (empty) | 40 | false | |
| Model ID | model_id | false | Reference | Product Model | 32 | false | |
| Other Moderate Risk | u_other_moderate_risk | false | String | (empty) | 200 | false | |
| Instance | instance | false | String | (empty) | 40 | false | |
| SDR Information | u_sdr_information | false | String | (empty) | 40 | false | |
| Recovery Point Objective (RPO) | u_recovery_point_objective_rpo | false | String | (empty) | 40 | false | |
| Approval group | change_control | false | Reference | Group | 32 | false | |
| Installation directory | install_directory | false | String | (empty) | 255 | false | |
| Fully qualified domain name | fqdn | false | String | (empty) | 255 | false | |
| Risk Classification | u_risk_level | false | String | (empty) | 40 | false | |
| Future Host Environment | u_future_host_environment | false | String | (empty) | 40 | false | |
| Monitoring | u_monitoring | false | True/False | (empty) | 40 | false | |
| Is clustered | is_clustered | false | True/False | (empty) | 40 | false | |
| Running process command hash | rp_command_hash | false | String | (empty) | 255 | false | |
| Management IP Address | ip_address | false | String | (empty) | 255 | false | |
| Location | location | false | Reference | Location | 32 | false | |
| Software Install | software_install | false | Reference | Software Installation | 32 | false | |
| First discovered | first_discovered | false | Date/Time | (empty) | 40 | false | |
| Warranty expiration | warranty_expiration | false | Date | (empty) | 40 | false | |
| Model number | model_number | false | String | (empty) | 255 | false | |
| Future Host Type | u_future_host_typ | false | Reference | Host Type | 32 | false | |
| Platform | u_platform | false | Reference | Quickbase Platforms | 40 | false | |
| Assignment group | assignment_group | false | Reference | Group | 32 | false | |
| DR Plan Last Tested Date | u_dr_plan_last_test | false | Date | (empty) | 40 | false | |
| Due in | due_in | false | String | (empty) | 40 | false | |
| Comments | comments | false | String | (empty) | 4,000 | false | |
| Cost center | cost_center | false | Reference | Cost Center | 32 | false | |
| Alias | u_alias | false | String | (empty) | 100 | false | |
| Due | due | false | Date/Time | (empty) | 40 | false | |
| Programming Lang | u_programming_lang | false | List | Programming Language | 1,024 | false | |
| Updates | sys_mod_count | false | Integer | (empty) | 40 | false | |
| MAC Address | mac_address | false | String | (empty) | 40 | false | |
| Data Center | u_reference_1 | false | Reference | Data Center | 32 | bac72b5137130200f212cc028e41f1b8 | false |
| Running process key parameters hash | rp_key_parameters_hash | false | String | (empty) | 255 | false | |
| DR Plan Last Approved | u_dr_plan_last_approval | false | Date | (empty) | 40 | false | |
| Discovery source | discovery_source | false | String | (empty) | 40 | false | |
| Department | department | false | Reference | Department | 32 | false | |
| Application ISME | u_application_isme | false | Choice | (empty) | 40 | false | |
| Accessibility | u_accessibility | false | String | (empty) | 40 | false | |
| Schedule | schedule | false | Reference | Schedule | 32 | false | |
| Service Name | u_service_name | false | String | (empty) | 40 | false |
User Interface
Main Form
User Interface Requirement
Currently discovery process is not getting them Security Patch Level. This is really important for them. He just wants to capture the top row (latest security patch) brought back through the command. Please let me know if this is doable. If it is doable we can add the data attribute to the UI. Right now it is maintained manually in spreadsheets (not always up-to-date).
Having it is Important because Oracle team have to follow ISO requirement of keeping Oracle Databases with up to date with all the security vulnerabilities out there and only way to do is - by applying the patches that comes out quarterly.
Relationships
Tracked Configuration Files
...