axg4437 ✭✭✭✭✭

@"rjones-uk", Thanks for your update i want to report up/down status of the AP and also E-mail macros needed if you have any ide can you please share those details will be well and good 

yes I LOST 4 

Can you provide what are the info we are able to achieve via power shell 

Any one have this update to monitor Juniper Mist in solarwinds 

@"rjones-uk",

Try the below query i gave MachineType = 'Zebra Technologies Corporation' you can customize the same for last 24 hours SELECT le.LogEntryID, le.DateTime, le.Message, lel.Level AS SeverityLevel, lel.LevelKey, ms.Caption AS NodeName, ms.IPAddress, ms.MachineType, ms.Vendor, ms.Status, n.Location AS NodeLocation -- Adding…

@"kalaiarasikanagaraj" I tried the above query in the E-mail alerting but am not getting the desired output .. Can you please help us with the trigger query and E-mail query .. am using below one for trigger the alert .. where Nodes.Caption Like '%XX%' and Nodes.CPUMultiLoadHistory.TimeStampUTC…

Appinsight SQL when ever the server scheduled for maintenance and it get manage again the polling sql instance went to unknown state for 10 minutes and getting up . This report shows less than 100 % for unknown state . Any possible query to ignore this unknown state in this availability report event the instance is unknown…

Appinsight SQL when ever the server scheduled for maintenance and it get manage again the polling sql instance went to unknown state for 10 minutes and getting up . This report shows less than 100 % for unknown state . Any possible query to ignore this unknown state in this availability report event the instance is unknown…

SELECT SA.Node.Caption AS [Server] ,SA.InstanceName AS [SQL Instance] ,SA.Databases.DisplayName AS [Database] ,SA.Node.CustomProperties.DeviceClassification AS [Classification] ,SA.Node.MachineType AS [Machine Type] ,SA.Databases.StatusDescription AS [Status] ,SA.Node.CustomProperties.Device_Scope AS [Scope]…

@"Seashore" , I have some custom property in node eg : categories =gold i need to filter this report using this node custom property can you ple help on this 

Thank you

@"Seashore" , One more help ..The above condition i need an alert to be generated ..when the database up status change to down i need an alert bcs the availability shows less than 100 % ..Then there should be an alert if any instance down it should trigger alert what condition need to pass in trigger condition any idea 

@"Seashore" Thanks you so much for your support and time .. Its work great ..... once again thank for your support ..

@"Seashore" , This is great !!!! when i generate daily if i mention -1 am getting yesterday and today data instead i need only yesterday 24 hours data .. And if i run last month in time stamp filed it should shows like may 22 instead all dates (how can i get last month complete data ) in our out of box we have option…

@"Seashore" Perfect report working like a charm ..:) Is that possible to remove unplug /offline thing also the time stamp filed needed .. Like daily ,weekly ,monthly ..how can i modify please provide .. This will help lot of people i say so many looking for this report ..but no luck

@"Seashore", Any idea on this to get the availability

Hi seashore , Thanks for the update i need report per database bcs if i take per instance it is considering all components under appinsight if any one component are critical or warning it impact the availability of instance but it should consider only instance up and down stats not all components . Either instance or per…

It is possible to bring the availability column in the below one report both are different table 

@"Seashore", Thanks for the reply .. Am getting the instance name as below mssqlserver instead of sql instance name .Also the availability is depends on other Appinsight components as well ..i just need instance availability alone like if it goes down the availability will be less..any suggestion or idea ..

Am using Appinsight sql for monitor the sql servers i need sql instance availability report the out of box database availability not giving the instance name . Any sql query to achieve this SQL availability report will be great

Am using Appinsight sql for monitor the sql servers i need instance availability report the out of box database availability not giving the instance name . Any sql query to achieve this SQL availability report

Hi cscoengineer Am using Appinsight sql for monitor the sql servers i need instance availability report the out of box database availability not giving the instance name . Any sql query to achieve this SQL availability report

Hi Any update on creating SQL instance availability report creation 

Any update on the above issue 

Hi , Am facing the same issue any fix for this .. The ticket reopen stopped using the property 6,7,8... But if any one close the ticket without fix it is not getting re-open ..

Am using the below query but unable to do the filter for last 7 days ...do you have any idea to insert last 7 days data to display SELECT LastTriggerTime as TimeStamp, IncidentNumber as ServiceNowTicketNumber, I.AlertObjects.AlertConfigurations.Name as AlertName,I.AlertObjects.AlertActive.TriggeredMessage as AlertMessage,…

 terryk : thanks for your update it is working 

Hi daniel , i tried your query but no luck . i just need last 7 days alert history with service-noe associated ticket number . Kindly help on the same 

Hi All , I have 2020.2.1 HF1 installed already i was trying to install HF2 it was stopped in the below windows for more than 1 hour . I tried reboot the server and check same issue .Any one facing the same issue