How to find out reports related to one package?

[bvk.cognoise]

Hi ,

we have 300 reports.how to find out all reports which is developed using particular package?

thanks
vamsi

[blom0344]

This works - quite roughly for me:

Code Select Expand


select distinct subselect.cmid,subselect.package,subselect.refcmid,ref1.name as report from
(select ref2.cmid as j,ref2.*,packages.name as package from
(select distinct c1.cmid,c2.name from cmobjects c1
inner join
cmobjnames c2 on c1.cmid = c2.cmid
where classid = 18) packages
inner join
dbo.CMREFNOORD1 ref2
on
ref2.refcmid = packages.cmid) subselect
inner join
dbo.CMOBJNAMES ref1
ON SUBSELECT.J = ref1.cmid
where isdate(ref1.name) = 0


provided contentstore is on SQL server   ;)

[bvk.cognoise]

HI Blom,

thank you very much for your reply .i tried this method but i am not able to get correct result.could you please elaborate this.

thanks
bvk

[blom0344]

In my particular contentstore the classid 18 indicates a package. could be different with you installation, so it would be a matter of adjusting the id (to your particular value)