Hello Manish,
If the AXUtil schema didn't work, try this...
Open SQL server management studio,
Select the AX database from the database list and Create a new query (Ctrl+N)
then copy past the following code in the Query window, and Execute the query.
-------------------------------------------
ALTER VIEW [dbo].[UTILELEMENTS] AS
SELECT -- Select all Root Elements or Id based children or Root Elements with no children
d.[LayerId] AS UTILLEVEL,
e.[ElementType] AS RECORDTYPE,
e.[ParentId] AS PARENTID,
e.[Name] AS NAME,
cs.[SourceText] AS SOURCE,
cast(NULL AS varbinary(max)) AS CODE,
d.[BASEVERSION],
d.[VERSION],
d.[SAVECOUNT],
d.[MODIFIEDDATETIME],
0 AS DEL_MODIFIEDTIME,
d.[MODIFIEDBY],
d.[CREATEDDATETIME],
0 AS DEL_CREATEDTIME,
d.[CREATEDBY],
d.ElementVersion AS RECVERSION,
d.[LayerId] * cast(268435456 as bigint) + e.[ElementHandle] AS RECID
FROM [dbo].[ModelElement] AS e WITH (READUNCOMMITTED)
INNER JOIN [dbo].[ModelElementData] AS d WITH (READUNCOMMITTED)
ON d.ElementHandle = e.ElementHandle
LEFT OUTER JOIN [dbo].[Sources] AS cs WITH (READUNCOMMITTED)
ON cs.SourceHandle = e.ElementHandle
AND cs.LayerId = d.LayerId
WHERE
e.ParentHandle = 0 -- Only Root element
AND NOT EXISTS
(SELECT 1 FROM [dbo].[ModelElement] AS gc WITH (READUNCOMMITTED)
WHERE gc.ParentHandle = e.ElementHandle AND gc.ParentId = 0)
OR (e.ParentHandle <> 0 AND e.ParentId <> 0) -- Or Not granular child
UNION ALL
SELECT -- Select all Granular Root Elements children
ug.[LayerId] AS UTILLEVEL, -- dgc = Distinct Granular Child Layers
e.[ElementType] AS RECORDTYPE,
e.[ParentId] AS PARENTID,
e.[Name] AS NAME,
cs.[SourceText] AS SOURCE,
cast(NULL AS varbinary(max)) AS CODE,
d.[BASEVERSION],
d.[VERSION],
d.[SAVECOUNT],
d.[MODIFIEDDATETIME],
0 AS DEL_MODIFIEDTIME,
d.[MODIFIEDBY],
d.[CREATEDDATETIME],
0 AS DEL_CREATEDTIME,
d.[CREATEDBY],
d.ElementVersion AS RECVERSION,
d.[LayerId] * cast(268435456 as bigint) + e.[ElementHandle] AS RECID
FROM [dbo].[ModelElement] AS e WITH (READUNCOMMITTED)
INNER JOIN [dbo].[UtilGranularLayers] AS ug WITH (READUNCOMMITTED) ON ug.RootHandle = e.ElementHandle
INNER JOIN [dbo].[ModelElementData] AS d WITH (READUNCOMMITTED) ON d.ElementHandle = e.ElementHandle
LEFT OUTER JOIN [dbo].[Sources] AS cs WITH (READUNCOMMITTED)
ON cs.SourceHandle = e.ElementHandle
AND cs.LayerId = d.LayerId
WHERE
e.ParentHandle = 0 -- Only Root element
AND EXISTS
(SELECT 1 FROM [dbo].ModelElement AS gc WITH (READUNCOMMITTED)
WHERE gc.ParentHandle = e.ElementHandle AND gc.ParentId = 0) -- Granular child
---------------------------------
ALTER VIEW [dbo].[UTILIDELEMENTS] AS
SELECT -- Select all Root Elements or Id based children or Root Elements with no children
d.[LayerId] AS UTILLEVEL,
e.[ElementType] AS RECORDTYPE,
e.[ParentId] AS PARENTID,
e.[Name] AS NAME,
e.[AxId] AS ID,
cs.[SourceText] AS SOURCE,
cast(NULL AS varbinary(max)) AS CODE,
d.[BASEVERSION],
d.[VERSION],
d.[SAVECOUNT],
d.[MODIFIEDDATETIME],
0 AS DEL_MODIFIEDTIME,
d.[MODIFIEDBY],
d.[CREATEDDATETIME],
0 AS DEL_CREATEDTIME,
d.[CREATEDBY],
d.ElementVersion AS RECVERSION,
d.[LayerId] * cast(268435456 as bigint) + e.[ElementHandle] AS RECID
FROM [dbo].[ModelElement] AS e WITH (READUNCOMMITTED)
INNER JOIN [dbo].[ModelElementData] AS d WITH (READUNCOMMITTED)
ON d.ElementHandle = e.ElementHandle
LEFT OUTER JOIN [dbo].[Sources] AS cs WITH (READUNCOMMITTED)
ON cs.SourceHandle = e.ElementHandle
AND cs.LayerId = d.LayerId
WHERE
e.ParentHandle = 0 -- Only Root element
AND NOT EXISTS
(SELECT 1 FROM [dbo].[ModelElement] AS gc WITH (READUNCOMMITTED)
WHERE gc.ParentHandle = e.ElementHandle AND gc.ParentId = 0)
OR (e.ParentHandle <> 0 AND e.ParentId <> 0) -- Or Not granular child
UNION ALL
SELECT -- Select all Granular Root Elements children
ug.[LayerId] AS UTILLEVEL, -- dgc = Distinct Granular Child Layers
e.[ElementType] AS RECORDTYPE,
e.[ParentId] AS PARENTID,
e.[Name] AS NAME,
e.[AxId] AS ID,
cs.[SourceText] AS SOURCE,
cast(NULL AS varbinary(max)) AS CODE,
d.[BASEVERSION],
d.[VERSION],
d.[SAVECOUNT],
d.[MODIFIEDDATETIME],
0 AS DEL_MODIFIEDTIME,
d.[MODIFIEDBY],
d.[CREATEDDATETIME],
0 AS DEL_CREATEDTIME,
d.[CREATEDBY],
d.ElementVersion AS RECVERSION,
d.[LayerId] * cast(268435456 as bigint) + e.[ElementHandle] AS RECID
FROM [dbo].[ModelElement] AS e WITH (READUNCOMMITTED)
INNER JOIN [dbo].[UtilGranularLayers] AS ug WITH (READUNCOMMITTED) ON ug.RootHandle = e.ElementHandle
INNER JOIN [dbo].[ModelElementData] AS d WITH (READUNCOMMITTED) ON d.ElementHandle = e.ElementHandle
LEFT OUTER JOIN [dbo].[Sources] AS cs WITH (READUNCOMMITTED)
ON cs.SourceHandle = e.ElementHandle
AND cs.LayerId = d.LayerId
WHERE
e.ParentHandle = 0 -- Only Root element
AND EXISTS
(SELECT 1 FROM [dbo].ModelElement AS gc WITH (READUNCOMMITTED)
WHERE gc.ParentHandle = e.ElementHandle AND gc.ParentId = 0) -- Granular child
------------
