Page Comparison

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

Page Properties

Platform Owner

Deanna Burns (Unlicensed)

Document status

Status

colour	Green
title	Work in Progress

Tech leadSN Discovery SME

Allena Kendrick

Technical writers

Business Analyst

@Vandana Bansal

CI Owner

CMDB Manager

Christopher Abbott (Unlicensed)

PM

David Swanson (Unlicensed)

SN CMDB Lead

Vimalpriya Kothandapani (Unlicensed)

Table of Contents

Report Metrics

Technical Requirements

...

oracle_home\database\spfileSID.ora
oracle_home\database\spfile.ora
oracle_home\database\initSID.ora

...

cmdb_ci_db_ora_instance Data attributes

u_ = added fields

MandatoryTypeReferenceMax lengthDefault valueDisplayHost Environmentu_host_environmenttrueString(empty)40falseLifecycle Classificationu_lifecycle_classificationtrueString(empty)40falseUniversity Sponsor Leaderu_univ_sponsor_leadtrueReference User32falseUniversity Areasu_university_areastrueList University Area1,024falseSys IDsys_idtrueSys ID (GUID)(empty)32falseUsed byu_used_bytrueList Applications Used By1,024falsePackage Typeu_package_typetrueString(empty)40falseNamenametrueString(empty)255trueHost Typeu_host_typetrueReference Host Type32falseOperational statusoperational_statustrueInteger(empty)1001falseDescriptionshort_descriptiontrueString(empty)1,000falseCan Printcan_printfalseTrue/False(empty)40falsefalseSkip syncskip_syncfalseTrue/False(empty)40falsefalseMost recent discoverylast_discoveredfalseDate/Time(empty)40falseLifecycle Dateu_lifecycle_datefalseDate(empty)40falseConfiguration directoryconfig_directoryfalseString(empty)255falseClassifierclassifierfalseReference Process Classification32falseBusiness Value Scoreu_business_value_scorefalseChoice(empty)40falseOperational Controlsu_operational_controlsfalseString(empty)40falseClusteredu_clusteredfalseTrue/False(empty)40falseOther High Risku_other_high_riskfalseString(empty)200falseFault countfault_countfalseInteger(empty)400falseFunctional Contactmanaged_byfalseReference User32falseDecommission Dateu_decommission_datefalseDate(empty)40falseGL accountgl_accountfalseString(empty)40falsePIDpidfalseInteger(empty)40falseLast SDR Approval Dateu_last_sdr_approval_datefalseDate(empty)40falseFuture Platform Componentsu_future_platform_componentsfalseList Platform Component1,024falseCostcostfalseFloating Point Number(empty)40falsePO numberpo_numberfalseString(empty)40falseCost currencycost_ccfalseString(empty)3USDfalseIs a Disaster Recovery Plan Required?u_dr_plan_requiredfalseString(empty)40NofalseOrder receiveddelivery_datefalseDate/Time(empty)40falseDomainsys_domainfalseDomain ID(empty)32globalfalsePrimary Supportu_primary_supportfalseReference User32falseNotesu_notesfalseJournal(empty)4,000falseprogramming ver expu_programming_ver_expfalseString(empty)40falseEnvironmentu_environmentfalseString(empty)40falseCategorycategoryfalseString(empty)40javascript:gs.include("CMDBItem");var it...falseSupport Vendoru_support_vendorfalseReference Company32falsePlatform Componentsu_platform_componentsfalseList Platform Component1,024falseTCP port(s)tcp_portfalseString(empty)255falseManufacturermanufacturerfalseReference Company32falseClasssys_class_namefalseSystem Class Name(empty)80javascript:current.getTableName();falseUsed forused_forfalseString(empty)40ProductionfalseInstalledinstall_datefalseDate/Time(empty)40falsePagerDuty servicex_pd_integration_pagerduty_service

#	Requirement		User Story			Importance	Challenge	Notes
1

Mid ServerUpdate Mid-Server Parameters

set mid.property.ssh.use_snc = true to address the dmidecode issue
Changed glide.required.attribute.enabled to false to ignore the mandatory fields
Restart Mid-Sever

2

Probes

...

Oracle Instance

