Em Andamento

store WMI data in SQL express DB and return a total in windows APP

I need an application that stores WMI data in a SQL 2005 express server

with a counter ( bigint ) a name ( string ) a identifier ( bigint ) a datetime and a description. estimated size per record is 40 bytes max this data should be polled from WMI every second and stored inside its own table in SQL express 2005 server, the application should then make some calculations

( example the total count between 2 dates e.g. a month / week / day )

the application should be written in [url removed, login to view] 2005 / 2008 ( or [url removed, login to view] 2005 express / [url removed, login to view] 2008 express ) and be able to select different counters and different names. ( this should be configurable ) and be able to check a treshhold.. and warn per SMTP if treshold is reached

## Deliverables

a normal windows wmi network counter i need :

namespace : root\CIMV2

class : Win32_PerfRawData_Tcpip_NetworkInterface

Property : BytesTotalPersec

Property : Name ( this property contains the name of the element, there can be many different elements, we need to filter on Name )

this WMI counter exist in XP and windows 2003 also in windows 2008 windows vista and windows 7

also if there are two network cards you will see two times the : BytesTotalPersec counter here.. ( filter on Name and you'll see what traffic goes through which network card..

there are more then one counter i need, not FIXED, but configurable ( i decide which counters i want to monitor, here is an other example of 2 counters i might need

namespace : root\CIMV2

class : Win32_PerfRawData_NvspNicStats_HyperVVirtualNetworkAdapter

Property : BytesPersec ( this property contains the datatraffic )

Property : Name ( this property contains the name of the element, there can be many different elements, we need to filter on Name )

for this you need Windows 2008

other example :

namespace : root\CIMV2

class : Win32_PerfFormattedData_WMServer_WindowsMediaPublishingPoints

property : Name

property : TotalPlayerBytesSent

for this one you need windows 2003 + Windows media services 9

this TotalPlayerBytesSent and BytesperSec are increasing.. but if the service / server is restarted they will start at ZERO so after storing data in SQL

you need to take this into consideration..

the data returned is a bigint , this is no problem in sql, but might be an issue when doing calculations in [url removed, login to view]

Habilidades: .NET, Engenharia, Microsoft, MySQL, PHP, Arquitetura de software, Teste de Software, SQL, Visual Basic, Área de trabalho do Windows

Ver mais: store wmi sql, two string problem, element 14, sql server max, max sql server, make name card, wmi, windows store, windows 2008, store check app, name cards data, express, data in, counters, app traffic, app count, net windows services, start windows service, sql different, check php smtp, application store visual basic, express php, php 2008 windows, windows record, max element

Acerca do Empregador:
( 40 comentários ) Amsterdam, Netherlands

ID do Projeto: #2993253

Premiar a:


See private message.

$51 USD em 3 dias
(97 Avaliações)