Unmanage Node Report ?

onEOFsix

Hello,

Is there any way to determine:

1. When a node is scheduled to be "unmanaged".

2. If a node is "unmanaged", when it is due to be re-managed ("unmanage" schedule expires).

I'm running Network Performance Manager 9.1 SP4

Thanks!

Find more posts tagged with

unmanaged_node

npm_9.1_sp4

Accepted answers

DanMarbes

Here's what I use for a list of unmanaged nodes:

select caption, unmanagefrom, unmanageuntil from nodes where unmanaged <> 0 order by caption

And a list of those coming unmanaged in 7 days or less:

select caption, unmanageuntil, datediff(day,getdate(),unmanageuntil) as DaysLeft from nodes where unmanaged <> 0 and (datediff(day,getdate(),unmanageuntil) < 8) order by DaysLeft

All comments

onEOFsix

Here's the query I'm looking for:

Select *

From Nodes

Where UnManaged = 'True'

DanMarbes

Here's what I use for a list of unmanaged nodes:

select caption, unmanagefrom, unmanageuntil from nodes where unmanaged <> 0 order by caption

And a list of those coming unmanaged in 7 days or less:

select caption, unmanageuntil, datediff(day,getdate(),unmanageuntil) as DaysLeft from nodes where unmanaged <> 0 and (datediff(day,getdate(),unmanageuntil) < 8) order by DaysLeft

onEOFsix

Thanks !

scottkwei

a custom resource which you can put in ur homepage. Shows a table of scheduled nodes to be unmanaged. Includes a custom-made icon so you know what you are looking at.

rabbid69

Dan Marbes,

Where I put these code in? Could you show me it more details? Many Thanks.

maho

I took Dan's SQL code and messed with it a little bit to get a report that shows Nodes that are Unmanaged now and in the future, including listing times. I tweaked it so that it doesn't show any records where DaysLeft is less than zero, so it shouldn't show all the nodes that aren't scheduled for downtime.

rabbid, to use the code create an Advanced SQL Report and paste the SQL code into the field in the SQL tab. Should be that easy. I've done that, then added it as part of our home page view so we have a nice list of scheduled downtimes.

 SELECT Caption, UnmanageFrom, UnmanageUntil, DateDiff(day,getdate(),unmanageuntil) as DaysLeft 

FROM Nodes 

WHERE (datediff(day,getdate(),unmanageuntil) < 365) AND (datediff(day,getdate(),unmanageuntil) >= 0)

ORDER BY DaysLeft ASC