topic Re: Required ACT's code in Administration and Deployment

Required ACT's code

NagaKumar — Fri, 03 Mar 2017 12:04:43 GMT

Hi All,

We have so many ACT's applied on Folders in SAS Management console. Is there any code to retrive which folder the ACT's applied?

Thanks in Advance.

Naga.

Re: Required ACT's code

JuanS_OCS — Fri, 03 Mar 2017 13:06:10 GMT

Hello @NagaKumar,

I don;t know which version of SAS you have installed, but in any case, there are many options for you:

- you can create your own code with the SAS interfaces to Metadata

- you can use pre-built tools as the Metacoda ( @MichelleHomes ) and get many other great additions.

- You can use the APM/ACM reports which can give you a good inventory of your metadata :

https://platformadmin.com/blogs/paul/tag/sas-apm/

http://blogs.sas.com/content/sgf/2014/11/26/sas-environment-manager-data-mart-the-heart-of-the-service-management-architecture/

Re: Required ACT's code

PaulHomes — Fri, 03 Mar 2017 13:29:56 GMT

Thanks Juan for mentioning Metacoda Plug-ins.

I might also add that the Metacoda ACT Reviewer is one of the plug-ins that is available free-of-charge. As well as interactively showing the objects to which ACTs are applied it can also be used to export an HTML report as documentation for ACTs - how they are defined, where they have been applied, and how they have been protected.

Re: Required ACT's code

NagaKumar — Sat, 04 Mar 2017 06:54:19 GMT

Hi..

We are using SAS 9.4 M3 version. Thanks for providing the solutions.

Re: Required ACT's code

JuanS_OCS — Sun, 05 Mar 2017 21:22:58 GMT

With SAS 9.4 M3 you should have available all the latest updates to the SAS Environment Manager, and its Extended Monitoring (EMI).

Re: Required ACT's code

red — Wed, 27 Sep 2017 06:21:03 GMT

Hi,

Yoy can use the following code that will gives you where ACTs are applied :

data ACT (keep=id name PublicType location _created _modified );
length id $20 name PublicType $70 _uri $256 _modified _created $25 location _location $256;
length created modified 8;
format created modified datetime.;
_nobj=1;
_n=1;

call missing(id, _uri, name, _modified, _created, _location, PublicType);

do while(_n le _nobj);
     _nobj=metadata_getnobj("omsobj:AccessControlTemplate?@Id contains '.'",_n,_uri);

    _rc=metadata_getattr(_uri,"Id",id);
    _rc=metadata_getattr(_uri,"Name",name);
    _rc=metadata_getattr(_uri,"PublicType",PublicType);
    _rc=metadata_getattr(_uri,"MetadataCreated",_created);
    _rc=metadata_getattr(_uri,"MetadataUpdated",_modified);


    _rc=metadata_getnasn(_uri,"Objects",1,_uri);
    _rc=metadata_getattr(_uri,"Name",location);
    _tree=1;
    do while (_tree>0);
      _tree=metadata_getnasn(_uri,"ParentTree",1,_uri);
      if _tree > 0 then do;
        _rc=metadata_getattr(_uri,"Name",_location);
        location=catx('/',_location,location);
      end;
    end;
    location = '/'||location;
    output;
    _n=_n+1;
end;
run;

Regrad,

Redouan