I am trying to run a report out of kaseya of our clients and how many of their servers have a certain level of monitoring. I would like the report to contain which client the agent is installed at so I have used the "Group ID" value as that is nice and easy to bring up in an agragate table. when using this value it displays the group id as subgroup.group.org so all if i arrange by Group ID all groups with the same name are put together but i cannot arrange by organization.
Does anyone know if there is something that contains the same data but in reverse order.
just the organization value as this is the part I need.