Question mark

Question

Is there any way to create a sql report to show me all volumes and interfaces in status below (with a question mark ) ?

njoylif · Answer

SQL statement is easy enough, but I don't know about dependencies.  Deleting a node for example has many dependencies in other tables like interfaces, volumes, statistics, etc...

can anyone from SW chime in on a way to mass delete volumes based on status?

valdemirs · Answer

Thanks !

Complementing this question, is there any way to create a sql command to list and delete this unknowed objects ?

njoylif · Answer

the following will give you a list of volumes in an "unknown" state (state with "?") using SQL to query the DB:
select * from volumes where Status=0

so the question is if you want to use report writer, you need to use the "status" field where it =0 and build the rest out that way.