Kaseya Community

GroupID Table?

  • Which table contains a list of groupIDs? Trying to create a dropdown in SQL Reporting that contains a list of groups...


    Bob Penland

    Legacy Forum Name: GroupID Table?,
    Legacy Posted By Username: bpenland
  • Hi,

    None of the views currently has just a list of group ID's. If you use the vMachine table this contains a list of all machines at their group ID's. There is a MachineGroupID (without the underscore) fieldthat contains the full group name. Perhapsselect this as a seperate step, remove the machine name (stored as MachineName)and thenremove all the duplicates? A bit of work, but it will get you there.

    Hope this helps.

    Legacy Forum Name: Server,
    Legacy Posted By Username: raybarber