Dynamic Filter in EOC Views

expereo

Is there a way to add a dynamic filter to an EOC View which is updated automatically...

Eg:

I get from DB of our trouble ticket system all customer IDs with severe problems as CSV and I want to display the corresponding node to our overview in EOC.

The filter looks like: Node.CustomProperty.CustomerID in ('1','5','9999')

The list of CustomerIDs changes of course as tickets are modified - so this list should be updated like every 5 minutes.

This was doable in the NPM-DB in the view ressources table, but in EOC everything looks different...

If anybody knows how I could manipulate the ressource filter using eg a script...

Thx

Klaus

davidmaltby

Not that I have done this myself, but I would take the following approach.  I would create a new custom property called "SevereProblem" on the Orion servers that was a "Yes/No" data type.  Then on that Orion database, I would create a SQL job that runs every 5 minutes and that would update the field based on the CSV file and the value of the CustomerID column.

It would do something like:

UPDATE Nodes SET SevereProblem = 1 WHERE CustomerID IN (SELECT * FROM OPENROWSET('MSDASQL',
        'Driver={Microsoft Text Driver (*.txt; *.csv)};
          DEFAULTDIR=D:\;Extensions=CSV;',
        'SELECT * FROM [MyTextFile.csv]'))

if OPENROWSET is not enabled run:
sp_configure 'show advanced options',1
RECONFIGURE WITH override  
go
sp_configure 'Ad Hoc Distributed Queries',1
RECONFIGURE WITH override
go

details on how to use OPENROWSET:

http://www.databasejournal.com/features/mssql/article.php/10894_3331881_2

This assumes that the CSV file only has one column.  Anyhow, if you get that all working then the filter could be as simple as:

Node.CustomProperty.SevereProblem = 1

These instructions are loosely spelled out, but hopefully you understand at what I'm thinking.  If that doesn't quite work, maybe it will give you ideas on something that would work. 

Do keep in mind that you want to manipulate the data on the Orion database.  If you do it on the EOC database, then you'll get inconsistent results, since EOC polls fresh data from the Orions at different times then your T-SQL job, then the filter could get applied before or after the SevereProblem field has been set.

Thanks,

David