Post reply

Create a SRSS report based on Active Directory Group membership??? Possible?

  • April 3, 2017 at 5:06 am

    #322740

    Hi,

    I need to create a report displaying all the users within one Active Directory group. There are only about 15 users within the AD group.

    Can anyone tell me or give an example of how I can create a report which displays the members name (firstname and lastname), department, email directly from an AD group without using any SQL tables?

    Is this possible?

    thanks

  • April 3, 2017 at 5:16 am

    #1936235

    Sounds like a job for PowerShell.  The PowerShell commands come with the AD client tools, if I remember correctly.  Or you could set up a linked server to AD and query that, although it's by no means easy.  Why don't you want to use a table?

    John

  • April 3, 2017 at 5:25 am

    #1936237

    I

    John Mitchell-245523 - Monday, April 3, 2017 5:16 AM

    Sounds like a job for PowerShell.  The PowerShell commands come with the AD client tools, if I remember correctly.  Or you could set up a linked server to AD and query that, although it's by no means easy.  Why don't you want to use a table?

    John

    Hi John,

    Thanks for the quick reply.
    I'm new to SRSS and just going by what I know so far.

    I could use powershell, but i want to display the group membership in an SRSS report, so was just wondering how i could access the group membership vi AD.

    Is there a simple way of achieving what I want? I don't need to edit the membership, just simply display the membership of the AD group in the report.

    Thanks

  • April 3, 2017 at 5:33 am

    #1936240

    Use xp_cmdshell to call the PowerShell command from a stored procedure.  That's probably the simplest way.

    John

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply