BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
AndreR
Calcite | Level 5

Hello,

I want to create an observation in a table each time a report is opened/refreshed in WRS with time, username and report name.

Time and username I already have, but I don't find anything on the net for the report name, doas anyone have a clue?

Can I get the report name through GETOPTION or METADATA_GETATTR somehow?

Here's the code for the SP, the SP is added in the information map:

%macro SAS_Report_Hit_Log;

    %let _timestamp  = %sysfunc(DATETIME());

    %let _metauser   = %scan(%sysfunc(getoption(METAUSER)),1,'@');

    %let _reportname = %scan(%sysfunc(getoption(???)),1,'@');

    proc sql;

        INSERT INTO PROD.CTL_SAS_REPORT_MONITORING

        (Timestamp, Username, ReportName)

        VALUES(&_timestamp, "&_metauser", "&_reportname");

    quit;

%mend SAS_Report_Hit_Log;

%SAS_Report_Hit_Log;

Thanks in advance,

Kind regards,

André

1 ACCEPTED SOLUTION

Accepted Solutions
AndreR
Calcite | Level 5

Hello NN,

thanks a lot for your answer, i will check the keyActions.log.

I already parse the jboss server.log for user logins, maybe the

keyActions.log can be parsed the same way.

Yes, I could put it in the prompt for each Infomap,

or I could create a SP for each report hard-coding the report name,

and it would work both ways, but there has to be an easier way.

Getting a report about which reports are used most by my users

is all I want, maybe this functionality is already hidden somewhere,

I just don't see it.

Have a nice weekend,

Kind regards,

André

View solution in original post

4 REPLIES 4
NN
Quartz | Level 8 NN
Quartz | Level 8

Hi,

I am sorry i donot have an exact solution for your request..

But i thought there were server logs which were available which would have given you all the information that you were looking for..

A sasnote which i felt was somewhat in the same lines is http://support.sas.com/kb/39/510.html

And a roundaout solution which comes to my mind if nothing else works is to define condition in your Infomap which will contain the report name and then use it in the Prompt for the STP

.....

AndreR
Calcite | Level 5

Hello NN,

thanks a lot for your answer, i will check the keyActions.log.

I already parse the jboss server.log for user logins, maybe the

keyActions.log can be parsed the same way.

Yes, I could put it in the prompt for each Infomap,

or I could create a SP for each report hard-coding the report name,

and it would work both ways, but there has to be an easier way.

Getting a report about which reports are used most by my users

is all I want, maybe this functionality is already hidden somewhere,

I just don't see it.

Have a nice weekend,

Kind regards,

André

twocanbazza
Quartz | Level 8

Have a look at SAS Aduit Monitoring and performance (APM), it contains a out of the box report for top ten reports.... you can modify that to add user etc.

The APM Creates an artifacts table which contains all the KeyAction details, and other logs - parses logs nightly...

A little bit fiddly to set up if on multiple machines but instructions are good.

Barry

AndreR
Calcite | Level 5

Hello Barry,

thanks for your tip, I will look into SAS APM.

Kind regards,

André

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1328 views
  • 6 likes
  • 3 in conversation