So I think I have answered my own question. There does not seem to be a "report" that will do this but there is a "view". If you go to View > machines, you can then create a smart filter. It is still a little kludgy to get at exactly what I want. So I want to see all machines (of course in this case we are speaking of machines with agents) that have not checked in in X number of days. Within the limits of the smart filter options I did:
Last Agent check in is before "plug in your date".
So what is kludgy here is that you have to change your date each time, and it has to be exported to CSV and then opened in Excel. There is a choice for "is within the past number of days" but that gives me compliant machines not non-compliant. Still, this does get me what I want with fairly minimal pain.
If someone thinks there is a better way to get at this information than what I have outlined please let me know.
Sorry so long in responding. I tried to log in several times and had issues. Finally figured out this forum doesn't like my Firefox and had to use Edge. Thank you for your response. I am not a huge SQL. Guy I looked at your script and would like to try and play with it. would it be possible for you to designate for me the items I need to modify for my environment? Thanks again,