OpenText product name changes coming to the community soon! Learn more.

Related Tips & Info
Wikis - Page

Knowledge Document: Query to find devices that did not run ZENworks DAU or patch scan to report bundle or patch status

Caroline Oest
 
0 Likes
Products
ZENworks Configuration Management (ZCM),ZENworks Patch Management (ZPM)

Environment 

ZENworks 2020 Update 3 or higher 
ZENworks Patch Management (Advanced) 

Situation 

Query to find the Patch Agent devices that did not run Discover Applicable Updates (DAU) bundle or patch scan to report the bundle or patch status to the Primary Server. 

This SQL query is prepared for 64-bit devices(Windows, Linux or Mac platforms), where the corresponding 64-bit DAU bundle assignment is effective but it did not launch, or patch scan did not complete to report the scan results to the Primary Server. 

Note: For the Linux patch devices(SUSE or RHEL), ensure to check the results for the corresponding platform specific DAU bundle assignment status. For Example: SUSE-x64 DAU bundle's assignment is only applicable/effective to SUSE devices and not RHEL devices.  

Find resolution on support portal

Labels:

Configuration Management
Support Tips/Knowledge Docs
Patch Management
Comment List
Related
Recommended

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.