Export Lifecycle Maintenance History
post
https://EM_HOST:EM_CONSOLE_HTTPS_PORT/em/api/lcmOperations/actions/exportLcmHistory
Exports the database maintenance history for update (patching) and upgrade operations in CSV format.
Request
There are no request parameters for this operation.
Supported Media Types
- application/json
Root Schema : schema
Type:
object
Request to export LCM history data
Show Source
-
csvFileLocation: string
File location where the CSV to be exportedExample:
/scratch/lcmhistory
-
csvFileName: string
CSV file nameExample:
lcmHistory_04122024T10_10_10.csv
-
destinationHostCredential: string
Destination host target credentialExample:
HOST_CRED:ADMIN
-
destinationHostName: string
Destination host target nameExample:
myhost
Match All
Show Source
-
object
allOf
LcmHistoryDetails
Request to retrieve LCM history data
Nested Schema : LcmHistoryDetails
Type:
object
Request to retrieve LCM history data
Show Source
-
exclusions: array
exclusions
Exclude the given details in response
Match All
Show Source
-
object
LcmHistoryFilter
Filter for LCM history data
Nested Schema : LcmHistoryFilter
Type:
object
Filter for LCM history data
Show Source
-
status: string
Allowed Values:
[ "SCHEDULED", "RUNNING", "ACTION_REQUIRED", "PAUSED", "FAILED", "COMPLETED", "ABORTED", "SKIPPED", "SAVED", "COMPLETED_WITH_ERROR" ]
status of taskExample:COMPLETED
-
submittedBy: string
OEM user that submitted the operationExample:
SYSMAN
-
targetIds: array
targetIds
List of target IDs
-
targetNames: array
targetNames
List of target names
-
targetType: string
Allowed Values:
[ "oracle_database", "oracle_pdb", "cluster", "rac_database", "has" ]
Target type -
tasks: string
Allowed Values:
[ "UPDATE", "UPGRADE" ]
List of tasks -
timeStartedGreaterThanOrEqualTo: string
Since the given timeExample:
2023-01-30 10:00:00
-
timeStartedLesserThanOrEqualTo: string
Until the given timeExample:
2023-01-30 10:00:11
Nested Schema : targetIds
Type:
array
List of target IDs
Show Source
Example:
[
"E5B98897FE871AC1E05380FE4564F682",
"ADB98897FE871AC1E05380FE4564F555"
]
Nested Schema : targetNames
Type:
array
List of target names
Show Source
Example:
[
"Prod DB",
"HR DB"
]
Examples
Back to Top
Response
Supported Media Types
- application/json
200 Response
Ok. LCM History exported successfully.
Root Schema : schema
Type:
object
Match All
Show Source
-
object
ExportLcmHistoryReport
Export LCM history response
Nested Schema : ExportLcmHistoryReport
Type:
object
Export LCM history response
Show Source
-
message: string
Success messageExample:
CSV file exported successfully to /scratch/lcmhistory/exportlcmhistory.csv
-
nextPage: string
Base 64 encoded next pageExample:
b2Zmc2V0OjC
Examples
401 Response
Unauthorized. The user does not have permissions to perform the requested operation
Root Schema : ErrorResponse
Type:
object
Error response
Show Source
-
code(required): string
A short error code that defines the error, meant for programmatic parsing
-
message(required): string
A human-readable error string
403 Response
Forbidden. The user is forbidden to perform the requested operation
Root Schema : ErrorResponse
Type:
object
Error response
Show Source
-
code(required): string
A short error code that defines the error, meant for programmatic parsing
-
message(required): string
A human-readable error string
500 Response
Internal Server Error. Exception in execution of REST API.
Root Schema : ErrorResponse
Type:
object
Error response
Show Source
-
code(required): string
A short error code that defines the error, meant for programmatic parsing
-
message(required): string
A human-readable error string
503 Response
Service Unavailable. The server is unable to process the request.
Root Schema : ErrorResponse
Type:
object
Error response
Show Source
-
code(required): string
A short error code that defines the error, meant for programmatic parsing
-
message(required): string
A human-readable error string