Horizontal discovery probe: launches patterns
Powershell-Oracle - Instance PFile (for Windows)*
Powershell-Oracle - Instance Version (for Windows)*
SSHCommand-Oracle - Instance Details (for Linux)*

SSHCommand-Oracle - Listener Details

Patterns

...

Application patterns:

Oracle DB On Windows Pattern
Oracle DB on UNIX Pattern

This shared library pattern used by the Linux Server pattern:

UNIX Cluster - ORACLE Clusterware

Note: This shared library pattern is triggered if the crsd.bin process is running on the Oracle database server.

Oracle Discovery Data Collections

Data collected on UNIX machines

...

From the output of the ORA_HOME/bin/sqlplus /NOLOG command
From the output of the ORA_HOME/bin/lsnrctl status command
From the path of ORA_HOME

...

oracle_home/dbs/spfileSID.ora
oracle_home/dbs/spfile.ora
oracle_home/dbs/initSID.ora

...

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. https://yalesandbox.service-now.com/$sn_pattern_designer.do?authoring_mode=modify&sys_id=28d607dbfead4be3887c843814455105&sysparm_view=&sysparm_record_target=&sysparm_record_row=1&sysparm_record_list=nameCONTAINSoracle%5EORDERBYname&sysparm_record_rows=14 Image Added
2	important		Image Added glide.required.attribute.enabled Set to false
3			Proposed View modification that we would like to see which includes the latest security patches applied to that Instance as well – that is one of the most important piece of information we would like to see on this form/view. Image Added
4			Oracle = Listener Details Image Added ORA_HOME=$1 LISTENER=$2 TNS_ADMIN="/ora_admin/tns_admin" FAILED=0 ERR="" get_config() { CONFIG_PATH="${TNS_ADMIN}/listener.ora" FAILED=`sudo cat $CONFIG_PATH 1> /dev/null 2>&1; echo $?` [ "$FAILED" != 0 ] && ERR="Could not read listener.ora: $CONFIG_PATH. $ERR" && return echo "snc_listener.ora_contents=" sudo cat $CONFIG_PATH } get_instances() { ORACLE_HOME=$ORA_HOME export ORACLE_HOME INSTANCES=`${ORA_HOME}/bin/lsnrctl status $LISTENER 2>&1 \| sed -ne 's/Instance "\(.\)", status READY./\1/p' \| tr -d ' ' \| uniq \| tr '\n' ' '` [ "$INSTANCES" != "" ] && echo "snc_ora_instances=$INSTANCES" && return FAILED=1 ERR="Unable to accurately determine listener<->instance relationships. $ERR" } get_version() { VERSION=`${ORA_HOME}/bin/lsnrctl status 2>&1 \| grep Version \| sed -ne 's/.: Version \([0-9.]\) ./\1/p'` [ "$VERSION" != "" ] && echo "snc_ora_version=$VERSION" && return VERSION=`echo $ORA_HOME \| sed -ne 's/.\/\([0-9.]\)\/./\1/p'` [ "$VERSION" != "" ] && echo "snc_ora_version=$VERSION" && return FAILED=1 ERR="Could not determine Oracle listener version. $ERR" } get_version get_instances get_config [ "$FAILED" != 0 ] && echo "snc_error=$ERR" exit 0
5
6			set glide.required.attribute.enabled to false
7		SID	The solution for this issue is to make sure the identification section "Identification for Oracle DB entry point type(s) - no instance" . executes before "dentification for Oracle DB entry point type(s) - no instance on Solaris" - So i have changed the order on the pattern for the correct identification section to be executed first. - To confirm the issue has been resolved, i ran a discovery on vm-ktkdevdb-01 (172.18.24.33) . See DIS0010142 Now the SID is updated on the oracle instances https://yalesandbox.service-now.com/cmdb_ci_db_ora_instance.do?sys_id=8973fd411bf1005493463153cd4bcb26&sysparm_view= https://yalesandbox.service-now.com/cmdb_ci_db_ora_instance.do?sys_id=bad41982db7d48107150132968961938&sysparm_view=
8		security Patch Level

Probes

Image Added

Oracle Probes
Oracle Instance Horizontal discovery probe: launches patterns Powershell-Oracle - Instance PFile (for Windows)* Powershell-Oracle - Instance Version (for Windows)* SSHCommand-Oracle - Instance Details (for Linux)*

