Blog Pro de Jean-Baptiste HEREN - CommentsNotes d'un consultant Freelance en Informatique2015-11-03T21:34:19+01:00JB HERENurn:md5:e39389b5ec134d99645112fce3d957dfDotclearRepair HFS+ Volume on OSX - Matturn:md5:ad309ffe06ac550cd804399e0790c9972012-01-10T10:03:39+01:002012-01-30T14:35:42+01:00Matt<p>Thanks for your post. I'm getting similar messages when I run disk utilities in Lion recovery partition, but it always manages to repair it. However, the issues keep coming back (found similar issues three times this week. Do you have any idea if that's hard drive or a software issue? I'd be interested in your thoughts.</p>Repair HFS+ Volume on OSX - Macdalorurn:md5:524eb52ec03188c78fdf02f3f68975e72011-10-26T20:52:14+02:002011-12-02T10:38:49+01:00Macdalor<p>brillant! I was getting ready to reformat and loose all data!!! thank you!!!</p>Extract Cognos reports & packages list with path - Mars13008urn:md5:9c8f4274ec115121cd3f532f7c1b797d2011-09-30T18:31:27+02:002011-10-12T09:16:26+02:00Mars13008<p>Thanks a lot.<br />
It's very useful!<br />
I've reworked the last script, you will find below:<br />
with lev as<br />
(<br />
SELECT cmobjnames.cmid,<br />
cmstoreids.storeid,<br />
cmobjects.pcmid,<br />
cmobjnames.name,<br />
cmobjnames.mapdlocaleid,<br />
cmobjnames.localeid,<br />
cmclasses.name AS type<br />
FROM cmobjects<br />
inner join cmobjnames on cmobjects.cmid = cmobjnames.cmid<br />
inner join cmclasses on cmobjects.classid = cmclasses.classid<br />
inner join cmstoreids on cmobjects.cmid = cmstoreids.cmid<br />
WHERE 1=1<br />
AND cmobjnames.ISDEFAULT=1<br />
),<br />
pkg as<br />
(<br />
SELECT cmrefnoord1.cmid AS pid,<br />
cmobjnames.name AS package_name<br />
FROM cmrefnoord1<br />
INNER JOIN cmobjects<br />
ON cmrefnoord1.refcmid = cmobjects.cmid<br />
INNER JOIN cmobjnames<br />
ON cmobjects.cmid = cmobjnames.cmid<br />
WHERE cmrefnoord1.propid = 31<br />
AND cmobjnames.ISDEFAULT=1<br />
)<br />
select<br />
--COUNT(1)<br />
A.CMID,<br />
L1.mapdlocaleid,<br />
L1.TYPE ,<br />
L1.NAME /*, L9.NAME, L8.NAME, L7.NAME, L6.NAME , L5.NAME, L4.NAME , L3.NAME , L2.NAME*/<br />
, LTRIM(SUBSTRING(<br />
CASE WHEN isnull(L10.NAME,'') = '/' THEN ' ' ELSE isnull(L10.NAME,'') END + CASE WHEN L10.NAME = '/' THEN '' ELSE '/' END<br />
+ CASE WHEN isnull(L9.NAME,'') = '/' THEN ' ' ELSE isnull(L9.NAME,'') END + CASE WHEN L9.NAME = '/' THEN '' ELSE '/' END<br />
+ CASE WHEN isnull(L8.NAME,'') = '/' THEN ' ' ELSE isnull(L8.NAME,'') END + CASE WHEN L8.NAME = '/' THEN '' ELSE '/' END<br />
+ CASE WHEN isnull(L7.NAME,'') = '/' THEN ' ' ELSE isnull(L7.NAME,'') END + CASE WHEN L7.NAME = '/' THEN '' ELSE '/' END<br />
+ CASE WHEN isnull(L6.NAME,'') = '/' THEN ' ' ELSE isnull(L6.NAME,'') END + CASE WHEN L6.NAME = '/' THEN '' ELSE '/' END<br />
+ CASE WHEN isnull(L5.NAME,'') = '/' THEN ' ' ELSE isnull(L5.NAME,'') END + CASE WHEN L5.NAME = '/' THEN '' ELSE '/' END<br />
+ CASE WHEN isnull(L4.NAME,'') = '/' THEN ' ' ELSE isnull(L4.NAME,'') END + CASE WHEN L4.NAME = '/' THEN '' ELSE '/' END<br />
+ CASE WHEN isnull(L3.NAME,'') = '/' THEN ' ' ELSE isnull(L3.NAME,'') END + CASE WHEN L3.NAME = '/' THEN '' ELSE '/' END<br />
+ isnull(L2.NAME ,'') + CASE WHEN L2.NAME = '/' THEN '' ELSE '/' END<br />
--+ isnull(L1.NAME ,'')<br />
, CHARINDEX('Public',<br />
isnull(L10.NAME,'') + CASE WHEN L10.NAME = '/' THEN '' ELSE '/' END<br />
+ isnull(L9.NAME ,'') + CASE WHEN L9.NAME = '/' THEN '' ELSE '/' END<br />
+ isnull(L8.NAME ,'') + CASE WHEN L8.NAME = '/' THEN '' ELSE '/' END<br />
+ isnull(L7.NAME ,'') + CASE WHEN L7.NAME = '/' THEN '' ELSE '/' END<br />
+ isnull(L6.NAME ,'') + CASE WHEN L6.NAME = '/' THEN '' ELSE '/' END<br />
+ isnull(L5.NAME ,'') + CASE WHEN L5.NAME = '/' THEN '' ELSE '/' END<br />
+ isnull(L4.NAME ,'') + CASE WHEN L4.NAME = '/' THEN '' ELSE '/' END<br />
+ isnull(L3.NAME ,'') + CASE WHEN L3.NAME = '/' THEN '' ELSE '/' END<br />
+ isnull(L2.NAME ,'') + CASE WHEN L2.NAME = '/' THEN '' ELSE '/' END<br />
--+ isnull(L1.NAME ,'')<br />
), LEN(<br />
isnull(L10.NAME,'') + CASE WHEN L10.NAME = '/' THEN '' ELSE '/' END<br />
+ isnull(L9.NAME ,'') + CASE WHEN L9.NAME = '/' THEN '' ELSE '/' END<br />
+ isnull(L8.NAME ,'') + CASE WHEN L8.NAME = '/' THEN '' ELSE '/' END<br />
+ isnull(L7.NAME ,'') + CASE WHEN L7.NAME = '/' THEN '' ELSE '/' END<br />
+ isnull(L6.NAME ,'') + CASE WHEN L6.NAME = '/' THEN '' ELSE '/' END<br />
+ isnull(L5.NAME ,'') + CASE WHEN L5.NAME = '/' THEN '' ELSE '/' END<br />
+ isnull(L4.NAME ,'') + CASE WHEN L4.NAME = '/' THEN '' ELSE '/' END<br />
+ isnull(L3.NAME ,'') + CASE WHEN L3.NAME = '/' THEN '' ELSE '/' END<br />
+ isnull(L2.NAME ,'') + CASE WHEN L2.NAME = '/' THEN '' ELSE '/' END<br />
--+ isnull(L1.NAME ,'')<br />
))<br />
) AS Path<br />
,package_name<br />
from<br />
CMOBJECTS A<br />
left join pkg on PKG.PID=a.cmid<br />
INNER JOIN lev l1 on L1.cmid =A.cmid<br />
inner JOIN lev l2 on L2.cmid =L1.pcmid<br />
inner JOIN lev l3 on L3.cmid =L2.pcmid<br />
inner JOIN lev l4 on L4.cmid =L3.pcmid<br />
inner JOIN lev l5 on L5.cmid =L4.pcmid<br />
inner JOIN lev l6 on L6.cmid =L5.pcmid<br />
inner JOIN lev l7 on L7.cmid =L6.pcmid<br />
inner JOIN lev l8 on L8.cmid =L7.pcmid<br />
inner JOIN lev l9 on L9.cmid =L8.pcmid<br />
inner JOIN lev l10 on L10.cmid =L9.pcmid<br />
where<br />
CLASSID IN (10,18) -- reports & packages</p>