Why do I see more agents when I run a Query then I do when I create a Dynamic Group based on that Query ?
search cancel

Why do I see more agents when I run a Query then I do when I create a Dynamic Group based on that Query ?

book

Article ID: 44485

calendar_today

Updated On:

Products

CA Client Automation - IT Client Manager CA Client Automation

Issue/Introduction

    In CA Client Automation you can create Queries and then create Groups and base them off those Queries.

 

     The numbers of agents should be the same, but since they are based off of different SQL tables,

     there are times when the numbers are off. 

 

Environment

     CA Client Automation - All Versions

Resolution

  Queries are base off the ca_discovered_hardware table in SQL and Groups are based off the ca_agent table.

    When you delete an agent, it is supposed to also delete the ca_discovered_hardware record

   There are certain situation where these values can be off causing the number of records to be different.

 

   To check the values in SQL run the following SQL Queries:

      select count(*) from ca_discovered_hardware

      select count(*) from ca_agent where agent_type =1           ---agent type 1 are machines.

 

    To resolve this you can run the following SQL command (always backup the MDB before runing any SQL Queries):

        select count(*) from ca_discovered_hardware where dis_hw_uuid not in

         (select object_uuid from ca_agent where agent_type =1)

    This value should be the difference between the above queries (discovered_hardware and  ca_agent) 

        delete from ca_discovered_hardware where dis_hw_uuid not in

         (select object_uuid from ca_agent where agent_type =1)

 

   If you get an error  when running the above query you should open a support case.

   In that case you might need to delete records from the :   ca_link_dis_hw_user table .

 

Additional Information

   This issue is often seen when you you enable User Profiles in the Configuration Policies:

   ...\DSM\Agent\Common Agent\Software Delivery:  Registration:Supported unit Type:   Computers + User Profiles

   Since if this is enable the ca_hardware record gets linked to the User Profile and can't be deleted until the User profile is deleted.