Patterns

Image Added

Oracle Patterns
Application patterns: Oracle DB On Windows Pattern Oracle DB on UNIX Pattern This shared library pattern used by the Linux Server pattern: UNIX Cluster - ORACLE Clusterware Note: This shared library pattern is triggered if the `crsd.bin` process is running on the Oracle database server.

Oracle Discovery Data Collections

Data collected on UNIX machines

Label	Field name	Additional information
SID	sid	Obtained from the name of the process that starts with `ora_pmon_`
Install directory	install_directory	Obtained from the path of ORA_HOME
Version	version	Obtained in this order: From the output of the `ORA_HOME/bin/sqlplus /NOLOG` command From the output of the `ORA_HOME/bin/lsnrctl` status command From the path of ORA_HOME
Parameter file	pfile	The following locations are explored for the location of the System Parameter File. If this file does not exist in one of the explored locations, Discovery does not find the file and reports an error. oracle_home/dbs/spfileSID.ora oracle_home/dbs/spfile.ora oracle_home/dbs/initSID.ora
Oracle Home	oracle_home	Obtained from the ORATAB file.
Edition	edition

Data collected on Windows machines

Label	Field name	Additional information
SID	sid	Obtained from the process parameter that is passed to the oracle.exe process.
Install directory	install_directory
Version	version	Obtained from the output of the ORA_HOME/bin/sqlplus.exe -V command.
Parameter file	pfile	The following locations are explored for the location of the System Parameter File. If this file does not exist in one of the explored locations, Discovery does not find the file and reports an error. oracle_home\database\spfileSID.ora oracle_home\database\spfile.ora oracle_home\database\initSID.ora
Oracle Home	oracle_home	Parsed from the path of oracle.exe
Edition	edition

cmdb_ci_db_ora_instance Data attributes

u_ = added fields

x_pd_integration_pagerduty_webhookString32u_other_contractual_informationAssetchecked_inu_last_tac_approvalDateregulated_info255running_process_key_parameters65,000leaseidStringu_third_party_supportCompanyu_pfilespfileStringriskassessment_idasset_tagu_production_dateDate(empty)40licensecount commandcommandmonitor4040sys_class_pathcorrelation_idString512version255License Typeulicense_typeString(empty)40lastsdrnumberIntegerjustification80oraclehomeString255u_functional_owning_org40editionString100uhosting40u_dr_plan_next_testDate(empty)40u_dr_plan_next_approvalDate40subcategoryassigned40invoice_numberdatasecurityclassification1,024sidsyscreatedon/Timeproject_number_and_namechecked_out/Timesys_updated_onString200instanceStringusdr_information40Recovery Point Objective RPO

