Post reply

Next AD Computer Account

  • February 1, 2018 at 10:52 am

    #410167

    Hi All..

    I am looking to create a report that will list let’s say the next 10 available AD computer names in a specific OU

    I have managed to query AD and list all the machines that are in a specific OU

    Is there a function in SQL I can use to identify a sequence and generate the next computer numbers and display in a report.

    Thanks in advance.

  • February 5, 2018 at 1:33 am

    #1978508

    Are you talking about ROW_NUMBER()?

  • February 5, 2018 at 12:34 pm

    #1978614

    James.Bowtell - Thursday, February 1, 2018 10:52 AM

    Hi All..I am looking to create a report that will list let’s say the next 10 available AD computer names in a specific OUI have managed to query AD and list all the machines that are in a specific OU Is there a function in SQL I can use to identify a sequence and generate the next computer numbers and display in a report. Thanks in advance.

    There is no built in function to recognize the naming pattern, convention that you use for in  AD to name computers. You would need to write your own.

    Sue

  • February 6, 2018 at 2:28 am

    #1978667

    Get the most recently added computer from active directory. Strip the alpha characters so only the number is left. Increase the number.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

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

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