SCCM asset list

[nicholab]

Hi can I produce an asset list form SCCM that list model, hardware specs and Serial number then list where the machine lives in AD? I am looking for a quick way of doing an asset list so the machine should have reported back in the last month.

[JRowley]

You can do this with a Query, they're quite easy to build and you can copy/paste the data out in to excel if you need to. Also this link talks about setting Criteria, this isn't a requirement but you could use it to exclude Virtual machines for example.

 

https://docs.microsoft.com/en-us/sccm/core/servers/manage/create-queries

 

Here are the things we look for in ours, all of your devices will have to complete a software/hardware scan to be able to get all of this data:

 

 

Alternatively you could build a report but that's a bit more indepth, I think a query is fine.

Edited April 11, 2019 by JRowley