Microstrategy BI Tech Pub

How to get Security filter Mapping details using Metadata Scripts? select OI.Object_name,OI1.Object_name,OI1.project_id from DSSMDOBJINFO OI join  (select I.Object_id A, I1.Object_id B,I.project_id C from DSSMDLNKITEM I join DSSMDLNKITEM I1 on I.Linkitem_id=I1.Linkitem_id where I.Link_id in (select Object_id from DSSMDOBJINFO where object_type=52 and Object_name='MD Security filter Link' and project_id in (select Object_id from DSSMDOBJINFO where Object_name in ('Project name 1','Project name 2') and object_type=32)) and I.project_id in (select Object_id from DSSMDOBJINFO where Object_name in ('Project name 1','Project name 2') and object_type=32) And I1.Object_type= 34 And I.Object_type=58) LI  on OI.Object_id=LI.B join DSSMDOBJINFO OI1 on OI1.Object_id=LI.A and OI1.Project_id=LI.C

How to get Connection Mapping details using metadata Scripts? select I.Object_name,I1.Object_name,I2.Object_name,I3.Object_name,I4.Object_name, from  DSSMDOBJINFO I inner Join (SELECT a1.LINKITEM_ID, a1.OBJECT_ID A, a2.OBJECT_ID B, a3.OBJECT_ID C, a4.OBJECT_ID D, a5.OBJECT_ID E FROM  (((DSSMDLNKITEM a1  INNER JOIN DSSMDLNKITEM a2  ON a1.LINKITEM_ID=a2.LINKITEM_ID)  INNER JOIN DSSMDLNKITEM a3  ON a1.LINKITEM_ID=a3.LINKITEM_ID)  INNER JOIN DSSMDLNKITEM a4  ON a1.LINKITEM_ID=a4.LINKITEM_ID)  INNER JOIN DSSMDLNKITEM a5  ON a1.LINKITEM_ID=a5.LINKITEM_ID  WHERE a1.LINK_ID='Connection Mapping Link ID (Object ID)' AND  a1.PROJECT_ID='0000000000000000000000000000000000000000' AND  a1.OBJECT_TYPE=32 AND  a2.OBJECT_TYPE=34 AND  a3.OBJECT_TYPE=29 AND  a4.OBJECT_TYPE=31 AND  a5.OBJECT_TYPE=30) ID on I.Object_id=ID.A inner join DSSMDOBJINFO I1 on I1.Object_id=ID.B ...