Clarity

 View Only
  • 1.  Clarity Licenses

    Posted Jul 23, 2021 04:21 PM
    Hi All,

    I was wondering which table I should query to obtain the license counts(Full and Restricted) in Clarity. I know I can obtain it through the front end, but I was looking to have it queried.  I tried the view cmn_lic_users_v but it seems to contain all users, regardless of them being active or not.

    ------------------------------
    Regards,
    Rohit Upadhya
    ------------------------------


  • 2.  RE: Clarity Licenses

    Posted Jul 24, 2021 08:06 AM
    select * from CMN_LIC_COUNT_V where language_code = 'en'

    This view only considers active users.


  • 3.  RE: Clarity Licenses

    Broadcom Employee
    Posted Jul 26, 2021 09:31 AM
    Hi Rohit

    Out of box we provide 3 query based portlet and queries are NSQL queries and if you look at those queries it will give you a start to build based on your requirement. 




    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------