Total Number of Homeshares Created not Updated (4382363)

Customer has two servers hosting homeshares for employees. When new shares are created or old shares are deleted, the display for number of "Shares Created" is not updated.

This leads to an imbalance in share distribution across the servers.

SQL query to get the counters:

select CountUsedHomes from QBMServer

Same values can be seen in:
Manager: 
Active Directory > Basic Configuration Data > Server > Homes Created

Seems like these counters are offset & not updated and longer. 

Product defect.

There is no functionality in code for updating these counters.

Raise a trouble ticket with the Support Team and ask for Hotfix #680621.

Workaround:

1. Use the following PowerShell script to get the actual counters from Active Directory.

<#
    Script: Count-ADUsersWithHomeDirectory.ps1
    Purpose: Counts AD users who have a homeDirectory configured.
    Requirements: Run on a domain-joined server with RSAT / AD PowerShell module.
#>
 
Write-Host "Counting AD users with home directories..." -ForegroundColor Cyan
 
# Ensure the AD module is available
Import-Module ActiveDirectory -ErrorAction Stop
 
# Get all users with homeDirectory set
$usersWithHome = Get-ADUser -Filter * -Properties homeDirectory |
                 Where-Object { $_.homeDirectory -and $_.homeDirectory.Trim() -ne "" }
 
# Output the count
Write-Host "Number of AD users with a configured home directory:" `
           $usersWithHome.Count -ForegroundColor Green
 
# OPTIONAL: List users ([un]comment to turn on / off)
 $usersWithHome | Select-Object SamAccountName, homeDirectory | Format-Table -AutoSize

2. Based on the output of this script, you can update the "CountUsedHomes" value using the Object Browser tool.

a. login to Object Browser and select DB structure \ QBMServer

b. select SQL/Query \ New SQL Window

c. in the new SQL document run the select query (you can run the query with they run button or SQL/Query\Run)

select CountUsedHomes, Ident_Server, * from QBMServer

d. pick up the Ident_Server what you want to update and change the SQL command accordingly.

Example in my case:

update QBMServer

set CountUsedHomes = 10

where Ident_Server = 'IAMSVC01_922'

 if the action is successful, you should see "1 row(s) affected" message

e. Run the select SQL command again to see if the table is updated

select CountUsedHomes, Ident_Server, * from QBMServer

Note! No commit or any other save is needed.