Need: Isolated share permissions report - Enterprise Reporter Custom Reports - Enterprise Reporter Custom Reports - Dell Community

Need: Isolated share permissions report

Enterprise Reporter Custom Reports

Enterprise Reporter Custom Reports
Find, share and request custom reports you would like to see in Enterprise Reporter.

Need: Isolated share permissions report

This question has been answered by DELL-Aarti M

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)

Computer Name (Computer)

Share Name (Share)

Account Name (Account)

 

 

 

Computer Name (Computer)

Share Name (Share)

Account Name (Account)

Server2

Psoft

F:\Psoft

Server2

Psoft

RJF\IT_RestrictServerAccess

Server2

RJApps

F:\inetpub\RJApps

Server2

RJApps

RJF\IT_RestrictServerAccess

Server2

RJApps$

F:\inetpub\wwwroot\RJApps

Server2

RJApps$

RJF\IT_RestrictServerAccess

Server2

Taleo Connect Client

F:\Taleo Connect Client

Server2

Taleo Connect Client

F:\Taleo Connect Client

Server2

TCC_Touchpoints$

f:\TCC_Touchpoints

Server2

TCC_Touchpoints$

f:\TCC_Touchpoints

 

 

 

 

 

 

 

Verified Answer
  • 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/.../20440868

    Execute 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:

    1. Save the attached "Isolated Share Permissions.xrd" file
    2. Launch Report Manager and go to My Reports
    3. Click on Import button and point to the location where you have saved the "Isolated Share Permissions.xrd" and click OK.

    Please let me know how this goes.

    Thanks & Regards,
    Aarti

All Replies
  • Hello Todd,

    We are currently looking into this and will keep you updated.

    thanks.

    Samer

  • 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/.../20440868

    Execute 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:

    1. Save the attached "Isolated Share Permissions.xrd" file
    2. Launch Report Manager and go to My Reports
    3. Click on Import button and point to the location where you have saved the "Isolated Share Permissions.xrd" and click OK.

    Please let me know how this goes.

    Thanks & Regards,
    Aarti