Client Report Date

[MrCheck]

I'm trying to find out the date that an SMS client last reported data to the SMS server. I'm trying to do this through SQL, not the SMS interface. The dates that I can find come from the client but that doesn't work for me as some of the clients have the wrong dates on them. I know SMS stores this information somewhere since it can automatically delete machines it hasn't seen in a certian period of time. We've got ours configured to delete machines it hasn't seen in 30 days. I've got machines there with a report date of last August. The date is wrong on the client but the server knows that it has seen the machine in the last 30 days or it would have deleted it. Where does SMS store the date that it last saw the machine? I've looked through the SMS tables and can't find it anywhere.

 

[Mich]

There is a table called DiscItemAgents that has a column called AgentTime. That will show you when the machine was last seen by an agent based on agent ID. You may find it easier to use the view v_AgentDiscoveries.

Hope this is what you're looking for.

 

[MrCheck]

Thanks for the quick response. I didn't have much luck with the DiscItemAgents table. From what I could tell the Agent ID field maps back to the Agents table and tells me what agent it's reporting the time for. None of the records in there had an Agent ID of 1 and all my records in WorkstationStatus_DATA and Computer_System_DATA have an Agent ID of 1. I think I found the field I'm looking for though but I'm not sure. There is a field called Timekey in System_Data that seems to be the date that SMS uses to purge the aged items. Not sure if that's the correct date or not but it seems to match up with the time frame of what should have been deleted because of age. Thanks again.