Retrieve Patches with Advanced Filtering

Open in ChatGPT Open in ChatGPT to ask questions about this page
Open in Claude Open in Claude to ask questions about this page
Copy as MarkdownCopy this page as markdown to use with AI assistants
View as Markdown Open this page as markdown in a new tab

Retrieves patches with support for advanced filtering such as approvalStatus, severity and platform etc.

Request URL

https://{serverurl}/dcapi/patch/reports/allPatches Copied!

Scope

DesktopCentralCloud.PatchMgmt.CREATECopied!

Header

Authorization: Zoho-oauthtoken d92d4xxxxxxxxxxxxx15f52

Request Parameters

- Request Headers

AcceptstringMandatory
application/patchReports.v1+jsonapplication/patchReports.v1+jsonCopied!

- Query Parameters

pageLimitintegerOptional

Number of records to be returned per page. Minimum 1, maximum 1000. Default is 25.

pageintegerOptional

Page number of the result set to be returned. Minimum 1, maximum 100000. Default is 1.

searchColumnstringOptional

Name of the column in which the search value needs to be looked up. Use together with searchValue.

searchValuestringOptional

Text to look up in the column given in searchColumn. Use together with searchColumn.

branchOfficestringOptional

Returns only the systems that belong to the given remote office (branch office). Provide the remote office name as configured in Endpoint Central. Multiple values can be given as a comma-separated list. Get the remote office names from Get Remote Offices api

platformstringOptional

Returns only the systems or patches belonging to the given operating system platform. Accepted values: 1 - Windows, 2 - Mac, 3 - Linux. Provide a single numeric value.

selectedPatchIdstringOptional

Unique identifier of the patch whose details need to be retrieved. Get the value from Get Supported Patches

statusstringOptional

Returns only the patches with the given status on the systems. Accepted values: 201 - Installed, 202 - Missing.

domainstringOptional

Returns only the systems that belong to the given domain or workgroup. Provide the domain name as shown in Endpoint Central, for example, the NetBIOS name of the domain. Multiple values can be given as a comma-separated list. Get the domain names from Get Domains api

severitystringOptional

Returns only the patches of the given severity. Accepted values: 0 - Unrated, 1 - Low, 2 - Moderate, 3 - Important, 4 - Critical. Provide a single numeric value.

customGroupstringOptional

Returns only the systems that are members of the given custom group. Provide the custom group name as configured in Endpoint Central. Multiple values can be given as a comma-separated list. Get the custom group names from Get Custom Groups api

patchStatusstringOptional

Returns only the patches with the given status on the systems. Accepted values: 201 - Installed, 202 - Missing. Multiple values can be given as a comma-separated list.

approvalStatusstringOptional

Returns only the patches with the given approval status. Accepted values: 211 - Approved, 0 - Not Approved, 212 - Declined.

kbnumberstringOptional

Returns only the patches whose KB (knowledge base) article number contains the given value. For example, 5031356. Partial values are matched.

bulletinIdstringOptional

Returns only the patches released under the given bulletin. A bulletin is the vendor advisory a patch is published under, for example MS15-041. Enter the Bulletin ID exactly as shown in the patch list. Get the bulletin ID from Get Supported Patches.

isWebViewstringOptional

Indicates whether the response is requested for the web console. Set to True to get the response in the format used by the web console; leave empty for the default API response.

skipColumnsstringOptional

Comma-separated list of column names that should be left out of the response, to get a lighter response with only the columns you need.

dcViewFilterIDstringOptional

Unique identifier of a saved view filter. When given, the saved filter criteria are applied to the report.

- Request Body

application/json
JSON Object
Hide Sub-Attributes
criteriaJSONJSON ArrayOptional

Array of filter criteria for advanced report filtering

Show Sub-Attributes
JSON Object
Show Sub-Attributes
columnIDlongMandatory
searchValueJSON ArrayOptional
Show Sub-Attributes
string
comparatorstringMandatory
customComparatorstringOptional
logicalOperatorstringMandatory
displayValuestringOptional
dcViewFilterIDstringOptional

Saved view filter ID to apply

dcViewFilterNamestringOptional

Name of the saved view filter

Sample Request

