Hi,
I need to remove physical and virtual memory from 'List resources' for all the nodes monitored in solarwinds.
Is there any way to do the same at an instant ?
Hi Arunprassaad,
Please be warned, this is interacting directly with your Orion database.
If this is a production system, you run the risk of breaking the application.
Always backup your database before attempting to alter it, and know how to restore your database if it does corrupt.
Even better is to set up a test environment, using an evaluation copy of NPM and test this safely.
The real and virtual memory you refer to, I am guessing it is listed under the volume resources?
This is a common bugbear and many people have asked why NPM still picks up the memory as volumes.
But as they are listed as volumes, the best places to start is the volume table, on your database.
The following SQL will show all the physical and virtual memory:
SELECT n.Caption, v.VolumeID, v.Caption, v.VolumeType
FROM Volumes v
INNER JOIN Nodes n
ON v.NodeID = n.NodeID
WHERE v.Caption LIKE' Virtual Memory'
OR v.Caption LIKE 'Real Memory'
The NodeID ties this table to the Nodes table (n.Caption = hostname), the VolumeID is unique to the volume (whether it be memory or disk).
It is well worth checking the results from the above SQL SELECT statement, ensure that you get the results that you expect and nothing else.
If the above SELECT does give the exact results you expected, then you could then delete all of these memory volumes with:
DELETE FROM Volumes
WHERE Caption LIKE' Virtual Memory'
OR Caption LIKE 'Real Memory'
If not you will need to adapt the SQL to better suit.
Apologies for posting my question with improper presentation.
Actually i need to 'un-check' the existing resource 'physical and virtual memory' from the list resources and i do not want to remove the entire option of physical and virtual memory from the same.
Unticking the real and virtual memory volume from the node references and deleting them from the volume table using SQL, does the same thing.
Resource view for node:
SQL shows:
Then reopen resources and add virtual and real memory and save:
And the re-run the SQL SELECT from Volumes table:
Now if I delete those tow new Volumes (virtual and physical memory) from resources, using SQL:
And re-open the node's resources:
Hey presto, they are gone!
You asked for the quickest way, SQL is it.
You could also use your Node Management view <Orion servername>/orion/nodes/default.aspx, expand all items tick the relevant memory resources and delete.
But if you have more than a handful, you could be there some time and it's prone to human error (ensure that that no other resource or the node is ticked or it will also be deleted).
Does this work the same for ticking the boxes? As in to tick the boxes it would be a table update with the corresponding captions?
