167 questions
0
votes
3
answers
157
views
How do I populate a column in a PowerShell array from a Groups column in a CSV by searching for a matching Name of a corresponding user?
I have a PowerShell script that works up to a certain point that imports two CSV files, CSV #1 and CSV #2, and creates a new array ($content3) with input from both CSV files. I need to populate the ...
0
votes
2
answers
58
views
Export to CSV for each folder in a directory
I am brand new to PowerShell and have gone through tutorials to learn the basics. I'm now at the point where it's a step beyond my knowledge and could use some guidance.
Scenario:
I have a Projects ...
0
votes
0
answers
274
views
Maria DB SQL to write results in a .csv file
I started off by writing an SQL statement in Maria Database to extract records within a certain date range. No issues doing this.
To use the data I exported the data to a .csv file in a second step.
I ...
0
votes
1
answer
131
views
Select-Object, then Get-Content of those documents, and extract a string as another property?
I'm trying to create a script that will generate a CSV doc but I'm learning as I go and I'm still quite new to PowerShell. I'm not sure if it's possible to do what I need it to do in a single script (...
1
vote
1
answer
102
views
Export Exchange Online query to CSV
I'm trying to export a list of mailbox sizes of users in Exchange Online to a CSV file on the desktop of the user running the command.
The command to retrieve the information I want from Exchange ...
- 13
0
votes
1
answer
81
views
Invoke-sqlCmd output CSV for each stored procedure results
I am trying to get multiple stored procedures, each out outputting certain results with varying column names.
I have managed to get the script to parse through each query however it just lumps all the ...
0
votes
1
answer
72
views
Error when using the copy function in postgresql
I need to use the copy function with inner join from more than one table with where.
Postgresql if pgadmin 4
When I do this query, it returns the data I need
select *
from estabelecimento
join ...
0
votes
1
answer
92
views
Unsure how to get Export-Csv to work for what I need
I have to rename a little over 100 computers in the warehouse where I work. My script is setup to delay the renaming process until a desired time and gets the computer names from a .csv file. The ...
- 3
0
votes
3
answers
221
views
Convert text File to CSV Format using powershell
I want to convert the Text File to CSV File and below is the Format using Powershell and need some assistance
Text File Structure: This is how the data looks in output or text file
Content for ...
- 45
0
votes
0
answers
59
views
Powershell export-csv column order
I am importing a CSV file, and running an application to decode some data from one of the columns, then I wish to export-csv all of that to a new file. I used this as a reference
PowerShell Output to ...
- 43
0
votes
1
answer
72
views
Wice_Grid gem having issues in export CSV with Rails 7.1.3
We are working on a project that is migrating to Rails 7; we had a wice-grid gem working for Rails 2 but with Rails 7 we are not getting export functionality working. Is there any documentation or any ...
- 1
0
votes
0
answers
389
views
Powershell Export-CSV Error - "The process cannot access the file \\xxx\hhh\fff\report.csv because it is being used by another process
Help please - I have a script to report all DFS folder targets and will check the path status but I'm getting a random export-csv error "The process cannot access the file \xxx\hhh\fff\report.csv ...
- 1
1
vote
1
answer
66
views
Powershell referencing property within a property and exporting to CSV
From my RMM tool and using a module written by an awesome dude called HomoTechsual ( NinjaOne ), I can get a list of organisations, which have various properties:
name : Test Organisation ...
- 25
0
votes
2
answers
96
views
How to export resultset of a procedure with parameters using T-SQL command in SQL Azure database
I have to export the results of a stored procedure with 2 input parameters in SQL Azure instance using a T-SQL command to a .csv file in SSMS. Thing is, I need to run this stored procedure 3000+ times ...
- 659
0
votes
1
answer
102
views
Bash compile output into a csv using jq
I am writing a Bash script to create a csv from a sample inconsistent json data but running into a bunch of issues.
My json data looks like this :
json_data='[
{
"ResourceARN": "...
- 1,388