This post continues where my previous post titled Export events including Event Properties from Windows Event Viewer left off. The data I’m going to work with was exported using eventquery.vbs and saved in a CSV-file, comma separated file and it is presented in the form shown below. “Information”,”10″,”12.05.2009 13:24:48″,”Print”,”Servername”,”None”,”AD\username”,”Document 232, filename.pdf owned by username was [...]
Posts Tagged: csv
Exporting last name, first name and username from Active Directory using AdFind
AdFind is a Windows command line Active Directory query tool. It is a mixture of ldapsearch, search.vbs, ldp, dsquery, and dsget tools with a ton of other cool features thrown in for good measure. This post describes how I managed to export Last name (surname/sn) First name (givenName) Username (samaccountname) from a Active Directory and [...]
Import csv data to mysql
This is a short note about how to import comma separated data, CSV, from a file into a mysql database from a shell. Log in to your mysql database and choose the database you are going to import into. Type in the following in the mysql console to import from the CSV file load data [...]
Comma separated list of system processes
Run this command from a console window ps axo “%u,%U,%p,%a,%z”
MDB tools to export (migrate) from mdb (Microsoft Access format) to mySQL
This convertion could be obtained by first converting the tables in the mdb-file into CSV-files (Comma Separated Values) using MDB Tools and then by importing the csv-files into MySQL using phpMyAdmin. To export a given table from a mdb-file, we type: mdb-export db.mdb customers >> customers.csv In my case, since I got some danish characters, [...]
Recent Comments