In fact, we have a collection using the below query that shows clients with a recent HW inventory (7 days or less). It is populating! Yet, hardware & software scan date columns are at 6/30/2015. This is mind boggling.
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceID = SMS_R_System.ResourceId Where DATEDIFF(dd,SMS_G_System_WORKSTATION_STATUS.LastHardwareScan,GetDate()) < 7 From: [email protected] [mailto:[email protected]] On Behalf Of Murray, Mike Sent: Tuesday, August 4, 2015 2:43 PM To: [email protected] Subject: RE: [mssms] Before I open a support ticket with MS... Thanks, Sherry. I can see my system in the dataldr.log on the site server, so it looks like the data is getting there. But it’s not updating in the console. :/ From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Sherry Kissinger Sent: Tuesday, August 4, 2015 1:33 PM To: [email protected]<mailto:[email protected]> Subject: Re: [mssms] Before I open a support ticket with MS... Start here: http://www.enhansoft.com/blog/troubleshooting-inventory-flow and see where inventory falls down. On Tuesday, August 4, 2015 3:21 PM, "Murray, Mike" <[email protected]<mailto:[email protected]>> wrote: Yes, we are. The time sever outage affected everything. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Kent, Mark Sent: Tuesday, August 4, 2015 11:32 AM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] Before I open a support ticket with MS... Are you not on an AD domain? Your clients don’t synch time with your DC’s? Mark Kent (MCP) Sr. Desktop Systems Engineer Computing & Technology Services - SUNY Buffalo State From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Sean Pomeroy Sent: Tuesday, August 4, 2015 2:23 PM To: [email protected]<mailto:[email protected]> Subject: Re: [mssms] Before I open a support ticket with MS... If you go to view hardware inventory classes in client settings, does the console crash? On Tue, Aug 4, 2015 at 1:47 PM Murray, Mike <[email protected]<mailto:[email protected]>> wrote: Quick background – our NTP time server went down for a short while a couple of months ago. As a result, we had wonky timestamps in CM. Some had the year 2034. We worked with MS and they were able to clear this up. Now we have a new issue, and they want us to open a separate case to address it (even though I believe it’s a direct result of the work they already performed). Our hardware and software inventory in the console only goes up to 6/30/2015 (the day they worked on our server). I can see newer inventory when I open resource explorer on machines, but it’s not showing in the console. Policy requests are showing current dates. Any ideas of things to try before I spend any more money with MS? [cid:[email protected]] Best Regards, Mike Murray Desktop Management Coordinator - IT Support Services California State University, Chico 530.898.4357 [email protected]<mailto:[email protected]>
