Can some one help me with a query to find the status the all applications mode (Flips and status) changes from Log data base .
Try this:
select timegenerated, appname, hostname, messagetext from g_log_messages where message_id in (4562, 4563, 5150, 4560, 4561, 5151, 5060, 5090, 5063, 5064, 5065)