Juniper Nodes reboot report required

There is a OOTB report you just need to edit the report for vendor = juniper

Thanks for your quick response, I have tried this Last boot report, but this report shows only the time of the Last boot time of the device. I need to generate the report which includes Number of reboots in a day and reboot times.

Use Below SQL Query, I hope it will help you.

SELECT        COUNT(AlertHistoryView.AlertID) AS Time_Rebooted, Nodes.Caption, Nodes.IP_Address, Nodes.Vendor, Nodes.LastBoot, Nodes.MachineType

FROM            AlertHistoryView INNER JOIN

                         Nodes ON AlertHistoryView.RelatedNodeId = Nodes.NodeID

WHERE        (AlertHistoryView.AlertID = '90') and MachineType like '%Juniper%'

GROUP BY Nodes.Caption, Nodes.IP_Address, Nodes.Vendor, Nodes.LastBoot,  Nodes.MachineType

Thanks for your efforts and quick response.

i have generated the report with given query but unfortunatly there is no data showing in report. can you  please review the attached screenshots.

waiting for your kind response. thanks

Try without Where condition and share the result

SELECT        COUNT(AlertHistoryView.AlertID) AS Time_Rebooted, Nodes.Caption, Nodes.IP_Address, Nodes.Vendor, Nodes.LastBoot, Nodes.MachineType

FROM            AlertHistoryView INNER JOIN

                         Nodes ON AlertHistoryView.RelatedNodeId = Nodes.NodeID

GROUP BY Nodes.Caption, Nodes.IP_Address, Nodes.Vendor, Nodes.LastBoot,  Nodes.MachineType

below are the results (without where condition). its showing the data but only the last boot

time is showing. and it shows the number of time device rebooted. but its not showing the time of device each reboot. and can we add specific dates to get the data.

Here you are, and after you add below query group result by the caption and this it will give you every time node rebooted.

if you want the total run below query

SELECT        Nodes.Caption, Nodes.IP_Address, Nodes.Vendor, Nodes.LastBoot, Nodes.MachineType,AlertHistoryView.TimeStamp

,AlertHistoryView.message

FROM            AlertHistoryView INNER JOIN

                         Nodes ON AlertHistoryView.RelatedNodeId = Nodes.NodeID

WHERE        AlertHistoryView.name like '%rebooted%' and MachineType like '%Juniper%' and  AlertHistoryView.message like '%node_rebooted%'

To count:

SELECT       COUNT(AlertHistoryView.AlertID) AS Time_Rebooted, Nodes.Caption, Nodes.IP_Address, Nodes.Vendor, Nodes.LastBoot, Nodes.MachineType

,AlertHistoryView.message

FROM            AlertHistoryView INNER JOIN

                         Nodes ON AlertHistoryView.RelatedNodeId = Nodes.NodeID

WHERE        AlertHistoryView.name like '%rebooted%' and MachineType like '%Juniper%' and  AlertHistoryView.message like '%node_rebooted%'

GROUP BY Nodes.Caption, Nodes.IP_Address, Nodes.Vendor, Nodes.LastBoot,  Nodes.MachineType

,AlertHistoryView.message

yes the count query is working, can you please tell me how i can add specific time for this query.

Like i want to generate a report of last 9 hrs.

The report shows the number of reboots in last 9hr or a specific time instead of a complete result.

Your response is awaited.

thanks in advancd

would you please help in in generating report of specific time like last 9 hrs report

is it possible i can get the daily business hrs reboot results ????