It depends if the serial numbers are part of the mobo or self-generated numbers etc...

Use software like PDQ inventory to get the machine's inventory. 

Spice (2) flagReport

Was this post helpful? thumb_up thumb_down

are there any free tools are scripts to run to get the serial no of the laptops form ad.

Wmic bios get serialnumber

May be this is useful to you
https://social.technet.microsoft.com/Forums/windows/en-US/0c473196-afd0-43ec-b812-db54d62c2b16/serial-number-attribute-of-computer-object?forum=winserverDS

Spice (3) flagReport

Was this post helpful? thumb_up thumb_down

What everybody is saying is that the Serial Number is not a normal value stored in Active Directory. If you have some script putting those values into Active Directory, that wil be your source reference. You can use Active Directory as a reference to all of your computer names and then pull that information from each of the machines.

Goverlan tools can reach out to the BIOS on Lenovo and Dell computers and pull serial numbers and service tags for inventory purposes. Not a free application but very reasonably priced.

PDQ inventory free can do this.  You can then export them to a CSV.  Basically install PDQ Inventory, import your computers from AD and scan them.  You can then create a report that includes the fields you want.

https://www.pdq.com/pdq-inventory/

zain2425 wrote:

are there any free tools are scripts to run to get the serial no of the laptops form ad.

What make & models are these machines ?

The info is not in Domain Controllers

all are windos 10 machines , domain is 2016 but i need the  info exported to excel or csv as we are having around 300 machines 

zain2425 wrote:

all are windos 10 machines , domain is 2016 but i need the  info exported to excel or csv as we are having around 300 machines 

Bro...make & model as in Brand and model ?? The information is not on Domain Controller but on mobo of the PCs (if any).

To get the serial number of your computer open Windows PowerShell and run

Or use Get-WmiObject.

Check this article, please https://sid-500.com/2018/05/14/get-serial-numbers-of-all-domain-computers-by-using-windows-powershel...

How to run on active directory to get for all computers. can you send me the script 

zain2425 wrote:

How to run on active directory to get for all computers.

You have been old already 3 times that this data is not in Active Directory as long as you don't extent Active Directory and import that data into Active Directory. You've been told already 6 times about several available alternatives to get such info, allowing you to create your desired report in desired format.

zain2425 wrote:

i need the  info exported to excel or csv as we are having around 300 machines 

• So what prevented you to create such a CSV file using any of the proposed alternatives to get such a list of serial numbers?
• What prevented you to install Excel if a CSV file is no longer considered sufficient for you?
• So what prevented you to create such a script for such CSV file creation if the manual processing is no longer sufficient?
• What prevented you in importing your desired information into Active Directory after you learned that it is not there and where to get it?
  
• What's the domain of your professional IT expertise?
  

zain2425 wrote:

How to run on active directory to get for all computers. can you send me the script 

# Requires ActiveRoles CmdLets from Quest Software (They're free and awesome) - http://www.quest.com/powershell/activeroles-server.aspx
Get-QADComputer -searchroot "OU=yourcomputerOUname,dc=yourdomain,dc=com" -SizeLimit 0 |
ForEach-Object {
  $hostname = $_.name
  $serialnumber = (Get-WMIObject Win32_BIOS -computer $hostname -ErrorAction SilentlyContinue).SerialNumber
  if (-not $serialnumber) {
    Add-Content d:\logfiles\offlinehosts.txt "$hostname is in offline"
  }
  else {
  Write-Host "$hostname,$serialnumber" # output to screen 
  Add-Content d:\logfiles\serialnumberlist.txt "$hostname,$serialnumber"
  }
}

I think you can use this script https://gist.github.com/discoposse/492475

Also, have a look at this similar discussion https://community.spiceworks.com/topic/2256083-serial-number-of-a-device