Kaseya Community

License by group

This question is not answered

Hi

Does anyone got a clue how to get a report on how many agents used by a Organization/Machine group.

Or if a can use a sql query?

All Replies
  • Hi,

    You need to go to system tab and then select the license manager and then select the license group there you can find the license count.

    Thanks,

    Pawan

  • I use SQL to get that information...

    SELECT   kasadmin.vbo_OrgMachine_List.orgName,

    sum(CASE  WHEN vMachine.Osinfo LIKE '%Mac%' THEN 1 ELSE 0 END) AS Mac,

    sum(CASE  WHEN vMachine.OsType LIKE '%linux%' THEN 1 ELSE 0 END) AS linux,

    sum(CASE  WHEN vMachine.Osinfo LIKE '%Server%' THEN 1 ELSE 0 END) AS Server,

    sum(CASE  WHEN vMachine.Osinfo Not LIKE '%Server%' and vMachine.Osinfo Not LIKE '%Mac%' and vMachine.Osinfo Not LIKE '%linux%' THEN 1 ELSE 0 END) AS Workstation

    FROM     kasadmin.vbo_OrgMachine_List INNER JOIN

            dbo.vMachine ON kasadmin.vbo_OrgMachine_List.agentGuid = dbo.vMachine.agentGuid

    group by kasadmin.vbo_OrgMachine_List.orgName

    order by orgName