lcm_operations
Retrieves a history of patching (update and upgrade) activities in chronological order. Please note that your environment's data retention policy dictates how far back Fleet Maintenance can show update and upgrade history.
- Read Patch History:
Where the input file contains the following:emcli lcm_operations -getLcmHistory -input_file="<path of the JSON file>"
{ "targetNames" : [<List of targets>], "targetType" : "oracle_database", "targetIds" : [<List of ID's>], "tasks" : ["update", "upgrade"], "timeStartedGreaterThanOrEqualTo" : "<Start date format YYYY-MM-DD HH:MM:SS>", "timeStartedLessThanOrEqualTo" : "<End date format YYYY-MM-DD HH:MM:SS>", "status" : "completed", "sort" : "targetType", "limit" : 100, "page" : "<Page ID>" }
- Export Patch History:
Where the input file contains:emcli lcm_operations -exportLcmHistory -input_file="<path of the JSON file>"
{ "destinationHostName" : "<host name>", "destinationHostCredential" : "<host_cred>", "csvFileLocation" : "<CSV file path>", "csvFileName" : "<file_name.csv>" "targetNames" : [<list of targets>], "targetType" : "oracle_database", "targetIds" : [<list of ids>], "tasks" : ["update", "upgrade"], "timeStartedGreaterThanOrEqualTo" : "<Start date format YYYY-MM-DD HH:MM:SS", "timeStartedLessThanOrEqualTo" : "<End date format YYYY-MM-DD HH:MM:SS", "status" : "completed", "sort" : "targetType" }
Example 1 Read History:
emcli lcm_operations -getLcmHistory -input_file="data:/u01/payload.json"
Where the input file contains:{
"targetNames" : ["DB1", "DB2"],
"targetType" : "oracle_database",
"targetIds" : ["5F128B326F38C425D076B14A402C7211", "5F128B326F38C425D076B14A402C7212"],
"tasks" : ["update", "upgrade"],
"timeStartedGreaterThanOrEqualTo" : "2019-08-01 16:00:00",
"timeStartedLessThanOrEqualTo" : "2024-03-20 09:34:57",
"status" : "completed",
"sort" : "targetType",
"limit" : 100,
"page" : "b2Zmc2V0OjA"
}
Sample Response:LCM history fetched successfully.
Status: 200 - OK
{
"total": 2,
"count": 2,
"currentPage": "b2Zmc2V0OjA",
"timeStartedGreaterThanOrEqualTo": "2019-08-01 16:00:00",
"timeStartedLessThanOrEqualTo": "2024-03-20 09:34:57",
"items": [
{
"targetName": "DB1",
"targetDisplayName": "DB1",
"targetType": "oracle_database",
"targetId": "CBAE3A0D1AB04E88E04303A017907ABD",
"targetVersion": "11.2.0.4.0",
"task": "UPDATE_DB",
"status": "COMPLETED",
"timeStarted": "2022-11-18 11:31:27",
"timeEnded": "2022-11-18 12:26:27",
"submittedBy": "SYSMAN",
"additionalProperties": {
"patchIds": [
"29517242",
"29517243",
"29517244"
]
}
},
{
"targetName": "DB2",
"targetDisplayName": "DB",
"targetType": "oracle_database",
"targetId": "EEAD3A0D1AB04E88E04303A014567EEDA",
"targetVersion": "11.2.0.4.0",
"task": "UPDATE_DB",
"status": "COMPLETED",
"timeStarted": "2022-11-18 11:31:27",
"timeEnded": "2022-11-18 12:26:27",
"submittedBy": "SYSMAN",
"additionalProperties": {
"patchIds": [
"29517242",
"29517243",
"29517244"
]
}
},
}
Example 2 Export History
emcli lcm_operations -exportLcmHistory -input_file="data:/u01/payload.json"
Where the input file contains: {
"destinationHostName" : "myhost.com",
"destinationHostCredential" : "myhost_cred",
"csvFileLocation" : "/scratch/lcmhistory",
"csvFileName" : "lcmHistory_04122024T10_10_10.csv"
"targetNames" : ["DB1", "DB2"],
"targetType" : "oracle_database",
"targetIds" : ["5F128B326F38C425D076B14A402C7211", "5F128B326F38C425D076B14A402C7212"],
"tasks" : ["update", "upgrade"],
"timeStartedGreaterThanOrEqualTo" : "2019-08-06 09:35:04",
"timeStartedLessThanOrEqualTo" : "2025-08-06 09:35:04",
"status" : "completed",
"sort" : "targetType"
}
Sample Response:LCM history exported successfully.
Status: 200 - OK
{"message": "CSV file exported successfully to /scratch/aupatil/lcmhistory/lcmhistorynolimitemcli_2.csv"}