Hi all ...
Is it possible to automatically disable an operator's access if the operator hasn't logged into FNMS for some pre-determined amount of time, say 30 days for the sake of this discussion?
I see that the ComplianceOperator table has the field "isEnabled" which could be set to 0 to disable the operator (and is likely the field changed when you enable / disable users through the UI). The issue then becomes how do you determine when the last login for that operator was. Does Flexera store login info anywhere?
Aug 22, 2023 03:22 PM
ComplianceOperatorAudit has some login data:
UPDATE co SET co.IsEnabled = 0 FROM ComplianceOperator co JOIN ComplianceOperatorAudit coa ON co.ComplianceOperatorID = coa.ComplianceOperatorID WHERE DATEDIFF(DAY, coa.LastActive, GETDATE()) > 30
Aug 23, 2023 02:37 AM