DX Unified Infrastructure Management

  • Private Community

  • 1.  SQL Query

    Posted Nov 22, 2018 06:24 AM

    Hello All,

     

    I need SQL query to pull the list of SQL instances and servers monitored in Nimsoft.

     

    Thanks in Advance!



  • 2.  Re: SQL Query
    Best Answer

    Broadcom Employee
    Posted Nov 22, 2018 06:02 PM

    Hi 

    Please check if usage_metering probe meets your requirement 

    Usage_metering 9.21 is latest GA version

     

    usage_metering FAQs (check procedure to run the report)

    https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/usage_metering-usage-metering/usage_metering-im-configuration#usage_meteringIMConfiguration-usage_meteringFAQs

     

    The report is saved in the (CA UIM installation directory)\probes\service\usage_metering\reports directory on the primary hub.


    usage_metering (Usage Metering) Release Notes

     

    https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/usage_metering-usage-metering/usage_metering-usage-metering-release-notes#usage_metering(UsageMetering)ReleaseNotes-ProbeSpecificSoftwareRequirements



  • 3.  RE: Re: SQL Query

    Posted May 18, 2020 10:32 AM
    Is the output of the usage_metering stored in the DB or is this just on the primary hub?  One of the things lacking very heavily is the ability to do any type of reporting on inventory, license usage or robot configurations.
    Original Message


  • 4.  RE: Re: SQL Query

    Broadcom Employee
    Posted May 18, 2020 10:47 AM
    no, it stores it in a local h2 database
    Robot configuration can be done with the nsa probe per the below KB article:
    https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=34707

    ------------------------------
    Gene Howard
    Principal Support Engineer
    Broadcom
    ------------------------------

    Original Message