Curl
Java
Python
Deluge
PowerShell
Copied!
curl --request POST \
  --url https://appdomains/dcapi/patch/reports/allPatches \
  --header 'Accept: application/patchReports.v1+json' \
  --header 'Authorization: Zoho-oauthtoken  d92d4xxxxxxxxxxxxx15f52' \
  --header 'content-type: application/json' \
  --data '{}'

Sample Request Body

Copied!
  {
    "criteriaJSON": [
      {
        "columnID": 0,
        "searchValue": [
          "string"
        ],
        "comparator": "string",
        "customComparator": "string",
        "logicalOperator": "string",
        "displayValue": "string"
      }
    ],
    "dcViewFilterID": "string",
    "dcViewFilterName": "string"
  }
                
▼ Show full

Response Parameters

- HTTP code 200

Response Body - application/json
JSON Object
Hide Sub-Attributes
messageResponseJSON Array

Array of patch-system mapping entries

Show Sub-Attributes
JSON Object
Show Sub-Attributes
affected_patch_statusstring

Affected patch status code

agent_last_bootup_timestring

Agent last bootup time in epoch milliseconds

agent_last_contact_timestring

Agent last contact time in epoch milliseconds

agent_last_contact_time_transformstring

Formatted agent last contact time

agent_logged_on_usersstring

Logged on users on the agent

agent_logged_on_users_transformstring

Transformed logged on users

agent_versionstring

Agent version string

agent_version_transformstring

Transformed agent version

branch_office_namestring

Branch office name

branch_office_name_transformstring

Transformed branch office name

bulletin_idstring

Security bulletin identifier

bulletin_id_transformstring

Transformed bulletin ID

collection_namestring

Collection name, or null

collection_name_transformstring

Transformed collection name

computer_live_statusstring

Computer live status code

computer_status_update_timestring

Computer status update time in epoch milliseconds

config_idstring

Configuration ID, or null

config_id_transformstring

Transformed configuration ID

deploy_remarksstring

Deployment remarks, or null

deploy_remarks_argsstring

Deployment remarks arguments, or null

deploy_remarks_transformstring

Transformed deployment remarks

deployer_first_namestring

Deployer first name, or null

deployer_first_name_transformstring

Transformed deployer name

deployment_statusstring

Deployment status, or null

domain_netbios_namestring

Domain NetBIOS name

domain_netbios_name_transformstring

Transformed domain name

first_namestring

Name of the user who approved the patch

first_name_transformstring

Transformed approving user name

friendly_namestring

Friendly computer name

friendly_name_transformstring

Transformed friendly name

i18nstring

Internationalization language

i18n_transformstring

Transformed i18n value

image_namestring

Image path for approval status

install_error_codestring

Installation error code, or null

installed_timestring

Installation time in epoch milliseconds, or null

installed_time_transformstring

Formatted installation time

ip_addressstring

IP address of the system

ip_address_transformstring

Transformed IP address

labelstring

Approval status label key

label_transformstring

Transformed approval status display

mac_addressstring

MAC address of the system

mac_address_transformstring

Transformed MAC address

managedcomputer_resource_idstring

Managed computer resource ID

os_languagestring

OS language code

os_namestring

Operating system name

os_name_transformstring

Transformed OS name

os_platformstring

OS platform code

patch_affected_status_imagestring

Image path for patch affected status

patch_affected_status_labelstring

Patch affected status label key

patch_affected_status_label_transformstring

Transformed patch affected status

patch_descriptionstring

Full description of the patch

patch_description_transformstring

Transformed patch description

patch_idstring

Unique patch identifier

patch_id_transformstring

Transformed patch ID

patch_install_status_imagestring

Image path for install status, or null

patch_install_status_labelstring

Install status label, or null

patch_install_status_label_transformstring

Transformed install status label

patch_namestring

Patch file name

patch_name_transformstring

Transformed patch file name

patch_released_timestring

Patch release time in epoch milliseconds

patch_released_time_transformstring

Formatted patch release date

patch_sizestring

Patch file size in bytes

patch_size_transformstring

Formatted patch file size

patch_statusstring

Patch status code

patch_supported_timestring

Patch supported time in epoch milliseconds

