Asset Management Suite

Hi,
I've builded some new data classes and linked to some ressource types.
Is there a way to ckeck where the data classes are linked?

At the moment I've to check every resource if the data class is connected.

Thanks

The only place you can check is for each Resource Type under Resource and Data Class Settings.

You could right a report using these tables that could show you as well:

vResourceDataClass

Item

DataClass

Hello,

Here is a simple report to view resouces linked to dataclasses. The last line can be edited to meet your naming convention for your custom dataclasses.

select rt.Name as 'Resource Type'

,vdc.ResourceTypeGuid

,vdc.DataClassGuid

,dc.Name as 'DataClass'

,dc.DataTableName

,dc.Description

,dc.CreatedDate

from vResourceDataClass vdc

join vResourceType rt on rt.Guid=vdc.ResourceTypeGuid

join DataClass dc on dc.Guid=vdc.DataClassGuid

where dc.Name like 'myConvention%'

HI, this sounds good. I will try this next week. Thanks..

Nessaja any more information on this ?

HI Gunnelsrm,

this is exactly what I'm was looking for.

I've added the DataClasses as Report Parameter, this works fine.

Thanks for this.