MandatorySort in ascending order	TypeSort in ascending order	ReferenceSort in ascending order	Max lengthSort in ascending order	Default valueSort in ascending order	DisplaySort in ascending order
Host Environment	u_host_environment	true	String	(empty)	40		false
Lifecycle Classification	u_lifecycle_classification	true	String	(empty)	40		false
University Sponsor Leader	u_univ_sponsor_lead	true	Reference	User	32		false
University Areas	u_university_areas	true	List	University Area	1,024		false
Sys ID	sys_id	true	Sys ID (GUID)	(empty)	32		false
Used by	u_used_by	true	List	Applications Used By	1,024		false
Package Type	u_package_type	true	String	(empty)	40		false
Name	name	true	String	(empty)	255		true
Host Type	u_host_type	true	Reference	Host Type	32		false
Operational status	operational_status	true	Integer	(empty)	100	1	false
Description	short_description	true	String	(empty)	1,000		false
Can Print	can_print	false	True/False	(empty)	40	false	false
Skip sync	skip_sync	false	True/False	(empty)	40	false	false
Most recent discovery	last_discovered	false	Date/Time	(empty)	40		false
Lifecycle Date	u_lifecycle_date	false	Date	(empty)	40		false
Configuration directory	config_directory	false	String	(empty)	255		false
Classifier	classifier	false	Reference	Process Classification	32		false
Business Value Score	u_business_value_score	false	Choice	(empty)	40		false
Operational Controls	u_operational_controls	false	String	(empty)	40		false
Clustered	u_clustered	false	True/False	(empty)	40		false
Other High Risk	u_other_high_risk	false	String	(empty)	200		false
Fault count	fault_count	false	Integer	(empty)	40	0	false
Functional Contact	managed_by	false	Reference	User	32		false
Decommission Date	u_decommission_date	false	Date	(empty)	40		false
GL account	gl_account	false	String	(empty)	40		false
Accessibility Support Group	u_accessibility_support_groupPID	pid	falseReference	Group	32	b0dea7a56f1771007ee2abcf9f3ee477	false
Credentialless Discovery Port	cl_port	false
Integer	(empty)	40		false	PagerDuty webhook
Last SDR Approval Date	u_last_sdr_approval_date	false
Date	(empty)	40		false	Updated by	sys_updated_by	false	String	(empty)	40	false
Recovery Tier Justification	u_recovery_tier_justificationFuture Platform Components	u_future_platform_components	false	List Recovery Tier Justification	Platform Component	1,024		false
SOX Cost	u_soxcost	falseTrue/False	Floating Point Number	(empty)	40		false
Requires verification	unverifiedPO number	po_number	false	True/False String	(empty)	40		false
Recovery Tier Cost currency	ucost_recovery_tiercc	false	String	(empty)	403	USD	false
Quickbase Application ID Is a Disaster Recovery Plan Required?	u_quickbasedr_plan_idrequired	false	String	(empty)	40	No	false
Configuration file Order received	configdelivery_filedate	falseString	Date/Time	(empty)	25540		false
Status Domain	installsys_statusdomain	falseInteger	Domain ID	(empty)	4032	global	false
Supported by	supported_byPrimary Support	u_primary_support	false	Reference	User	32		false
Start date Notes	startu_datenotes	false	Date/Time Journal	(empty)	404,000		false
Data Sensitivity programming ver exp	u_programming_dataver_classificationexp	false	String	(empty)	40		false
Created by Environment	sysu_created_byenvironment	false	String	(empty)	40		false
Maintenance schedule	maintenance_scheduleCategory	category	false	String Reference	(empty)	Schedule	3240	javascript:gs.include("CMDBItem");var it...	false
Application Scope Support Vendor	u_applicationsupport_scopevendor	false	String Reference	(empty)Company	4032		false
Owned by	owned_byPlatform Components	u_platform_components	false	Reference List	User	Platform Component	1,024		false
Running process parameters	running_process_parametersTCP port(s)	tcp_port	false	String	(empty)	65,000255		false
Secondary Support	u_secondary_supportManufacturer	manufacturer	false	Reference	User Company	32		false
Accessibility Contact Class	usys_accessibilityclass_contactname	false	Reference	User	32	false
Regulated Information
System Class Name	(empty)	80	javascript:current.getTableName();	false
Used for	used_for	false	String	(empty)	1040	false
Production
asset
false
Reference	Asset	32	false	Checked in

Installed	install_date	false	Date/Time	(empty)	40		false	Last TAC Approval Date
PagerDuty service	x_pd_integration_pagerduty_service	false
String	(empty)	40		falseExternal Obligations
Accessibility Support Group	u_
false	List	Regulated Information	4,000	false
Support group	accessibility_support_group	false	Reference	Group	32	b0dea7a56f1771007ee2abcf9f3ee477	false
DR Plan ID #	u_dr_plan_idCredentialless Discovery Port	cl_port	false	String Integer	(empty)	40		false
DNS Domain	dns_domainPagerDuty webhook	x_pd_integration_pagerduty_webhook	false	String	(empty)	25540		false
Purchased	purchase_dateUpdated by	sys_updated_by	false	Date String	(empty)	40		false
Listener name	listener_nameRecovery Tier Justification	u_recovery_tier_justification	false	String	(empty)	List	Recovery Tier Justification	1,024		false
Ordered SOX	orderu_datesox	false	DateTrue/TimeFalse	(empty)	40		false
Serial number	serial_numberRequires verification	unverified	falseString	True/False	(empty)	25540		false
Display name Recovery Tier	u_displayrecovery_nametier	false	String	(empty)	25540		false
Vendor	vendorQuickbase Application ID	u_quickbase_id	false	Reference String Company	(empty)	3240		false
Company	company	false	Reference	Company	32	false	Running process key parameters