patch_supported_time_transformstring

Formatted patch supported date

patch_typestring

Patch type code

patch_uninstall_statusstring

Uninstall support status code

patch_uninstall_status_transformstring

Transformed uninstall status display

patch_updated_timestring

Last updated time in epoch milliseconds

patch_updated_time_transformstring

Formatted last updated date and time

platformstring

Platform code: 1=Windows, 2=Mac, 3=Linux

platform_namestring

Platform display name

platform_name_transformstring

Transformed platform name

pmseverity_namestring

Severity display name

resource_idstring

Resource identifier

resource_namestring

Resource/computer name

resource_name_transformstring

Transformed resource name

resourcemacip_resource_idstring

Resource MAC/IP resource ID

service_packstring

Service pack version

service_pack_transformstring

Transformed service pack

severitystring

Severity code

severity_namestring

Severity label key

severity_transformstring

Transformed severity display

sqnumberstring

Software version/sequence number

sqnumber_transformstring

Transformed version number

superceded_bystring

Superceded by patch ID, or NA

superceded_by_transformstring

Transformed superceded by value

update_namestring

Update type name

update_name_transformstring

Transformed update type name

user_idstring

User ID of approver

vendor_namestring

Vendor name

vendor_name_transformstring

Transformed vendor name

metadataJSON Object

Pagination metadata

Show Sub-Attributes
limitstring

Number of records per page

pagestring

Current page number

statusstring

Operation result: success

totalPagesstring

Total number of pages available

totalRecordsstring

Total number of records matching the query

- HTTP code 401

Response Body - application/json
JSON Object
Hide Sub-Attributes
errorCodelong

Unauthorized error code returned when authentication credentials are missing, expired, or invalid (authentication=required)

errorMsgstring

Authentication failure reason

- HTTP code 403

Response Body - application/json
JSON Object
Hide Sub-Attributes
errorCodelong

Forbidden error code returned when the authenticated user does not have the required uem-roles (e.g., DataEncryption_Admin or DataEncryptionRecoveryKey_Admin)

errorMsgstring

Message indicating insufficient privileges to access this resource

- HTTP code 429

Response Body - application/json
JSON Object
Hide Sub-Attributes
errorCodelong

Rate limit error code returned when the API call threshold (configured via threshold/duration in security XML) is exceeded; client is locked out for lock-period minutes

errorMsgstring

Rate limit exceeded message with retry guidance

- HTTP code 500

Response Body - application/json
JSON Object
Hide Sub-Attributes
error_codestring

Error code: INTERNAL_ERROR for server-side failures

error_descriptionstring

Localized error description: dc.rest.api_internal_error

Sample Response: HTTP 200

All patches with advanced filters

