topic Database Usage report in SAS Data Management

Database Usage report

vorkady — Mon, 15 Oct 2018 13:34:39 GMT

We would like to generate user database usage report in SAS Environment. We have SAS Access to Netezza configured to access Netezza database. Is it possible to list such user usage reports using SAS scripts or sourcing SAS logs. Appreciate if you cold advise.

Thanks in adavance

Re: Database Usage report

Patrick — Wed, 17 Oct 2018 09:08:02 GMT

@vorkady

Using explicit SQL Pass-through you can query directly the database with native Netezza SQL. Not sure what level of information Netezza stores but whatever is there can be queried out of SAS.

Assuming that such information is likely admin level you would of course also need the required privileges for the user connecting to Netezza to have access to such information.