HT202657: OS X Server (Mountain Lion): Advanced configuration of the Caching service
Learn about OS X Server (Mountain Lion): Advanced configuration of the Caching service
Q: Is there a way to obtain a list of all of the apps / updates that are cached to your server?
-
Feb 29, 2016 6:32 AMby Strontium90,Yes. But you need a little Terminal magic to get at the data you want. Caching Server is managed by an sqlite database. To examine the contents, follow these basic steps:
1: Connect to the database using the following command:
sudo sqlite3 /Library/Server/Caching/Data/AssetInfo.db
2: To structure the data, run these two commands at the sqlite command prompt:
.mode column
.headers on
3: To find everything that is stored, run this command (you will get iCloud cached documents, books, iOS apps, etc.):
select * from ZASSET;
4: To narrow the results down to items called by software updates, try this:
select * from ZASSET where ZURI like "%content%";
You might get a line that looks similar to the following:
403 2 6 0 2012986793 474949928.477396 476912032.644505 e03448847909547fb8c7d4ecd5a7b6dd FAB32A72-DE33-469D-A7DF-3CE1A1F9A4D2 Wed, 05 Aug 2015 18:00:30 GMT
/content/downloads/42/44/031-30888/bhrkylcnycxmtug9daw3g4magqb7dl7hba/OSXUpdComb o10.1
(added line break for readability)
This is an OS X Combo update. It is located on disk at /Library/Server/Caching/Data/FAB32A72-DE33-469D-A7DF-3CE1A1F9A4D2/ The file is likely named 0 but if you want to use it, simply add .pkg at the end of the file.
Hope this helps. Caching server records a lot of data.
Oh, to exit sqlite command line tool, simply type .quit and hit return.
Reid
Apple Consultants Network
Author - "El Capitan Server – Foundation Services"
Author - "El Capitan Server – Control & Collaboration"
Author - "El Capitan Server – Advanced Services"
:: Exclusively available in Apple's iBooks Store
-
Mar 23, 2016 7:40 AMby dkilburn2,That did help, thank you. Do you happen to know the filter I would use to narrow it down to IOS updates. We're currently seeing over 600Gb of cached IOS updates and I wanted to make sure that the sevice is working properly and not storing the same update more than once.
-
Mar 23, 2016 5:20 PMby Strontium90,How about:
select * from ZASSET where ZURI like "%iOS%";
Reid
Apple Consultants Network
Author - "El Capitan Server – Foundation Services"
Author - "El Capitan Server – Control & Collaboration"
Author - "El Capitan Server – Advanced Services"
:: Exclusively available in Apple's iBooks Store
-
Mar 24, 2016 4:36 AMby dkilburn2,Thank you that's exactly what I needed. So what we figured out was that because we have such a range of devices, there is technically a different update package per model... so even though we have 8 different lines that have the iOS9.3 beginning, it is caching each of them because each package is for a different model of the device. There is currently 16 different models of the iPad, 15 of which support iOS 9.3 (not fully supported, but it can be installed on them). Then there's the iPhone and iPod that each have their own number of models... so it just keeps expanding.
You may already know all that, I'm still learning. But I wanted to document it in case anyone else is looking for the answer and finds this thread. Thanks again!
Dave
-
by Michael Newbery,Mar 24, 2016 10:42 PM
Michael Newbery
Mar 24, 2016 10:42 PM
in response to Strontium90
Level 4
(2,424 points)
Servers EnterpriseThanks!
If ever something called out for a GUI in Server though, this is it.
One thing, if you have moved the location of your cache, you need to put that location in rather than /Library/Server/Caching/Data/AssetInfo.db (I was wondering why all my last modified dates were three years ago).
