get-wmiobject script not working

Question

I am trying to write a script to pull software list down from multiple computers in one script, however most is working but one field is not pulling through anything

I have got this script below...

GET-WMIOBJECT -CLASS WIN32_PRODUCT -COMPUTER CLUKxxx,CLUKyyy,CLUKzzz | SELECT-OBJECT COMPUTERNAME, NAME, VERSION, VENDOR | SORT OBJECTNAME | EXPORT-CSV "C:\CLUKxxx_yyy_zzz_Programs.csv"

the name, version and vendor is pulling through just fine, however I cannot seem to find a way to pull through the computer name. I have tried _SERVER, COMPUTER, COMPUTERNAME, SERVER but nothing is working.

I know the script is working pulling through software from both computers as I got duplicate program names in the list (i.e. IBM Notes comes up twice).

Does anyone know how I can put the computer name in the script?

So far, COMPUTERNAME column is appearing blank.

Thanks guys. Dan

Have you used Foreach-Object before? This would still pull back duplicate programs for each machine that has them installed on, but you can then easily separate the results per machine at least. — Ross Lyons
– Ross Lyons, Commented May 16, 2018 at 11:03
Hi ross, I haven't actually used that before. How can work that within my script? — Dan Goodwin
– Dan Goodwin, Commented May 16, 2018 at 11:05

Vivek Kumar Singh · Accepted Answer · 2018-05-16 10:31:03Z

0

Use the PsComputerName property of WMI objects. Change your script to -

GET-WMIOBJECT -CLASS WIN32_PRODUCT -COMPUTER CLUKxxx,CLUKyyy,CLUKzzz | SELECT-OBJECT PsCOMPUTERNAME, NAME, VERSION, VENDOR

answered May 16, 2018 at 10:31

Vivek Kumar Singh

3,3601 gold badge19 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dan Goodwin Over a year ago

Hello, thanks for your help but the column is still coming up blank when I export to .csv

Vivek Kumar Singh Over a year ago

It works fine for me. Are you getting the Computer name on console for the command

GET-WMIOBJECT -CLASS WIN32_PRODUCT -COMPUTER CLUKxxx,CLUKyyy,CLUKzzz | SELECT-OBJECT PsCOMPUTERNAME, NAME, VERSION, VENDOR

?

Collectives™ on Stack Overflow

get-wmiobject script not working

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related