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.
Aug 07, 2020 05:50 AM
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.
HTH,
Joseph
Aug 07, 2020 06:12 AM
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.
Aug 07, 2020 06:10 AM
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.
HTH,
Joseph
Aug 07, 2020 06:12 AM
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.
Aug 07, 2020 06:24 AM
Thanks @jjensen for the query to identify how the reconciliation is triggered.
it was helpful.
Aug 17, 2020 12:53 AM