Reporting and Monitoring Mass Operations

Configure SQLite reporting through the external data store in the hid_global_configuration table:

Mass Password Reset Operations:

Mass Onboarding Operations:

When enabled, it automatically generates SQLite reports for all operations.

SQLite Report Location:

CREATE TABLE operation (
    id TEXT NOT NULL,           -- Account/User identifier
    host TEXT NOT NULL,         -- Target system
    name TEXT NOT NULL,         -- Account/User name
    type TEXT NOT NULL,         -- Operation type (account, group, new_group)
    phase TEXT NOT NULL,        -- Process phase
    result TEXT NOT NULL,       -- success/failure
    details TEXT                -- Error details (populated on failure)
);
    

SELECT 
    result,
    COUNT(*) as total_operations,
    ROUND(COUNT(*) * 100.0 / (SELECT COUNT(*) FROM operation), 2) as percentage
FROM operation 
GROUP BY result;
    

SELECT 
    phase,
    result,
    COUNT(*) as count,
    ROUND(COUNT(*) * 100.0 / SUM(COUNT(*)) OVER (PARTITION BY phase), 2) as phase_percentage
FROM operation 
GROUP BY phase, result 
ORDER BY phase, result;
    

SELECT 
    host,
    type,
    COUNT(*) as operations,
    SUM(CASE WHEN result = 'success' THEN 1 ELSE 0 END) as successful,
    SUM(CASE WHEN result = 'failure' THEN 1 ELSE 0 END) as failed
FROM operation 
GROUP BY host, type 
ORDER BY host, type;
    

SELECT 
    phase,
    type,
    COUNT(*) as failure_count,
    details
FROM operation 
WHERE result = 'failure' 
GROUP BY phase, type, details
ORDER BY failure_count DESC;
    

Required User Classes:

GET /api/rest/v2/sessionLogs
$filter=operation eq 'OPC4'
$expand=requester,data
$orderby=metadata/lastUpdatedDateTime desc
    

GET /api/rest/v2/sessionLogs
$filter=operation eq 'CRTG'
$expand=requester,data(expand=group,targetSystem)
$orderby=metadata/lastUpdatedDateTime desc
    

GET /api/rest/v2/sessionLogs
$filter=operation eq 'GRUA'
$expand=requester,data(expand=account,targetSystem,group)
$orderby=metadata/lastUpdatedDateTime desc
    

GET /api/rest/v2/sessionLogs
$filter=operation eq 'ACUA'
$expand=requester,data(expand=account,targetSystem)
$orderby=metadata/lastUpdatedDateTime desc
    

GET /api/rest/v2/sessionLogs
$filter=operation eq 'ACHG'
$expand=requester,data(expand=account,targetSystem)
$orderby=metadata/lastUpdatedDateTime desc
    

Operations within the same mass process share a common batchId in the session logs, enabling correlation between: