Conditons filter

[QuintenO]

Hello All,
i want to make a overview voor over lincense.

But i am stuck at the last conditon,
Can someone tell me where i can find this last condtion

Table: 

  [sys_user_has_role] 

  Conditions: 

  User.Active is True 

  and 

  User ID is not empty 

  and 

  Last login time in the past 365 days 

  and 

  Web Service Access only = false

  and

  Assigned Fulfiller role(s) mapped to this Product's entitled Applications

[AndersBGS]

Hi @QuintenO ,

From the sys_user_has_role table, you should dot-walk to user where you can make the condition. Please see the query below. According to you last requirement "  Assigned Fulfiller role(s) mapped to this Product's entitled Applications", Where do you have this requirement from? It doesn't really make any sense. 

user.active=true^user.user_nameISNOTEMPTY^user.last_loginRELATIVEGT@dayofweek@ago@365^user.web_service_access_only=false

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[PlatformPadawan]

@QuintenO, were you able to replicate the last condition? I'm running into the same issue 

[QuintenO]

No, I wasn’t able to reproduce this step. However, I did manage to find the licenses in another way, namely through the Subscription Management Overview in the ServiceNow environment