Throughout the entire interface of Kaseya there are two constants:
1. Machine ID is always referenced as "machineName.subGroup.parentGroup"
2. Group ID is always references as "parentGroup.subGroup"
All of the views I have found for the group ID is always "subGroup.parentGroup". Where can I get the group name formatted with the parent starting on the left?
You will need to create a custom view in SQL for that. Do you have a DBA at your place of business? It actually isn't that hard, so I can probably write up steps for it.
Create a view using the following
----------------------------------------------------------
USE [ksubscribers]
GO
/****** Object: View [dbo].[vCustom_GroupView] Script Date: 03/29/2012 22:02:40 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE VIEW [dbo].[vCustom_GroupView]
AS
SELECT dbo.vMachine.Machine_GroupID, dbo.vMachine.machName, dbo.machGroup.groupName, dbo.machGroup.reverseName
FROM dbo.machGroup INNER JOIN
dbo.vMachine ON dbo.machGroup.reverseName = dbo.vMachine.groupName
----------------------------------------------------
Now if you reference the view within a script you can get
#vCustom_GroupView.groupname# gives you ParentOrg.SubOrg.Group
#vCustom_GroupView.reversename# gives you Group.SubOrg.ParentOrg.
I think this is what you are after ?
Paul