Group all devices View does not show all devices

1 answer

1.  

   1

   0

   -1

   • Mark Unwin
   • Sep 07, 2020

   Please send the output of the below command to marku@opmantek.com

   http://YOUR_SERVER/open-audit/index.php/groups/1?action=execute&debug=true&format=json

   •  Comment

   1. tac tac

      • Sep 07, 2020

      Hello
      Mail sent to marku@opmantek.com
      Please review attachment
      thank

   2. Mark Unwin

      • Sep 07, 2020

      Do you have more than 1,000 devices? The configuration is set to retrieve the first 1,000. If you need more, see "page_size" in the configuration.

      Are the devices that are not appearing in the report assigned to an Org ID not in this list - 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25. The query will retrieve those devices based on your users Org access. See Users, Roles and Orgs - how does it work?

      The SQL that is run by group #1 is as below. The OrgID list and limit are the only two things that can affect the result, so it should be one of those.

      SELECT system.id AS `system.id`, system.icon AS `system.icon`, system.type AS `system.type`, system.name AS `system.name`, system.ip AS `system.ip`, system.dns_fqdn AS `system.dns_fqdn`, system.identification AS `system.identification`, system.description AS `system.description`, system.manufacturer AS `system.manufacturer`, system.os_family AS `system.os_family`, system.status AS `system.status` FROM system WHERE system.org_id IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,1) LIMIT 0,1000

   CommentAdd your comment...