I am trying to get monthly reporting (not daily) on Application availability , for a group of applications.
I am not so good with sql, please help.
The options are there. In the Report writer you can use the Application Availability - This Month or Application Availability - Last Month
You can also change the Summarization in a report that has a longer timeframe to show results in the Month as seen below:
Regards,
Matthew Harvey
Senior Sales Engineer
Loop 1 Systems
http://www.loop1systems.com
Putting Knowledge Into Motion
Thanks for the quick reply.
So I am running the Group Availability report for " This Month" and its providing each day , my task is to report The Month only.
Edit the Report in the Report writer and see if you can change the Summarization to Month.
you can use the web version, I know it has some nice flexibility when it comes to report tweaking ;-)