Does anyone have a sql query which can clear up the fallback point data if one or more clients no longer exist on the network so I can't push a client to the system to allow me to remove the machine from the list. Additional the machine is not listed in the ConfigMgr device list.

Mike

What's "fallback point data" and where is the connection to client push and/or uninstalling the client? Please add more details about the scenario. 

In this example I'm talking about the Client deployment failure report which has machines listed which failed to install the client but these machines no longer exist on the network so I would like to clear up the report.

cleanup of data for the clients that no longer on the network or aged will be taken care by the predefined maintenance tasks(if you have configured them).read through the maintenance tasks from here https://technet.microsoft.com/en-in/library/bb632595.aspx .

Additionally, existence of fallback data in no way prevents the client agent from being pushed to that system or prevents that system from being listed in the Devices node.

And, deleting anything directly from SQL in ConfigMgr is totally unsupported and is generally very bad joo-joos to do.

Thanks for the replies. Only looking for supported method of keeping the report valid and removing systems from the list which no longer exist. I'll check out the maintenance tasks tomorrow which I believe are mostly enabled but not should what they are configured to.

Mike