Example: Number of identities in the company
The number of people in the company should be displayed in the statistics. This statistic should be calculated daily. The statistics definition could look like:
Statistic: |
CountIdentities |
Display name: |
Number of identities |
Description: |
Finds the number of identities in the company on a daily basis. |
Calculation schedule: |
Calculate statistics |
Measurements query: |
select 'Identities' as ElementName, count (*) as ElementValue from Person |
To display the statistics in the Manager in the Identities > Info system category, the following menu item is created:
Menu item: |
Person.InfoSystem.CountIdentities |
Item type: |
Statistics |
Sort order |
1 |
Statistic: |
Number of identities |
Diagram type: |
Thermometer |
The menu item is assigned to the Manager program and an application role and can then be displayed in the Manager.
Example: Number of external identities in the company
The number of external identities in the company should be displayed in the statistics. This statistic should be calculated weekly. If more than 20% of identities in the company are externals, the info system should display the state as acceptable instead of a correct. If more than 80% are externals the state should be unacceptable.
Statistic: |
CountExternalIdentities |
Display name: |
Number of external identities. |
Description: |
Find the number of external identities in the company on a weekly basis. |
Calculation schedule: |
Calculate weekly statistics |
Measurements query: |
Select 'Identities' as ElementName, Count (*) as ElementValue from Person where IsExternal = 1 |
Base measurements query: |
Select 'Identities' as ElementName, Count (*) as ElementValue from Person |
Threshold green: |
0.2 |
Threshold red: |
0.8 |
To display the statistics in the Manager in the Identities > Info system category, the following menu item is created:
Menu item: |
Person.InfoSystem.CountExternalIdentities |
Item type: |
Statistics |
Sort order |
2 |
Statistic: |
Number of external identities. |
Diagram type: |
Traffic light |
The menu item is assigned to the Manager program and an application role and can then be displayed in the Manager.
Example: Number of direct reports
The number of identities, for which the current user is entered directly as manager, should be represented in a statistic. Restrictions to the values for the current user are made though a condition.
Statistic: |
CountIdentitiesPersonHead |
Display name: |
Number of direct reports. |
Description: |
Finds the number of identities for which the manager is responsible on a daily basis. |
Calculation schedule: |
Calculate statistics |
Measurements query: |
select XObjectKey as ElementObjectKey, 'Identities' as ElementName, Count (*) as ElementValue from Person where IsExternal = 1 Group by XObjectKey |
Condition: |
ElementObjectKey in (select XObjectKey from Person where uid_PersonHead = '%useruid%') |
Example: Number of internal and external identities per department
Internal and external identities, which the current user supervises as department manager, should be represented in a statistic. Departments are added here separately to determine clear results for displaying the measurement because a department manager might be responsible for more than one department.
Statistic: |
IdentityCountInternalExternal_By_Department |
Display name: |
Number of internal and external identities |
Description: |
Finds the number of internal and external identities per department on a daily basis. |
Calculation schedule: |
Calculate statistics |
Measurements query: |
select d.XObjectKey as ElementObjectKey, 'Internal' as ElementName, count(p.uid_person) as ElementValue from Department d Left Outer Join Person p on p.UID_Department = d.UID_Department and p.IsExternal = 0 Group By d.XObjectKey UNION ALL select d.XObjectKey as ElementObjectKey, 'External' as ElementName, count(p.uid_person) as ElementValue from Department d Left Outer Join Person p on p.UID_Department = d.UID_Department and p.IsExternal = 1 Group By d.XObjectKey |
Condition: |
ElementObjectKey in (select d.XObjectKey from Department d join helperheadorg hpo on d.UID_Department = hpo.UID_Org where hpo.UID_PersonHead = '%useruid%') |
Aggregate function |
SUM |
Example: Top 10 activated identities by risk index
Ten identities with the highest risk index should be found and displayed in a statistic. They should be sorted by measurement unit.
Statistic: |
Top10ActiveIdentitiesByRiskIndex |
Display name: |
Top 10 active identities by risk index |
Description: |
Find ten active identities with the highest risk indexes on a daily basis. |
Calculation schedule: |
Calculate statistics |
Measurements query: |
select top 10 p.InternalName as ElementName, Round(100 * IsNull(p.RiskIndexCalculated, 0), 0) as ElementValue, p.XObjectKey as ElementObjectKey, ROW_NUMBER() over (order by IsNull(p.RiskIndexCalculated, 0) desc, p.InternalName) as ElementOrder from Person p where p.IsInActive = 0 order by ElementOrder |