CA Client Automation

  • Private Community

  • 1.  How can make SQL query to obtain a specific KB installed?

    Posted Apr 19, 2018 04:51 PM

    I need obtain all computer with specific KB: how to make this SQL query? Any know the table with this data?

    Regards



  • 2.  Re: How can make SQL query to obtain a specific KB installed?

    Broadcom Employee
    Posted Apr 19, 2018 05:00 PM

    Why not use the dsm reporter?

     

    Richard Lechner

    Principal Engineering Services Architect

     

    CA Technologies

    Mobile: +1 703 655 7161 | Richard.Lechner@ca.com

     

    <mailto:Richard.Lechner@ca.com>[CA]<http://www.ca.com/us/default.aspx>[Twitter]<http://twitter.com/CAInc>[Slideshare]<http://www.slideshare.net/cainc>[Facebook]<https://www.facebook.com/CATechnologies>[YouTube]<http://www.youtube.com/user/catechnologies>[LinkedIn]<http://www.linkedin.com/company/1372?goback=.cps_1244823420724_1>[Google]<https://plus.google.com/CATechnologies>[Google+]<http://www.ca.com/us/rss.aspx?intcmp=footernav>



  • 3.  Re: How can make SQL query to obtain a specific KB installed?
    Best Answer

    Posted Apr 19, 2018 05:11 PM

    You can do that with the query designer, no need to go into SQL. See the screenshot below:

     

     

     

    Steve McCormick, ITIL

    CA Technologies

    Principal Services Consultant

    Stephen.McCormick@ca.com

    <mailto:Stephen.McCormick@ca.com>