Hi Swati. You have to regenerate views on the SD DB by (SDESk 5.1) Workspace HP Openview Configuration --> System Settings --> Report Settings --> (Re)generate database views for reporting... Hope this help!!
Thats not the same as what we Crystal guys would call a "view". "View" within the OVSD tool is just a glorified filter internal to the application.
In terms of what Crystal (and the rest of the database world) considers "views", there's no way to create these in OVSD.
Since 2 years later, our OVSD 5.1 implementation still doesn't calculate deadline correctly (thanks again HP!), I've had to use Crystal extensively to get even a drop of value out of our Service Desk operation. If you let me know exactly what you're trying to do in Crystal, I could probably help you out.
Actually i hav to generate report of all the network incidents showing the total downtime for each node in the last month.
I created a view in the database and able to find all the network incidents last month but i m not able to did a query resulting in the total downtime of each interface. Since i don't hav much knowledge of database i need help.
That really will depend on how you want to define the metric. Incident creation/resolution time might not always be the most accurate way to calculate downtime.
But if that is what you want to do you may want to look up how to calculate duration between two datetime values, as well as how to use aggregation functions to sum (hint!hint!) and group by (hint!hint!) your results.
Hopefully this points you in the right direction to gaining that coveted database knowledge you're after.