Orchtech is a software development company working in multiple countries worldwide and our experience spans over multiple services/products such as Offshoring/Outsourcing software development, Mobile applications development services, Web development and HR mobile applications for internal employees management.
Threshold description couldn’t be edited from Web Interface but we have to use SQL queries. The operation is divided into 2 parts. The first: Get information about all configured Alert Center thresholds The second: Update the required threshold Get information…
If you have a problem with WhatsUp Gold database size, you can use Database Tools to Purge expired rows. But if you have non expired data and you need to delete, so you should delete them directly from database. Tables…
This is a sample of dynamic group for the devices with memory utilization exceeds 85% for example. SELECT Device.nDeviceID FROM dbo.StatisticalMemoryCache AS SMC LEFT OUTER JOIN dbo.StatisticalMemoryIdentification AS SMI ON SMI.nStatisticalMemoryIdentificationID = SMC.nStatisticalMemoryIdentificationID LEFT OUTER JOIN dbo.PivotStatisticalMonitorTypeToDevice AS PSMTTD ON…
This query used to detect the devices that has a specific Performance monitor. SELECT DISTINCT Device.nDeviceID FROM Device LEFT OUTER JOIN PivotStatisticalMonitorTypeToDevice ON PivotStatisticalMonitorTypeToDevice.nDeviceID = Device.nDeviceID LEFT OUTER JOIN StatisticalMonitorType ON StatisticalMonitorType.nStatisticalMonitorTypeID = PivotStatisticalMonitorTypeToDevice.nStatisticalMonitorTypeID WHERE Device.bRemoved = 0 AND StatisticalMonitorType.sStatisticalMonitorTypeName…
