Database Usage report

[vorkady]

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  

[Patrick]

@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.