• 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