Is there any way to identify who has triggered the FNMS Reconciliation task

[Devarajan]

Hi 

Is there any way to identify which user has triggered the FNMS reconciliation task manually.

the WebUl logs point out to the service account however it is not a scheduled execution.

[adrian_ritz1]

Hi @Devarajan ,

Did you take into consideration that some used the service account to log into app server or to log into the WebUI with service account and then to trigger the reconcile.

Usually only the admin accounts have this rights to do.

[jjensen · Accepted solution]

Hello @Devarajan,

You could run this against the Compliance DB:

SELECT OperatorLogin,* FROM BatchProcessExecution
WHERE BatchProcessTypeID IN (1, 23) -- 1 = license reconcile, 23 = inventory import
ORDER BY BatchProcessExecutionID DESC

If OperatorLogin IS NOT NULL, then it was triggered manually by an operator. Otherwise, it was a system request.

https://docs.flexera.com/FlexNetManagerSuite2020R1/EN/Schema/index.html#SysRef/schema/ComplianceSchema/BatchProcessing.CommonTables/reference/BatchProcessExecution.html

HTH,

Joseph

[jjensen]

Additional note: if the scenario described by @adrian_ritz1  has occurred, then I believe that the OperatorLogin should show your service account instead of NULL.

[Devarajan]

Thanks @jjensen  for the query to identify how the reconciliation is triggered.

it was helpful.