NetXMS Support Forum

Hello
Is it possible to generate reports automatically with data collection value ? Or export them automatically. Netxms monitor the datacollection item but each time i want to see what is going on i need to open netxms, what i would really like is a system that make a report and send the valuable DCI by email.


miniseb

i would like to monitor what is going on in my IIS server in term of memory.

IIS works with different worker process each of them is linked to an application pool. I found on the internet how to query the counter i want with a WMI query.
The problem is that i dont have only one WMI query to get what i want :

         
   select VirtualBytes, PrivateBytes from Win32_PerfFormattedData_PerfProc_Process where IDProcess = XX
      => this query allows to get the virtual bytes and the private bytes
   the problem is i can not identify the process so i need another query to do that
      
   select ProcessId from Win32_Process where commandline like "%myApplicationPoolName%"
      => this query allows to identify the application pool and get the pid
      
As the WMI query does not enable to make a inner join, the only way is to program that in VBScript or in other programming language.
Is it possible with NetXMS launch a script periodically and get the result to trace in a graph ?
or maybe there is a different way to get what i want ?