Kaseya Community

Is there a variable to get the group name formatted as parentGroup.subGroup?

This question is not answered

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?

All Replies
  • 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

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    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

    GO

    ----------------------------------------------------

    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