Trying to find an inspector for "Last Modify by" or "Creator"

Content Authoring
1

Hey,

Doing some relevances to identify old baselines but I am struggle to find out an inspector to get the “creator” user or “last modify by” user.
Is there one?

Cannot find neither with bes fixlet or bes baseline … wondering how can I get the user who created/modify the baseline…

Thanks!
Diego

2

nevermind … ended up querying it directly from the BFEnterprise DB.

BigFix v9.4
SELECT A.ID, A.Name, A.CreationTime, B.Username
FROM [BFEnterprise].[dbo].[LOCAL_OBJECT_DEFS] A, [BFEnterprise].[dbo].[USERINFO] B
where A.ID = ‘503117’ and B.MastheadUsername = A.Username
or A.ID = ‘484070’ and B.MastheadUsername = A.Username
or A.ID = ‘513082’ and B.MastheadUsername = A.Username
… where ID = baseline ID

BigFix v9.5
SELECT A.Name, A.LastModificationTime, B.Username
FROM [BFEnterprise].[dbo].[CUSTOM_BASELINES] A, [BFEnterprise].[dbo].[USERINFO] B
where A.ContentID = ‘170467’ and B.UserID = A.LastModifierID
or A.ContentID = ‘178753’ and B.UserID = A.LastModifierID
… where ContentID = baseline ID

3

It looks like only one of them is available in session relevance

https://developer.bigfix.com/relevance/reference/bes-fixlet.html#issuer-of-bes-fixlet-bes-user

4

yep … odd that there isn’t any inspector for the last modify time.