Custom Report in SEPM 12.1 with SQL query
Please help to write a query in SQL 2008 to generated the reports.
I have SEPM 12.1 RU2 ( Windows server 2008 server) and itigrated with SQL 2008 server.
I need below mention reports, these reports should be genrated automatically at a fix time and send my personal id.
1. All non updated SEP client.
2 All one day old definition SEP client.
3.All 5 days old definition SEP client.
5 All SEP client wich is showing SEP offline Status.
Note :- All reports with Graph chart and client details.
Please share the screen shot for above configuration.