Configuration file	config_file	false	String	(empty)
255		falseLease contract
Status
install_
status	false
Integer	(empty)	40		false	Third Party Support
Supported by	supported_by	false	Reference
User	32		false	Pfile/ Spfile
Start date	start_date	false
Date/Time	(empty)	40		falseLatest Risk Assessment
Data Sensitivity	u_
data_
classification	false	String	(empty)	40		false	Asset tag
Created by	sys_created_by	false	String	(empty)	40		false	Production Start Date
Maintenance schedule	maintenance_schedule	false
Reference
Schedule
32		falseLicense Count
Application Scope	u_
application_
scope	false	String	(empty)	40		false	Target Decommissioning Date	u_target_decommissioning_date	false	Date	(empty)	40
Owned by	owned_by	false	Reference	User	32		false
Running process
parameters	running_process_
parameters	false	String	(empty)	65,000		false	Monitor
Secondary Support	u_secondary_support	false
True/False	(empty)
Reference	User	32		false
false

Pfile	pfile	false	String	(empty)	8,000	false
Recovery Time Objective (RTO)	u_recovery_time_objective_rtoAccessibility Contact	u_accessibility_contact	false	Reference	User	32		false
Regulated Information	u_other_contractual_information	false	String	(empty)
10		false	sys_class_path
Asset	asset	false
System Class path	(empty)	255	javascript:GlideDBObjectManager.get().ge...	false
Technology Fit Score	u_technology_fit_score	false	Choice Reference	Asset	32		false
Checked in	checked_in	false	Date/Time	(empty)	40		false	Correlation ID
Last TAC Approval Date	u_last_tac_approval	false
Date	(empty)
40		false	Version
External Obligations	u_regulated_info	false
String	(empty)
List	Regulated Information	4,000		false

Support group
support_
group	false
Reference
Group
32		falseSDR
DR Plan ID #	u_
dr_
plan_
id	false
String	(empty)	40		false	Justification
DNS Domain	dns_domain	false	String	(empty)
255		falseOracle Home
Purchased
purchase_
date	false
Date	(empty)
40		false	Functional Owning Organization
Listener name	listener_name	false	String	(empty)
255		falseEdition
Ordered
order_date	false
Date/Time	(empty)
40		falseHosting
Serial number
serial_
number	false	String	(empty)
255		false	Assigned to	assigned_to	false	Reference	User	32	false
Target Cloud Deployment	u_target_cloud_deploymentDisplay name	u_display_name	false	String	(empty)	40255		false
DR Plan Next Testing Date

Vendor	vendor	false	Reference	Company	32		false
Company	company	false
Reference
Company
32		false	DR Plan Next Approval Date
Running process key parameters	running_process_key_parameters	false
String	(empty)
65,000		false	Subcategory
Lease contract	lease_id	false	String	(empty)	40		false	Assigned
Third Party Support	u_third_party_support	false
Date/Time	(empty)
Reference	Company	32		false	Invoice number
Pfile/ Spfile	u_pfilespfile	false	String	(empty)	40		falseData Types
Latest Risk Assessment	u_
risk_
assessment_
id	false
List	Data Security Classification Type
String	(empty)	40		false	SID
Asset tag	asset_tag	false	String	(empty)	40		falseCreated
Production Start Date
u_
production_
date	false	Date
	(empty)	40		falseProject Number and Name
License Count	u_
license_count	false	String	(empty)	40		false	Checked out
Target Decommissioning Date	u_target_decommissioning_date	false	Date
	(empty)	40		false
Running process command	running_process_command	false
Reference	Running Process	32	false
Attributes	attributes	false	String	(empty)	65,000		false
Domain Path	sys_domain_pathMonitor	monitor	false(empty)	True/False	(empty)	25540	false
Updated
false
Pfile	pfile	false	Date/Time String	(empty)	408,000		false
Business Criticality Recovery Time Objective (RTO)	u_recovery_businesstime_objective_criticalityrto	false	String	(empty)	40		false
Model ID	model_id	false	Reference	Product Model	32	false

