How do I match "__op_54" to an actual Console Operator?

Content Authoring
1

Looking through a BES Client log, and my Windows workstation registry, there are references to “_op**”. Is there an easy way to relate these OP Numbers to an actual Console Operator?

1 Like
2

The easiest way that I have tracked this down is by going under All Content and in the navigation tree click on Sites > Operator Sites and make sure you have the URL column available, this should show all your operators and a unique opsite### in the URL.

There may be easier ways but the only other way I have done it is through SQL.

3

And without knowing your issue I have seen errors in the client logs associated to the opsites when an operator has an account and have never taken.

4

This Session Relevance should work.
Add the whose clause as needed.

(name of it, masthead operator name of it) of bes users
3 Likes
5

I believe this operator ID also appears when commenting on a fixlet or baseline in the console. It’s rather annoying to be honest.

1 Like
6

Thanks @leewei
That give me what I needed!

1 Like
7

See here: http://bigfix.me/relevance/details/2998895

(name of it | "", masthead operator name of it | "", (following text of last "/" of url of operator site of it) | "") of bes users

For me, it has been a real problem at times that I cannot get this information client side.

8

I have the same problem querying “Client Administrators” property on BES_COLUMN_HEADINGS. I am seeing lot of “_op” instead of actual names. Need suggestions or SQL code to retrieve actual names. Looks like some sort of JOIN with other database tables. I could not get this info from the database API documentation.

9

Select * from USERINFO

SELECT username, UserID, MastheadUsername, LdapDN FROM USERINFO where MastheadUsername like ‘%op_123%’