Problem
Client has reported a HW inventory. HW info is blank under ‘Client Activity’ in ConfigMgr console.
Reason
The stored procedure that updates that view runs once every 24 hours and hasn’t ran since the client submitted its inventory.
Fix
Wait, or run the stored procedure CH_SyncClientSummary using the SQL code listed below.
SQL Code
Get the client’s last inventory date.
|
1 2 3 |
declare @RID int=0 set @RID = (Select ResourceID from v_r_system where Netbios_Name0 = 'PC001') select * from v_gs_workstation_status where ResourceID = @RID |
Get the client’s HW inventory date from the v_CH_ClientSummary view. In this example, the HW inventory was blank.
|
1 2 3 |
declare @RID int=0 set @RID = (Select ResourceID from v_r_system where Netbios_Name0 = 'PC001') select * from v_gs_workstation_status where ResourceID = @RID |
Run the stored procedure to update the view. After the stored procedure has ran, we re-run the query above to get the client’s HW inventory date from the view.
|
1 2 3 |
declare @return_value int exec @return_value = [dbo].[CH_SyncClientSummary] select 'Return Value' = @return_value |