Questions tagged [csv]
Comma Separated Values is a tabular to store data
87 questions
1
vote
0
answers
52
views
Solarwinds Service Desk - Import of updated computer info to include tag field
When you download the sample computer import CSV off the Solarwinds Documentation site for CSV imports, it just has the below fields in it.
I am looking to update the Tag field (presumably not the ...
1
vote
0
answers
49
views
Solarwinds Service Desk - CSV Import matching name, instead of just serial number/asset ID
Unfortunately I don't have a way of matching the asset ID of a computer in our SolarWinds database, with the data I have to update. Hence only allowing current Serial Number and Asset ID to be matched ...
0
votes
2
answers
273
views
Handle csv file - add value with mapping table
A script generates a csv-file:
User | actualValue |
user01 | actualValueB |
user02 | actualValueC |
user03 | actualValueB |
user04 | actualValueA |
user05 | actualValueA |
.
.
.
The file has the ...
1
vote
5
answers
564
views
Remove commas in double quotes from CSV
I have a comma separated line I am using awk to extract fields from.
Server1,poweredOn,10.0.18.70,"Blue, Green",POC,Vsphere
However, when it comes to the text in double quotes ("Blue, ...
2
votes
0
answers
77
views
Files last modified date changed when saved on CSV (Clustered Storage Volume) runnig on Azure Shared Disk
We implemented a Cluster Shared Volume (CSV) using Azure VMs and Azure Shared Disks. The CSV is accessible for read/write operations from two servers in a failover cluster configuration. This setup is ...
0
votes
2
answers
226
views
Correct syntax rendering variables within command string
Been trying to learn some better scripting in bash. Normally I can pull data values to iterate into command strings, but this one is showing my ignorance on syntax.
#! /bin/bash
while IFS=',' read ...
0
votes
0
answers
1k
views
The Object name has bad syntax when trying to bulk add AD users using Powershell
I'm attempting to add a series of User to AD by importing a csv file and I can't seem to get it to run successfully, the error always reads 'the object name has bad syntax' however no matter what kind ...
1
vote
1
answer
109
views
SQL Server Management Studio 2019 save to CSV and then import it after test
I'm fairly new to SQL, and I'd like to do some quick testing.
I'm about to update a field in 81 records in a table. After each test, I'd like to get back where I started. I've saved off my query ...
1
vote
0
answers
314
views
Ansible export to csv
I want to get a csv with a list of new updates in this form:
testvm-001.localdomain,ImageMagick-6.9.11.27-4.el7
testvm-001.localdomain,ImageMagick-libs-6.9.11.27-4.el7
I have a code that will display ...
2
votes
3
answers
835
views
Best way to filter output by date range
I need to filter a row of a csv file by a date.
The file is structured as so:
[email protected] active 01/24/11 10:04 07/23/23 16:56
...
0
votes
1
answer
367
views
Have List of user but I want to find out if they are added to specific ADGroupMember
I have been trying to understand how to import my csv file and export of specific adgroup they are added or even they are not added
Import-CSV " C:\Users\user.csv" | ForEach-Object { Get-...
0
votes
1
answer
151
views
RegEx passed by CSV file not working in PowerShell
Hi I have a script trying to pull out the price value from a html file. the Regex works when I assign it in the script but when I put the regex in CSV, it refuses to give me the result. Could someone ...
0
votes
1
answer
64
views
Recomendations for Data Transfer between heterogeneous sources/destinations
I apologize if this is not the right forum for this kind of question.
We need to transfer data between DB Servers (MySQL, MSSQL), CSV files, API Sources (Web Services), etc. and we are looking into a ...
0
votes
3
answers
7k
views
Is there a way to export all AWS Security Groups to CSV? moreover, is there a recommended way of keeping track of SR changes?
We have a relatively small dev environment in AWS with about 50 Security groups with multiple permission entries. is there a recommended way of keeping track of SR changes, Access, etc?
My manager ...
0
votes
1
answer
191
views
How to extract the Table Definitions of a MYSQL Table into CSV?
The output of mysqldump -not csv does not contain the columns, just values:
select * from AUDIT_RESULT
INTO OUTFILE '/va/tmp/audit_nresult.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES ...