Are you looking for something other than what is found in JSS > Settings > Inventory Options > Inventory Collection Preferences > Accounts > Calculate Home Directory Sizes ?

Its enabled. I am looking for a way to generate a report(JSS or SQL) of all users in all machines reporting to Casper. I think there is no way to query from JSS Web Interface so looking for querying from the mysql.

Thanks Sean
Regards,
Karthikeyan.

I am confused. Are you looking for the sizes of all the home directories on your Macs? If so, then I would point you to stevewood's script in https://jamfnation.jamfsoftware.com/discussion.html?id=3703 OR the scripts mentioned in https://jamfnation.jamfsoftware.com/discussion.html?id=6256 as a basis for an extended attribute.

Or are you looking for something else regarding the home directories?

we can see the Home Directory size under Local User accounts in Detail Section of each computer. It might be somewhere stored in JSS database. I am looking for mysql to query...

He's trying to generate a report that shows all of the users on the machine, along with their respective home folder sizes, using the built in Home Folder Size that is run with a standard recon.

The only way I can think to do that with the data that is from recon would be with a custom report. And I'm not sure that would work. There was a link sent out today to something about custom reports.

The optional method, like Sean mentioned, would be to create an Extension Attribute that used "du" to get the home folder size. You could then use the builtin Inventory functions to pull a list of all home folder sizes.

Sorry, that was the Report Downloader that was sent out today.

Thanks Steve. I am exactly looking for the same. Any suggestion on creating on custom report because I am not able to find any column in any of the table of database? But in JSS server web console we can see the Home Folder size for each user in each machine. I am looking for a SQL query to take it out.

That information is also stored inside each computer record in the API. It would be a bit complicated, but you may be able to build a script that would first pull all computer names, then loop through each one querying the JSS via the API to extract the local account names and their respective home folder sizes. As I said though, it would be pretty involved, and in the end, I'm not even sure how you'd use such results as a "report". The script would need to export everything out into a file of some sort.
For this, you might be better off using a direct MySQL query if you can figure out how to do that.

Actually, the exact report you want is in the old Resource Kit. :-) Funny with all of the discussion today about the Resource Kit.

If you have a copy of the Resource Kit from Oct 2011, then you can find the Custom Reports folder under All Tools. Inside of there is a "Show All Users" folder. That contains a report that will give you the home folder size for every user on a system.

Heh, now that is funny :) Oddly, those custom reports actually don't seem to have been posted up anywhere on the links Jake provided, least not that I can see. So it looks like you'd need to either locate the old Resource Kit dmg or grab it from the link that was posted yesterday.
See, that Resource Kit is still proving useful, even though its over a year old.

The data you seek is stored in the package_receipts table. The username is in the package_name column and the size is in the detail_4 column.

If you get that script that Steve mentions, you can tell what detail_1 through _6 are for.

BTW: Thanks Steve... spent a lot of time looking for this info and honestly never occurred to me to look in package_receipts for it. Only when looking through that script was its hiding place revealed.

I being a spoiled brat here but

If you can gather it in Inventory Options, doesn't it make sense to be able to do an Advanced search for it in Inventory? There's a few other areas where the data is in the database and shows up in individual Inventory reports, why can't we do searches for it directly in JSS?

Hi,

Finally we did it through the mysql query to get the user details shown in Computer Details.

select distinct computers.computer_name, package_receipts.package_name, package_receipts.detail_1, package_receipts.detail_2, package_receipts.detail_3, package_receipts.detail_4, package_receipts.detail_5
from computers left join (package_receipts, computers as comp) on (package_receipts.computer_id=computers.computer_id) where type="user"
and detail_2 >= 501 and package_name != "casperadmin" and package_name != "casperinstall"

Thanks & Regards,
Karthikeyan

hkim said:

I being a spoiled brat here but If you can gather it in Inventory Options, doesn't it make sense to be able to do an Advanced search for it in Inventory? There's a few other areas where the data is in the database and shows up in individual Inventory reports, why can't we do searches for it directly in JSS?

You're not being spoiled at all. I'm in complete agreement with you here. I've had the same gripes about Casper a number of times. As far as I'm concerned, if a piece of data is captured in Inventory, I should be able to search on it under Advanced Search and similarly, show its information in a column in the results. The exception to this would be applications names and versions, since that would be pretty hard to accommodate I think.
Sadly, there are a number of things we can't actually pull an advanced report on it or show as a column, but we can see it in the details of a computer record. Makes no sense to me. I really hope Casper Suite 9 fixes some of these omissions.