kashif091

can you please tell give me one more query about how I can get the availability of the last 24 hrs(or current availability) for custom property nodes? for KPI widget dashboard. 

Thanks a lot for your help, it's working great, can you please tell give me one more query about how I can get the availability of the last 24 hrs(or current availability) for custom property nodes?

Yes @"sreenathmp" i want to get the status of nodes with count from specific custom property nodes. Like it shows me the total 50 nodes down and 20 nodes up with Pie chart from my custom property nodes 

Thanks for helping, Would you please add timestamp in this query so i can filter specific time results from this query, thanks

Hi @"ChrystalT" @"adatole" @"cscoengineer" @"mesverrum" can you please help with below query for today data instead of last 24hrs, and 2nd query with specific time of today(like 9 to 5) SELECT AVG(Availability) AS AVGAvailability, NodeID FROM Orion.ResponseTime Where DateTime >= AddHour(-24, GETDATE()) AND NodeID IN…

@"ChrystalT" Thanks for your help. can you please help with daily instead of the last 24 hrs and 2nd query with today for 9AM to 5PM SELECT AVG(Availability) AS AVGAvailability, NodeID FROM Orion.ResponseTime Where DateTime >= AddHour(-24, GETDATE()) AND NodeID IN (SELECT NodeID from Orion.NodesCustomProperties WHERE…

Thanks for your help. can you please help with daily instead of 24 hrs, and 2nd query with today for 9AM to 5PM SELECT AVG(Availability) AS AVGAvailability, NodeID FROM Orion.ResponseTime Where DateTime >= AddHour(-24, GETDATE()) AND NodeID IN (SELECT NodeID from Orion.NodesCustomProperties WHERE Purpose = 'Web Server')…

thanks for your reply. I want to create modern dashboard with a KPI widget. in which i want to filter the custom property nodes availability 

HI @"sreenathmp" Thanks for your response, I have checked, but unable to find any custom property filter with NOdes status count, if you can please suggest to me a way by which i can filter the nodes up & down status from custom property i will be very thankful to you . Thanks

anyone please help me to get this report, thanks

Dear @tony.johnson WOuld you please help me in this issue, Thanks 

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

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

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

i almost got the answer, thanks for giving me the way to resolution. thanks

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.

dear noki42​ have you got any information from the person who worked on it. waiting for your response, thanks

HI noki42​ do you have any news on the cisco inventory collection?

I have tried below query and got the total number of reboots per day. But I want the time stamp of each reboot. can you please help me in getting number of reboots, each reboot with the timestamp. SELECT COUNT(Events.EventTime) AS COUNT_of_Event_Time, Nodes.Caption AS NodeName FROM Nodes INNER JOIN (Events INNER JOIN…

HI Adam, Thanks for your help. can you please tell me how i can get node reboot count report from node reboot event thourgh SQL Query with time stamp. thanks

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

Hi noki42​ Would you please tell me, did you got your required complete details of the inventory, Because I am also facing same issue "Missing Inventory". a lot of modules and all the ports are missing. I will be very thankful to you for your kind response. Thanks

thanks, e.jenidy​ for your great help and support. Can you please tell me if I can schedule this report for the daily report. then what query I need to use instead of below query TimeStamp BETWEEN '2019-08-21 08:00:00' AND '2019-08-28 23:59:059'

HI @mesverrum thanks for your response, but I am using the old version on solarwinds NPM 12.2, in which basic log viewer. can you please suggest according to 12.2 version. thanks

i am creating a custom reboot report. and i need timestamp SQL query by which i can get only yesterday report. instead from start . WOuld you please help me regarding this issue, so that i can Schdule a report with yesterday records . I will be very thankfull to you.

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.

is there any possibility to generate a specific timeframe nodes reboot report?