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?
--Mark
‎Aug 22, 2023 03:22 PM
Hi Mark,
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
Best regards,
Markward
‎Aug 23, 2023 02:37 AM