• JAMF

    Programmatically Figuring Out When VPPTokens Expire In Casper

    The JSS has the ability to upload multiple .vpptokens, and using those, you can upload separate tokens for sites and then provide App Store apps to different sites based on each having some autonomy by having their own token. This is a pretty cool feature. And using the GUI, you can see when each token expires. You can also see a list of tokens using the API. To see a full list of all the tokens, we’ll just use a basic curl command here: curl -s -u myuser:mypassword https://kryptedjamf.jamfcloud.com/JSSResource/vppaccounts This provides an array of output that has the number of tokens in <size> and the id of each along with…

  • Mac OS X,  SQL

    Remove Records From A MySQL Database

    Sometimes you have data in a MySQL database that you just don’t need. You can delete tables and records pretty easily. In fact, it’s almost too easy. And there’s no undo. So be careful. And backup. And then backup again. And then snapshot again, before tinkerating with anything in this article. In this article we’ll look at using the SQL DELETE statement to delete rows in a table. To do so, we’ll follow this basic syntax, which includes a WHERE clause to narrow the scope of the DELETE by specifying which records will be removed: DELETE FROM table WHERE column=value; In this article, we’ll use the same “Customers” table from…

  • SQL

    Us the ORDER BY Keyword With Your SQL SELECT Statements

    The ORDER BY keyword in a SQL SELECT statement is used to sort a given result-set based on the contents of one or more columns of data. By default, results are in ascending order, but you can use either ASC or DESC to indicate that you’d like results sorted in ascending or descending order, respectively. Below is a selection from the “Customers” table that we will use to run some SQL sorting statements using the ORDER BY keyword: ID Site Contact Address City Zip Country 1 Krypted Charles Edge my house Minneapolis 55418 US 2 Apple Tim Cook spaceship Cupertino 95014 US 3 Microsoft Satya Nadella campus Redmond 98053 US…

  • sites

    Archives

    There is a new archives page. This allows you to view the entire history of the site by date or quickly search through titles. Well, I guess I shouldn’t say quickly; given the number of posts the archives page takes a good bit of time to load… Oh and in case I forgot to mention this earlier, I totally changed the color scheme of the whole site, converted most of the graphics to png (so they should load faster) and disabled a few “features” that I had created that were bogging it down. Running faster and I think possibly looking less vampiric.

  • sites

    Gadgets & Videos

    I added new pages for Google Gadgets and YouTube Videos to the navbar at the top of the screen. The Gadgets are the common gadgets I use and the Videos is a rendition of the krypted318 channel. Hope you find these useful. Look for additional applications to be added to the fat client stuff shortly.

  • sites

    iPhone Skin

    A few months ago I noticed that a pretty hefty percentage of my visitors came from an iPhone. Looking at the site from an iPhone was pretty darn painful, so I added a skin (Plugin) to the site that is specific to users of mobile devices.  While I have slightly modified it for my own purposes (testing in the Simulator every step of the way), I must admit that I didn’t write it.  I’ve received a few comments about it so to give credit where it’s due, it’s the WPTouch Plugin from Brave New Code. It’s a really small Plugin, easy to install (drop into your plugins directory and then…