Swql widget that show node down from last 30 days

Can someone help with swql query to show node down from last 30 days

Find more posts tagged with

Accepted answers

All comments

I'm not sure you can do within NCM.

Perhaps better to ask in the NPM forum and provide more detail about what you want to achieve?

mohdash

SELECT n.NodeID, n.Caption, n.UnManageFrom
FROM Orion.Nodes n
WHERE n.UnManageFrom IS NOT NULL
AND n.UnManageUntil IS NOT NULL
AND n.UnManageUntil > n.UnManageFrom
AND DAYDIFF(n.UnManageFrom, GETDATE()) > 30

stuartd

That's good but not in NCM though. Given that the OP posted in NCM then one has to presume he's wanting to use that?

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of