Hi all,

I need 2  scripts to run in the Query Reports which contains the following Colum's:

All Users/requesters:

Below are the types of data required for the extract, which are dependent on the risk level given to it:

Risk ratings of 6 or 7 will require:

• First Name

• Surname

• Username (login name)

• Permission profile or access level (Tech Roles)

• Description of each profile or access level (Support Groups)

• Department

Risk rating of 8 or 9 require the same as above, with additional:

• Full list of granular permissions given by each profile (Read, Write, Authorize, every permission table available) (Roles & their access)

Any chance someone could knock me up these Query's as I am no SQL Admin :)

Thanks

Kind Regards

Colin Hardwick