Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it! Learn more

  • State Verified Answer
  • Replies replies
    2
  • Subscribers subscribers
    5
  • Views views
    335
  • Users 0 members are here
  • +1 person also asked this people also asked this
  • Locked Locked
Related
Options
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

ZRS/ZCM/postgres programatically pulling information?

Cory Sherman

Is there a way to programmatically pull asset information?  I think the best thing i've found is: GitHub - thewabbit0/ZenworksSOAP: Zenworks SOAP proxy classes for use with Powershell.

My other thoughts attempting to find a way through the posgres data base.

Tags:

Parents

  • Verified Answer

    +1  

    If you build a custom report in ZRS, you can export the SQL used for the report.

    Then use SQL to export the data you need for whatever purpose.  You can also just schedule the reports to run which may do what you need.

    It is also possible to export the SQL from ZCC Inventory reports as well, but I would need to look up that process again if you wanted to do that as it's not a GUI method like ZRS 

    --

    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button

    Be sure to "Like" My (and a few others) Cool Solutions below! 

    https://community.microfocus.com/members/craigdwilson/bookmarks

  • 0 in reply to   

    That sounds great, if it's easy enough for you to look up that would be awesome, otherwise i'll likely dig in a few weeks.  But I greatly appreciate you showing the path!

Reply Children
No Data

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.