I want to take the report of offline systems with last contact time to the server in SEPM.
You can export Computer status report.
How to create a SEPM Custom Scheduled Report for Offline SEP Clients.
I have tried that, I got only count (number) but not systems hostnames.
SEPM-->Monitors Tab-->Logs--Computer status logs
Is it possible to make an alert for that report?
Yes check this articles
I want report with system hostnames.
There isn't one to show offline systems (hostname). Only one that shows by group and it gives the overall count.
Computer Status is the quickest but it's manual work to be done, no scheduled report automatically.
Montior - logs - computer status report
Export as Excel type
Just sort whatever you want...
I know that, But i want an alert (automated) of that report.
Not possible I have tested in my environment but not getting host name.
As I said, this isn't possible