Hi,

Thankyou for the response. My question is, can we install and use it on a local machine instead of a server?

thankyou!

Thankyou Heaps! It worked like a charm.

Hi,

I tried running the script (changed 24 to 5) and I get the below error.

Export-Csv : Cannot append CSV content to the following file: C:\Users\user1\Desktop\computer.csv. The appended object
does not have a property that corresponds to the following column: Monitor1MonitorName Monitor1Serial Monitor2MonitorName
Monitor2Serial Monitor3MonitorName Monitor3Serial Monitor4MonitorName Monitor4Serial Monitor5MonitorName Monitor5Serial. To
continue with mismatched properties, add the -Force parameter, and then retry the command.

I changed the export-csv part of your script to below and I get the same error:

[PSCustomObject]$obj | Select Monitor1MonitorName, Monitor1Serial, Monitor2MonitorName, Monitor2Serial, Monitor3MonitorName, Monitor3Serial, Monitor4MonitorName, Monitor4Serial, Monitor5MonitorName, Monitor5Serial | Export-Csv -Path $CSVFile -NoTypeInformation -Append

Any suggestions please?

Thanks heaps for looking into this.

It doesn't paste the data into the separate columns. I am trying to achieve the output something like the below:

Do you suggest I have the column headers present in the csv before hand. Do you think it can be achieved that way? I can look at finding out what is the maximum number of monitors a user has in the organisation, and then have my column headers as Monitor1MonitorName, Monitor1Serial,......MonitornMonitorName, MonitornSerial.
For the user with only 1 Monitor, the data will go into Monitor1MonitorName and Monitor1Serial and the rest of the columns will stay blank. For User with Maximum monitors, All columns will be filled.

Do you think this is achievable? Can you please help with how do I change my script in that case?

Hi,

This script is adding data into 1 cell only. I want the data going into separate cells with the column headers as Monitor1Model, Monitor 2Model, Monitor1Serial#, Monitor2Serial# and so on.
I am testing this on my local machine for now but the plan is to have the applet (that I am working on) assigned to users so that they we can collect data into a csv.

Also just realized the script do not write model 1 and model, serial1 and serial2 in separate columns either. Any help will be appreciated!