Report on Licensed users

[madhuabbaraju]

Hello Everyone,

I'm trying to get a report for Licensed Users. By creating a report on sys_user table with below filter condition

sys id is javascript:gs.getRoledUsers();

The result gave me licensed users. But it includes the users who are having only role 'snc_internal'.

I want to exclude those users from the report. Please help on this.

Thanks

Madhuri

[madhuabbaraju]

javascript:gs.getRoledUsers()   returns an array of sys_ids of users that have at least one role.   (correct me if i'm wrong)

All i want to get is return sys_ids of users not having only snc_internal role.

For example:     two users---     user 1-- having itil,asset,snc_internal roles

                                                                                            user 2 -- having snc_internal role

now i want to get sys_id of user1 only. Please help

[madhuabbaraju]

Sorry. The filter condition in report is

sys_id   is   javascript:getRoledUsers()

[alexbones]

What I did is report on the sys_user_has_role table. This will list out all users with roles and then you can easily filter out roles. I have create a speedometer gauge where the aggregation is count distinct users so you know how many roled users you have. Then you can also set your limits in the speedometer settings so you know if you are over on your licenses or not.

[madhuabbaraju]

Thanks Alex for the response. But i need to get report on user table so that i need to schedule and email to group with user details