How To: Determine if a User is in the Knowledge Managers, Analysts, or Asset Managers Groups

Determining the Analysts, KB Managers, or Asset Managers Group

To determine which group is configured to be the Analysts, KB Managers, or Asset Managers group:

• Run the following queries in the ServiceManagement database:

SELECT Domain,UserName FROM CI$DomainGroup WHERE Analyst = 1

SELECT Domain,UserName FROM CI$DomainGroup WHERE KnowledgeManager = 1

SELECT Domain,UserName FROM CI$DomainGroup WHERE AssetManager = 1

Determining What Groups a User is a Member Of

Cache builder inspects the membership of the specified Analysts, KB managers, and Asset managers groups once every 2 hours by default and updates the ServiceManagement database.  You can see which permissions a given user has by running this query in the ServiceManagement database:

SELECT Analyst,AssetManager,KnowledgeManager FROM  CI$User WHERE UserName = '<USERNAME>'

Note: replace "<USERNAME>" with the username of the user that you want to check on.

Checking the Membership of an Active Directory Group Using PowerShell

To check the membership of an Active Directory group:

Get-ADGroupMember Analysts | FT Name

Note: Change the name of the group from 'Analysts' to whatever group name you want to look at the membership of.

If you want to check to see if there is a particular user in the group you can run the following command:

 Get-ADGroupMember Analysts | ?{$_.Name -eq ''}

Note: Change the to the username that you are looking for.