You can easily export SQL data into a csv. Useful for a lot, such as reverse engineering. Here, we’ll look at dumping the application_name and application_path columns from the jamfsoftware.applications database into a file called apps.csv:
select application_name,application_path from jamfsoftware.applications into outfile ‘/tmp/apps.csv’ fields terminated by ‘,’ lines terminated by ‘\n’;
Some tasks are like the Labrynth. You walk around a corner, mark a block in chalk so you can go back, and then a goblin switches your arrow to a different direction. Or you go through a door and fall down an oubliette. But hey, if you write a few more scripts, you can always bring sanity to those you already have but don’t know exist, right?
Sometimes you wanna’ use a computer as a server. So you can disable the power button from putting the system to sleep:
defaults write com.apple.loginwindow PowerButtonSleepsSystem -bool yes
That’s all I got for ya’ today…