Copied!
  {
    "metadata": {
      "limit": 25,
      "page": 1
    },
    "totalRecords": "1",
    "messageResponse": [
      {
        "resource_name_transform": "DESKTOP-U9VV1HA",
        "agent_version_transform": "11.5.2616.01.W",
        "deployer_first_name": null,
        "sqnumber": "14.50.35719.0",
        "os_language": "1",
        "install_error_code": null,
        "platform_name_transform": "Windows",
        "patch_install_status_label_transform": "--",
        "bulletin_id": "MSWU-3550",
        "update_name": "Non Security Updates",
        "patch_size": "6876208",
        "image_name": null,
        "patch_description_transform": "Windows Malicious Software Removal Tool x64 - Dec 2025 (KB890830)",
        "patch_uninstall_status": "0",
        "service_pack": "Windows 10 Version 22H2 (x64)",
        "os_name_transform": "Windows 11 Professional Edition (x64)",
        "resourcemacip_resource_id": "307",
        "patch_size_transform": "80.41 MB",
        "domain_netbios_name_transform": "WORKGROUP",
        "patch_uninstall_status_transform": "Not Supported",
        "patch_status": null,
        "patch_install_status_image": null,
        "patch_id": "112861",
        "patch_name": "VC_redist.x86__14.50.35719.0.exe",
        "update_name_transform": "Security Updates",
        "patch_description": "Microsoft Visual C++ 2015-2022 Redistributable (x86) (14.50.35719.0)",
        "branch_office_name_transform": "Local Office",
        "i18n_transform": "",
        "os_platform": "1",
        "agent_last_contact_time_transform": "May 20, 2026 02:49 PM",
        "agent_logged_on_users": "Administrator",
        "patch_name_transform": "Windows-kb890830-x64-v5.138.exe",
        "sqnumber_transform": "890830",
        "vendor_name": "Microsoft Corporation",
        "superceded_by": "NA",
        "i18n": "dc.patch.patchinfo.English",
        "user_id": null,
        "config_id": null,
        "patch_released_time_transform": "Dec 9, 2025",
        "deploy_remarks_args": null,
        "friendly_name_transform": "DESKTOP-U9VV1HA",
        "superceded_by_transform": "NA",
        "installed_time": null,
        "collection_name": null,
        "patch_affected_status_label_transform": "Installed",
        "computer_status_update_time": "1779101474204",
        "patch_affected_status_image": "images/stop.png",
        "deploy_remarks_transform": "--",
        "collection_name_transform": "--",
        "branch_office_name": "Local Office",
        "patch_updated_time": null,
        "installed_time_transform": "--",
        "agent_last_contact_time": "1779268806000",
        "bulletin_id_transform": "MSRT-001",
        "domain_netbios_name": "WORKGROUP",
        "patch_supported_time_transform": "Dec 9, 2025",
        "deploy_remarks": null,
        "platform": "1",
        "patch_released_time": "1764067447000",
        "patch_id_transform": "43089",
        "ip_address_transform": "192.0.2.22",
        "mac_address": "00:0c:29:d4:19:9d",
        "severity_transform": "Moderate",
        "platform_name": "Windows",
        "patch_type": "1",
        "first_name": null,
        "severity": "0",
        "affected_patch_status": "202",
        "friendly_name": "DESKTOP-N7T1LKT",
        "pmseverity_name": "Unrated",
        "managedcomputer_resource_id": "307",
        "deployer_first_name_transform": "--",
        "deployment_status": null,
        "config_id_transform": "--",
        "agent_logged_on_users_transform": "Windows",
        "severity_name": "dc.rep.patchreport.unrated",
        "label": null,
        "ip_address": "192.0.2.23",
        "vendor_name_transform": "Microsoft",
        "service_pack_transform": "Windows 11 Version 25H2 (x64)",
        "patch_supported_time": "1764067447000",
        "agent_version": "11.5.2616.01.W",
        "patch_install_status_label": null,
        "patch_affected_status_label": "dc.common.MISSING",
        "mac_address_transform": "00:15:5d:46:ec:00",
        "agent_last_bootup_time": "1778757478000",
        "resource_id": "307",
        "os_name": "Windows 10 Professional Edition (x64)",
        "computer_live_status": "1",
        "resource_name": "DESKTOP-N7T1LKT"
      }
    ],
    "totalPages": 2,
    "Links": {
      "next": "/dcapi/patch/reports/allPatches?page=2&pageLimit=25",
      "prev": null
    },
    "status": "success"
  }
                
▼ Show full

Sample Response: HTTP 401

Authentication credentials are missing, expired or invalid

Copied!
  {
    "error_code": "UAC_UNAUTHORIZED",
    "error_description": "dc.rest.authentication.unauthorized"
  }
                
▼ Show full

Sample Response: HTTP 403

Authenticated user lacks the required role or scope

Copied!
  {
    "errorCode": "FORBIDDEN",
    "errorMessage": "You do not have sufficient privileges to perform this operation"
  }
                
▼ Show full

Sample Response: HTTP 429

API call threshold exceeded

Copied!
  {
    "errorCode": "RATE_LIMIT_EXCEEDED",
    "errorMessage": "API call limit exceeded. Retry after the lock period elapses"
  }
                
▼ Show full

Sample Response: HTTP 500

Server-side error

Copied!
  {
    "error_code": "INTERNAL_ERROR",
    "error_description": "dc.rest.api_internal_error"
  }
                
▼ Show full

Duration: 1 minute | Threshold: 50 | Lock period: 5 minutes

Duration - Time window for the threshold.
Threshold - Number of API calls allowed within the specified duration.
Lock Period - Wait time before consecutive API requests.