Goal: I need a report that will isolate the share permissions for a specific account (IT_RestrictedServerAccess) and then compare that to the list of share information, compare the two and return only the differences.
Issue: Currently when I try to run a share permission exception report (excluding the specific account) it returns a list of all shares and share permissions where other accounts have been assigned access instead of just shares where this account has no permissions.
Workaround: I have scheduled two reports Share Information and Share permissions for account and then wrote a script to compare the two datasets and output the differences, but I would prefer to be able to run this directly in ER to get the desired results.
Example of what like the report to return:
SHARE INFORMATION REPORT
SHARE PERMISSIONS FOR ACCOUNT REPORT where acct = IT_RestrictedServerAccess
SHARE RESULTS ON FINAL REPORT
Computer Name (Computer)
Share Name (Share)
Share Path (Share)
Account Name (Account)
Taleo Connect Client
F:\Taleo Connect Client
Hey Todd,Based on the specified requirement, I have created a custom report for you. Please refer to this link for the attached report and the sql statement in SQL_to_Add_Accounts.txt file.en.community.dell.com/.../20440868Execute the attached SQL statements against your ER database. Make sure to backup your database.In order to use the attached custom report, please perform following steps:
Please let me know how this goes.Thanks & Regards,Aarti
We are currently looking into this and will keep you updated.