Other Moderate Risk	u_other_moderate_risk	false
sys_class_path	sys_class_path	false	System Class path	(empty)
255	javascript:GlideDBObjectManager.get().ge...	false	Instance
Technology Fit Score	u_technology_fit_score	false
Choice	(empty)	40		falseSDR Information
Correlation ID
correlation_
id	false	String	(empty)
512		false
Version	version	false	String
(
empty)	255		false

u_

recovery_point_objective_rpo

license_type

false

(empty)

40

false

Approval groupchange_control

u_last_sdr_number

false

(empty)

32install_directory

40

false

Installation directory

justification

false

(empty)

255fqdn

80

false

Fully qualified domain name

oracle_home

false

(empty)

255

false

Risk Classification

Functional Owning Organization

u_

risk

functional_owning_

levelu_future_host_environment

org

false

(empty)

40

false

Future Host Environment

edition

false

(empty)

40

100

false

u_

monitoring

hosting

false

(empty)

40

false

is

assigned_

clustered40

to

false

True/False(empty)rp_command_hash

32

false

Running process command hash

Target Cloud Deployment

u_target_cloud_deployment

false

(empty)

255ip_address

40

false

Management IP Address

DR Plan Next Testing Date

u_dr_plan_next_test

false

(empty)

255

40

false

LocationlocationfalseReference Location32falseSoftware Installsoftware_installfalseReference Software Installation32falseFirst discoveredfirst_discoveredfalseDate/Timewarranty_expiration

DR Plan Next Approval Date	u_dr_plan_next_approval	false	Date	(empty)	40		false
Subcategory	subcategory	false	String	(empty)	40		false

Warranty expiration

assigned

false

(empty)

40

false

Model

model

invoice_number

false

(empty)

255

40

false

Future Host Type

u_

future

data_

host

security_

typ

classification

false

Host

Data Security Classification Type

32

1,024

false

u_platformQuickbase Platforms

sid

false

Referenceassignment_group

(empty)

40

false

Assignment group32

sys_created_on

false

Reference Group

(empty)

40

false

DR Plan Last Tested Date

Project Number and Name

u_

dr

project_

plan

number_

last

and_

test

name

false

(empty)

40

false

due

checked_

in

out

false

Stringcomments

(empty)

40

false

Running process

running_process

false

String(empty)cost_center

Running Process

32

false

attributes

false

Reference Cost Centeru_alias

(empty)

65,000

false

sys_domain_path

false

(empty)

(empty)

100due

255

false

sys_updated_on

false

(empty)

40

false

Programming Lang

Business Criticality

u_

programming

business_

langUpdatessys_mod_countfalseInteger

criticality

false

List Programming Language1,024false

String	(empty)	40		false
Model ID	model_id	false	Reference	Product Model	32		false
Other Moderate Risk	u_other_moderate_risk	false	String	(empty)

40mac_address

200

false

instance

false

(empty)

40

false

SDR Information

u_

reference

sdr_

1Running process key parameters hashrp_key_parameters_hash

information

false

Reference Data Center32bac72b5137130200f212cc028e41f1b8false

String	(empty)	40		false
Recovery Point Objective (RPO)	u_recovery_point_objective_rpo	false	String	(empty)

255u_dr_plan_last_approval

40

false

DR Plan Last Approved

change_control

false

(empty)

40

32

false

Discovery source

Installation directory

discovery

install_

source

directory

false

(empty)

40

255

false

Departmentdepartment

Fully qualified domain name

fqdn

false

(empty)

32

255

false

Application ISME

Risk Classification

u_

application

risk_

isme

level

false

(empty)

40

false

Future Host Environment

u_

accessibility

future_host_environment

false

(empty)

40

false

Scheduleschedule


Monitoring	u_monitoring	false	True/False	(empty)	40		false
Is clustered	is_clustered	false

Reference Schedule32

(empty)

40

false

Service Nameu_service_namefalseString(empty)40false

User Interface

...

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

Image Added

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

Image Added

Tracked Configuration Files

Image Added

Dependency View

Image Added

Relationships

Validation Steps

Step	Description	Verdict

Open Questions

Question	Answer	Date Answered

Out of Scope