Easy Way of Exporting from SCCM 2012

So there have been several requests internally who are NOW starting to leverage off the information that is readily available within SCCM.

Question; How do I export a list of devices from SCCM into Excel?

Solution; Easy! Ctrl A, Ctrl C, (select Excel spreadsheet), Ctrl V. Done.

Here’s the walk through guide –

As I need the list of Active PCs on the network, I have used the search functionality within devices. Note; this is just an example, as you can easily achieve this by using the Active/Inactive Collection under Device Collections.

SCCM_Export_001

Literally, use the Select All key combination (Ctrl + A) or Individual selection key combination (Ctrl + Left Mouse Click) and Copy the data (Ctrl + C).

(Select All)

SCCM_Export_002

(Individual Selection)

SCCM_Export_003

Now simply, head over to to your spreadsheet and paste the results (Ctrl + P)

SCCM_Export_004

As you can see, you should now have your ‘export’ performed successfully.

SCCM_Export_005

See the comparison below; requirement achieved.

SCCM_Export_006

Good luck!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s