Database Diagnostics SP_HELP (21633)

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Database Tables Tools >

Database Diagnostics SP_HELP (21633)

Report Name: Database Diagnostics SP_HELP (21633)

 

Report Type: Standard

 

Description: The Database Diagnostics Report provides information on the owner, type and CREATED_DATETIME of a selected object or the name, owner, and type of all objects in the database if you do not select a specific object.

 

File Name: EarthSoft.Reports.Library.21633.dll

 

Contact support@earthsoft.com for a direct file link.

 

Language: English

 

Input Parameters: A selection made to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Object Name

30026-input.param.scrnsht

 

Output Columns:

 

AT_COMPANY_PERSON, AT_EQUIPMENT_PARAMETER, AT_FACILITY, AT_GEO_UNIT, AT_SAMPLE_CHAIN_OF_CUSTODY, AT_SUBFACILITY_LOCATION, AT_TEST_BATCH_ASSIGN, CM_TSCOONC, CM_TSSOILDEPTH, CM_TSWATERLEVEL, DT_ACTION_LEVEL, DT_ACTION_LEVEL_PARAMETER, DT_AQUIFIER_TEST, DT_ATTERBERG, DT_BASIC_RESULT, DT_BIOLOGICAL_RESULT, DT_CHAIN_OF_CUSTODY, DT_COLLECT_PROC, DT_COORDINATE, DT_DISCHARGE_MONITOR, DT_DISCHARGE_REPORT, DT_DISCHARGE_REPORT_PARAMETER, DT_DOWNHOLE_POINT_DATA, DT_DRILL_ACTIVITY, DT_DRILL_PARAMETER, DT_EQUIPMENT, DT_EQUIPMENT_NOTE, DT_EQUIPMENT_PARAMETER, DT_EXCAVATION, DT_FACILITY_PARAMETER, DT_FIELD_SAMPLE, DT_FIELDQC_BATCH_PARTNER, DT_FILE, DT_FILE_PARAMETER, DT_FINDING, DT_HYDRO_PAR, DT_LITHOLOGY, DT_LOCATION, DT_LOCATION_PARAMETER, DT_MEASURE_DATUM, DT_PERMIT, DT_PERSON, DT_PHASE, DT_PLANNED_TEST, DT_PRECIPITATION, DT_PRODUCTION_THICKNESS, DT_PUMP_RATE, DT_PURGE, DT_RESULT, DT_RESULT_QC, DT_SAMPLE, DT_SAMPLE_PARAMETER, DT_TEST, DT_TEST_BATCH, DT_WATER_LEVEL, DT_WATER_TABLE, DT_WELL, DT_WELL_DEVELOPMENT, DT_WELL_SEGMENT, RT_ACTION_LEVEL_TYPE, RT_ANALYTE, RT_ANALYTE_DETAIL, RT_ANALYTE_VAR, RT_ANALYTIC_METHOD, RT_BASIN, RT_COMPANY, RT_COMPANY_TYPE, RT_COORD_ELEV_DATUM, RT_COORD_ELEV_METHOD, RT_COORD_GEOMETRIC_TYPE, RT_COORD_HORZ_DATUM, RT_COORD_HORZ_METHOD, RT_COORD_TYPE, RT_COORD_VERIFICATION, RT_DOWNHOLE_POINT_PARAM_TYPE, RT_EQUIPMENT_PARAM_TYPE, RT_EQUIPMENT_TYPE, RT_FACILITY_PARAM_TYPE, RT_FILE_TYPE, RT_FINDING_TYPE, RT_FRACTION, RT_FREQUENCY, RT_GEO_UNIT_TYPE, RT_GEOLOGIC_UNIT, RT_GROUP, RT_GROUP_MEMBER, RT_HOLDING_TIME, RT_LOCATION_PARAM_TYPE, RT_LOCATION_TYPE, RT_LOOKUP, RT_MATERIAL, RT_MATRIX, RT_MATRIX_CLASS, RT_MEDIUM, RT_MTH_ANL_GROUP, RT_MTH_ANL_GROUP_MEMBER, RT_PREP_METHOD, RT_PERSERVATIVE, RT_QUALIFIER, RT_REMAP, RT_REMAP_DETAIL, RT_RESULT_TYPE, RT_SAMPLE_METHOD, RT_SAMPLE_PARAM_TYPE, RT_sOIL_GAS_PARAM_TYPE, RT_STATE, RT_STREAM, RT_SUBFACILITY_TYPE, RT_SYMBOL, RT_TASK_PARAM_TYPE, RT_TASK_TYPE, RT_UNIT, RT_UNIT_CONVERSION_FACTOR, RT_VALID_CODE, RT_WELL_SEGMENT_TYPE, ST_ARCGIS, ST_CLIENT, ST_CONFIG, ST_EDD_BATH, ST_FILE_REGISTRATION, ST_GROUP_TYPE, ST_JOB, ST_LICENSE, ST_LICENSE_USE, ST_NEXT_ID, ST_NOTICE, ST_NOTICE_ATTACHMENT, ST_TEMPLATE, ST_REPORT, ST_REPORT_EVENT, ST_REPORT_EVENT_JOB, ST_REPORT_PARAMETER, ST_REPORT_TASK, ST_REPORT_TYPE, ST_REPORT_USE, ST_ROLE, ST_SERVICE_REGISTRATION, ST_SPLA, ST_TASK, ST_USER, ST_USER_FACILITY, ST_USER_NOTICE, ST_USER_REPORT, ST_USER_REPORT_PARAMETER, ST_USER_ROLE, ST_VERSION, VW_COORD_NON_NUMERIC, VW_DOWNHOLE_DATE, VW_LITHOLOGY, VW_LOCATION, VW_RESULT_NON_NUMERIC, VW_TABLE_ROW_COUNT, VW_WELL

Note: * refers to hidden parameters.

 

Tables: SYS.ALL_OBJECTS, MASTER.DBO.SPT_VALUES, SYS.TYPES, SYS.ALL_COLUMNS, SYS.COLUMNS, SYS.ALL_PARAMETERS, SYSDEPENDS, SYS.IDENTITY_COLUMNS

 

Database Type: SQL

 

Database Schema: Standard (no custom or add-on schemas required)

 

Database Version: EQuIS 5.4.3+

 

Data Requirements: N/A

 

Report Requirements: Excel

 

Output Type: Excel

 

Example Output: Download this attachment or this example sp_help_Springfield.xls (output without selections).

 

Reports.Library._21633.sp_help