Tuesday, March 10, 2015

Management Agent Statistics Enumeration

Following up on my previous post, here's where to find the statistics_type enumeration.
User Profile Synchronization (UPS): Database Data Access Protocol Specification
Copyright © 2012 Microsoft Corporation.
Release: Thursday, July 5, 2012
http://download.microsoft.com/download/5/0/1/501ED102-E53F-4CE0-AA6B-B0F93629DDC6/Windows/%5BMS-UPSDBDAP%5D.pdf
2.2.2.12 Management Agent Statistics Enumeration
The management agent statistics enumeration indicates which statistic type was updated.

This is in the mms_step_object_details table!

Hex Decimal Description
0x00000000
0
No statistics.
0x00000001
1
Staging unchanged.
0x00000002
2
Staging add.
0x00000003
3
Staging update.
0x00000004
4
Staging rename.
0x00000005
5
Staging delete.
0x00000006
6
Staging delete-add.
0x00000007
7
Staging failure.
0x00000008
8
Disconnector filtered.
0x00000009
9
Disconnector joined, no flow.
0x0000000A
10
Disconnector joined with flow.
0x0000000B
11
Disconnector joined, remove metaverse object.
0x0000000C
12
Disconnector projected, no flow.
0x0000000D
13
Disconnector projected with flow.
0x0000000E
14
Disconnector remains a disconnector.
0x0000000F
15
Connector filtered, remove metaverse object.
0x00000010
16
Connector filtered, leave metaverse object.
0x00000011
17
Connector with flow.
0x00000012
18
Connector with flow, remove metaverse object.
0x00000013
19
Connector, no flow.
0x00000014
20
Connector delete, remove metaverse object.
0x00000015
21
Connector delete, leave metaverse object.
0x00000016
22
Connector delete-add processed.
0x00000017
23
Flow failure.
0x00000018
24
Export add.
0x00000019
25
Export update.
0x0000001A
26
Export rename.
0x0000001B
27
Export delete.
0x0000001C
28
Export delete-add.
0x0000001D
29
Export failure.
0x0000001F
31
Provisioned flow.
0x00000020
32
Provisioned, no flow.
0x00000021
33
Provisioned add, no flow.
0x00000022
34
Provisioned add with flow.
0x00000023
35
Provisioned rename, no flow.
0x00000024
36
Provisioned rename with flow.
0x00000025
37
Provisioned delete.
0x00000026
38
Provisioned delete-add, no flow.
0x00000027
39
Provisioned delete-add with flow.
0x00000028
40
Provisioned flow reset.

Monday, March 9, 2015

FIM Sync filtered disconnectors SQL query

In case you were wondering, here's the SQL query that the FIM Sync Service Manager uses to fetch filtered disconnectors.

select cs_object_id, cs_dn from mms_step_object_details with(nolock) where step_history_id='{21D1945A-7E20-47CD-8E47-93762C343BEA}' and ((statistics_type=8))
Update: Here's where to find the statistics_type enumeration:
http://c--shark.blogspot.co.uk/2015/03/management-agent-statistics-enumeration.html