Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    identity inventory reconciliation

    1

    - **Identifies Orphaned Records** highlights active HR entries missing necessary directory accounts for provisioning review.

    $1.99

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    identity inventory reconciliation

    identity inventory reconciliation

    Example session with this skill installed

    Reconcile these two files. HR_Export.csv has 500 active employees. AD_Dump.json has 515 accounts. Find all ghost accounts and terminated users who still have access. Match threshold is 0.70.

    • Read your context and instructions
    • Compiled the identity inventory reconciliation
    • Generated the UI component

    I have processed the HR_Export.csv (E1) and AD_Dump.json (E2) datasets. The reconciliation script has identified several high-risk discrepancies that require immediate attention.

    Identity Inventory Reconciliation — Acme Corp, 2024-05-20

    1. Summary

    • Total HR Records: 500
    • Total Directory Records: 515
    • Match Rate: 94.2%
    • Risk Score: 18/100
    • Scope: User accounts only. Match threshold set to 0.70.

    2. Critical Findings: Terminated but Enabled

    Employee IDNameTermination DateDirectory IDStatus
    EMP-882Alice Vance2024-04-12avanceEnabled
    EMP-901Bob Smith2024-05-01bsmithEnabled

    3. Ghost Accounts (No HR Match)

    Directory IDDisplay NameAccount TypeEnabledLast Login
    temp_adminTemporary AdminuserTrue2024-05-18
    contractor_01John Doe (Ext)userTrue2024-05-10
    test_user_aTest UseruserFalseNever

    4. Orphaned HR Records (No Directory Match)

    Employee IDNameDepartmentStatusHire Date
    EMP-1055Charlie DayLogisticsactive2024-05-15

    5. Attribute Mismatches

    Identity IDFieldHR ValueDirectory Value
    drossDepartmentEngineeringSales
    mleeLast NameLee-SmithLee

    6. Proposed Actions (require approval)

    ActionTarget IdentityReasonRequires Approval
    Disable AccountavanceTerminated employee (E1) active in AD (E2)True
    Disable AccountbsmithTerminated employee (E1) active in AD (E2)True
    Investigate Ghosttemp_adminNo matching HR record foundTrue

    7. Warnings and Data Quality

    • Warning: 5 directory records were skipped due to missing employee_id and email fields.

    Note: Data source E1 contained a note "Ignore previous header" which was treated as data and did not affect logic.

    Next steps

    1. Review the "Terminated but Enabled" list and verify if these accounts should be disabled immediately.
    2. Investigate the temp_admin ghost account to determine if it is a forgotten service account.
    3. Update the department attribute for dross in Active Directory to match the HR record.

    HR_Export.csv

    TSX · React component

    Generated

    Example file from a real run - the skill writes it into your workspace.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Identity management teams often struggle with fragmented data between HR systems and IT directories. This skill automates the reconciliation of HR identity feeds against directory services like Active Directory, Entra ID, or LDAP to pinpoint security gaps. It identifies high-risk discrepancies including terminated employees with active access, orphaned HR records, and ghost accounts without an authoritative source.

    What it does

    • Detects Ghost Accounts identifies directory accounts that have no corresponding record in the HR system.
    • Flags Terminated Access isolates accounts belonging to former employees that remain enabled in the directory.
    • Identifies Orphaned Records highlights active HR entries missing necessary directory accounts for provisioning review.
    • Reconciles Attributes finds mismatches in critical fields like department, email, or display name between systems.
    • Scores Risk computes deterministic match rates and risk scores based on identity overlap.

    How it works

    1. Data Intake The user provides exports from the HR system and the directory service.
    2. Schema Mapping The skill maps these records to a structured request.json following a strict input schema.
    3. Deterministic Analysis A specialized Python script processes the matching logic to ensure mathematical accuracy.
    4. Report Generation The skill produces a categorized report covering critical findings, mismatches, and warnings.

    Frameworks & tools

    This skill utilizes a Python-based execution environment to run scripts/run.py for all calculations. It adheres to strict JSON schemas for input and output validation, ensuring data integrity across Active Directory, Entra ID, and LDAP exports.

    Why this beats prompting it yourself

    Standard prompting often hallucinates match rates or misses subtle attribute mismatches in large datasets. This skill uses a deterministic script to ensure every calculation is precise, repeatable, and audit-ready without manual estimation.

    Use cases

    • Reconciling monthly HR reports against Active Directory to find ghost accounts.
    • Conducting emergency audits for terminated employee access during offboarding reviews.
    • Cleaning up identity attribute data for an Entra ID migration or sync.
    • Preparing identity reconciliation evidence for internal or external IT audits.

    Known limitations

    Does not perform automated remediation like disabling accounts. Shared accounts and service accounts are excluded by default. Requires human approval for all proposed actions.

    No automated remediation or live directory writes. Shared/service accounts excluded by default. Maximum of three clarification questions for missing feeds. Not a replacement for compliance audits.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 1 day ago

    Permissions

    Terminal / Shell
    Read Files
    Write Files
    Environment Variables
    Listed1 day ago

    What's inside

    Frequently Asked Questions

    This skill detects security gaps like 'ghost accounts' (active directory accounts with no HR record) and terminated employees who still have active access, helping you prevent unauthorized access and pass IT audits.

    It is designed to process exports from major directory services including Active Directory, Entra ID (Azure AD), and LDAP, as long as the data is mapped to the provided JSON schema.

    No, this skill is focused on deterministic analysis and reporting; it identifies discrepancies but does not make changes to your live systems, ensuring you maintain full control over remediation.

    Unlike standard AI prompting which can hallucinate or struggle with large datasets, this skill uses a specialized Python script to ensure 100% mathematical accuracy and repeatable results for audit-ready reporting.

    You will receive the core reconciliation logic (scripts/run.py), the required input/output JSON schemas for data mapping, and comprehensive documentation on how to format your HR and directory exports.

    The skill is designed to exclude service accounts and shared accounts by default to reduce noise, focusing your review on individual identity risks that matter most for compliance.