Devarajan
Level 3

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

Jump to solution

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.

1 Solution
jjensen
Flexera Alumni

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/ComplianceSche...

HTH,

Joseph

If my response answered your question satisfactorily, please click "ACCEPT AS SOLUTION" to heighten visibility for future customers!

View solution in original post

4 Replies
adrian_ritz1
Level 9

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
Flexera Alumni

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/ComplianceSche...

HTH,

Joseph

If my response answered your question satisfactorily, please click "ACCEPT AS SOLUTION" to heighten visibility for future customers!

View solution in original post

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.

If my response answered your question satisfactorily, please click "ACCEPT AS SOLUTION" to heighten visibility for future customers!

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

it was helpful.

0 Kudos