Obtaining creator of SAS VA report from metadata

[LukaszStasiak]

Hello guys,

I'm trying to access the names of the creators (or person who last updated the report) of the reports in SAS VA without checking in the creators of the physical files on the server, which are not accessible for me. Is this sort of data stored in METADATA?

I used the %MDSECDS macro to access the metadat, and the automatically createrd MDSECDS_OBJS table containst most of the data I need, but creator of the report is not amongst them.

Is there a way to access the name of the person, who created or updated the report is SAS VA (would be great to obtain it using EG)?

Thanks!

[alexal]

@LukaszStasiak,

I would suggest you to use the utility called sas-list-objects to get an XML with all reports from the specific metadata folder, here is an example:

/<SASHome>/SASPlatformObjectFramework/9.4/tools/sas-list-objects -host <METADATA_HOST> -port 8561 -user <METADATA_USER> -password <METADATA_PASSWORD> -folder "/Products/SAS Visual Analytics/Samples/" -types Report -format xml

Here are results:

<?xml version='1.0' encoding='UTF-8'?>
<Objects>
<Object Path="/Products/SAS Visual Analytics/Samples/Capital Exposure and Risk Sample(Report)" Name="Capital Exposure and Risk Sample" Type="Report.BI" TypeLabel="SAS report (2G)" Description="This demo illustrates how financial institutions can gain an understanding of their portfolio risks across the business they can better manage exposures and make well informed decisions." Created="2015-09-16T22:21:06Z" CreatedBy="sasadm" Modified="2016-12-13T23:21:36Z" ModifiedBy="sasadm"/>
<Object Path="/Products/SAS Visual Analytics/Samples/Casino Floor Performance Sample(Report)" Name="Casino Floor Performance Sample" Type="Report.BI" TypeLabel="SAS report (2G)" Description="This demo example looks at casino floor performance at a two-casino gaming company." Created="2015-09-16T22:21:06Z" CreatedBy="sasadm" Modified="2016-12-13T23:21:36Z" ModifiedBy="sasadm"/>
<Object Path="/Products/SAS Visual Analytics/Samples/Revenue Optimization Sample(Report)" Name="Revenue Optimization Sample" Type="Report.BI" TypeLabel="SAS report (2G)" Description="This demo illustrates how retailers can see which products are not priced competitively, which products should be considered for a price markdown, and how well promotional plans are performing." Created="2015-09-16T22:21:06Z" CreatedBy="sasadm" Modified="2016-12-13T23:21:36Z" ModifiedBy="sasadm"/>
<Object Path="/Products/SAS Visual Analytics/Samples/SAS Visual Analytics Sample(Report)" Name="SAS Visual Analytics Sample" Type="Report.BI" TypeLabel="SAS report (2G)" Description="SAS Visual Analytics Sample" Created="2015-09-16T22:20:56Z" CreatedBy="sasadm" Modified="2016-12-13T23:21:23Z" ModifiedBy="sasadm"/>
<Object Path="/Products/SAS Visual Analytics/Samples/SAS Visual Analytics Sample Includes Exploration Content(Report)" Name="SAS Visual Analytics Sample Includes Exploration Content" Type="Report.BI" TypeLabel="SAS report (2G)" Description="" Created="2015-09-16T22:19:57Z" CreatedBy="sasadm" Modified="2016-12-13T23:20:05Z" ModifiedBy="sasadm"/>
<Object Path="/Products/SAS Visual Analytics/Samples/Student Analysis Sample(Report)" Name="Student Analysis Sample" Type="Report.BI" TypeLabel="SAS report (2G)" Description="" Created="2015-09-16T22:21:06Z" CreatedBy="sasadm" Modified="2016-12-13T23:21:36Z" ModifiedBy="sasadm"/>
<Object Path="/Products/SAS Visual Analytics/Samples/Warranty Analysis Sample(Report)" Name="Warranty Analysis Sample" Type="Report.BI" TypeLabel="SAS report (2G)" Description="This demo explores how organizations can effectively analyze warranty claims to identify potential issues and understand the drivers of these issues." Created="2015-09-16T22:21:06Z" CreatedBy="sasadm" Modified="2016-12-13T23:21:36Z" ModifiedBy="sasadm"/>
<Object Path="/Products/SAS Visual Analytics/Samples/Wireless Call Quality Analysis Sample(Report)" Name="Wireless Call Quality Analysis Sample" Type="Report.BI" TypeLabel="SAS report (2G)" Description="This demo explores how a network operations manager or engineer might analyze call quality at a communications service provider." Created="2015-09-16T22:21:06Z" CreatedBy="sasadm" Modified="2016-12-13T23:21:36Z" ModifiedBy="sasadm"/>

All you need to do after that is parse an XML file.