I'm looking for a script that counts the number of immediate first-level folders for a list of UNC paths provided in an input file, and then outputs to an Excel a designated spreadsheet somewhere on a network resource.
What I need to accomplish is a scheduled report that exports the number of home folders in our various home folder containers to our home folder matrix spreadsheet that the account management team references when determining where to create home folders. Capacity quotas are set which allow us to calculate the maximum number of folders that can be created in a particular container (e.g. a 100GB container allocation with 500MB per home folder would result in a max number of 200 home folders). With a daily report of the number of folders, the account management group could compare the max folder limit we post in the matrix with the current number of folders that exist without them having to map a drive and look manually, so that they could then notify us when the max number is getting close to its limit.
Or, is there some way to actually limit the number of folders that can be placed in a parent folder? StorageCentral, our capacity management tool, doesn't have that capability. In fact, nor does any capacity management tool I've researched, so I'm resorting to this scripted method to at least more closely monitor the folder account in home folder containers.
Thanks.
What I need to accomplish is a scheduled report that exports the number of home folders in our various home folder containers to our home folder matrix spreadsheet that the account management team references when determining where to create home folders. Capacity quotas are set which allow us to calculate the maximum number of folders that can be created in a particular container (e.g. a 100GB container allocation with 500MB per home folder would result in a max number of 200 home folders). With a daily report of the number of folders, the account management group could compare the max folder limit we post in the matrix with the current number of folders that exist without them having to map a drive and look manually, so that they could then notify us when the max number is getting close to its limit.
Or, is there some way to actually limit the number of folders that can be placed in a parent folder? StorageCentral, our capacity management tool, doesn't have that capability. In fact, nor does any capacity management tool I've researched, so I'm resorting to this scripted method to at least more closely monitor the folder account in home folder containers.
Thanks.
