Neither of those. I ran dbo.CH_SyncClientSummary. When I run that manually, the HW & SW inventory date updates in the console.
From: [email protected] [mailto:[email protected]] On Behalf Of Daniel Ratliff Sent: Tuesday, September 1, 2015 1:53 PM To: [email protected] Subject: RE: [mssms] Stored procedure dbo.CH_SyncClientSummary Just playing around, found a query that gives you the last run time of a SP. Which one is the SP you are running? spUpsertCH_ClientSummary? spUpsertCH_ClientSummaryHistory? Another one? SELECT o.name, ps.last_execution_time FROM sys.dm_exec_procedure_stats ps INNER JOIN sys.objects o ON ps.object_id = o.object_id WHERE DB_NAME(ps.database_id) = 'CM_CAS' ORDER BY o.name Daniel Ratliff From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Marcum, John Sent: Tuesday, September 01, 2015 4:51 PM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] Stored procedure dbo.CH_SyncClientSummary Hardware inventory every 7 days? Software inventory sure if you even need it at all but I've always ran hardware inventory every single day. I mean 7 days is fine if you can live with old data but if you want more real-time info do it once per day. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Murray, Mike Sent: Tuesday, September 1, 2015 3:44 PM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] Stored procedure dbo.CH_SyncClientSummary This is correct. I have inventory set to run every 7 days (per Microsoft's recommendation - I think I should set it more frequently, but for the sake of the open case with them, I'm keeping it at 7 for now). From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Jason Wallace Sent: Tuesday, September 1, 2015 1:29 PM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] Stored procedure dbo.CH_SyncClientSummary Yes, but things like inventory times in the console are fed from v_CH_ClientSummary and I *think* that there is a logic piece that if the last hardware scan is greater than the refresh interval then the console does not display correctly From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Jason Sandys Sent: 01 September 2015 21:00 To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] Stored procedure dbo.CH_SyncClientSummary Also, this is a ClientHealth (indicated by the CH prefix) view so really would have no impact on inventory info displayed in the console. J From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Jason Wallace Sent: Tuesday, September 1, 2015 3:54 PM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] Stored procedure dbo.CH_SyncClientSummary Hi Mike Are you running inventory on a daily basis? Try setting this to no more frequently than 4 days AFAIK this SP runs every 24 hours From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Murray, Mike Sent: 01 September 2015 20:48 To: [email protected]<mailto:[email protected]> Subject: [mssms] Stored procedure dbo.CH_SyncClientSummary My HW/SW inventory is only updating in the console when I manually run this stored procedure. I've been working with MS support, and the tech there said this procedure only runs once a month, so I will not see this data update until it runs one month from now. This rings false to me. Is he wrong? Best Regards, Mike Murray Desktop Management Coordinator - IT Support Services California State University, Chico 530.898.4357 [email protected]<mailto:[email protected]> ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
