Hi Team, I am trying to a analytics query using which I will add entitlements to the users account. What I want to achieve here is I have a CP57 property and using which we are assigning the users the entitlement , Ex - CP57 (city name) - C...
Hi All,An extract of username, displayname, companyname, orgunitid and email which matches the criteria (can't mention) - i can do this Please also add a column and indicate if they already have the group (entitlement) assigned - need help in this a...
Hi All,I want a SQL query that will give me the list of user along with the entitlements they have assigned to them.Please let me know if we can do it.Thanks,
Hi all ,I have written a query which will display number of user with less than 5 account this query works will on the data analyzer and also provides the proper number of count but when I try to use same query in my Dashboard query is not working an...
I have created a Elasticsearch Analytics based Tile but when I click on reload button it doesn't reload the data, For reflecting the data we need to run the analytics again then it will reflect the data on the tile . But I want to reflect the data wh...
SELECT U.USERNAME,U.DISPLAYNAME,U.COMPANYNAME,U.ORGUNITID,U.EMAIL,CASEWHEN EV.ENTITLEMENT_VALUE LIKE 'CN=sec_demo%'THEN 'YES' ELSE 'NO'END AS 'GROUP PRESENT'FROM ACCOUNTS AJOIN USER_ACCOUNTS UA ON A.ACCOUNTKEY = UA.ACCOUNTKEYJOIN USERS U ON UA.USERKE...
Chart Properties :[{"tileType":1,"data":100,"displayName":"Users with less than 5 Accounts","clickable":"yes","chartType":"icon-user small","objectName":"User Accounts","className":"dashboard-stat red","category":"","clickType":"analytics"}]Dashboard...
I got the solution i used [{"tileType":,"data":,"displayName":"","clickable":"","chartType":"","objectName":"","className":"","category":"","clickType":"","color":"green"}]Instead of this use the below code it will work[{"tileType":,"data":,"displayN...
