Security orphan account reconciliation calculator

Calculate accounts with no supplied owner and accounts referring to unknown owners with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Use accounts with no supplied owner and accounts referring to unknown owners to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Accounts: account ID, owner ID or none, owner kind human/service
A,alice,human B,none,human C,bob,human D,svc,service E,ghost,service
Human owners: ID, active/inactive; or none
alice,active bob,inactive
Service owners: ID, active/inactive; or none
svc,active
Accounts with no supplied owner
B
Accounts referring to unknown owners
E
Accounts whose known owner is inactive
C
Accounts with known active owners
2
Known-active-owner account coverage (%)
40

Try another scenario

Accounts: account ID, owner ID or none, owner kind human/service
A,alice,human B,none,human C,bob,human D,svc,service E,ghost,service
Human owners: ID, active/inactive; or none
alice,active bob,active
Service owners: ID, active/inactive; or none
svc,active
Accounts with no supplied owner
B
Accounts referring to unknown owners
E
Accounts whose known owner is inactive
None
Accounts with known active owners
3
Known-active-owner account coverage (%)
60
Calculation method

Calculation method

Accounts with no supplied owner

Owner field equals none.

Accounts referring to unknown owners

Owner ID absent from the declared human or service inventory for its supplied kind.

Accounts whose known owner is inactive

Known owner status inactive.

Accounts with known active owners

Known owner status active.

Known-active-owner account coverage (%)

Known active owner accounts/all supplied accounts×100; each account counts once.

Symbols and units
a
Accounts: account ID, owner ID or none, owner kind human/service
b
Human owners: ID, active/inactive; or none
c
Service owners: ID, active/inactive; or none

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • A literal supplied ownership-inventory reconciliation, not proof an account is unnecessary or compromised. It does not inspect credentials, disable accounts or remove permissions.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

NIST SP 800-53: background for inventory, access, audit and contingency controls; worksheet algorithms and rules are explicitly supplied, not NIST compliance tests ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.