Show a list of networks port that have been in disconnected status for a period of time

Hello,

We want to disable every unused port in our network.

Is it possible to use SolarWinds to get a list of networks port that have been in disconnected status for a period of time ?

Thank you.

Find more posts tagged with

Hmm, that refers to part that sets date to 60 days ago

declare @prev60 smalldatetime=dateadd(dd,-60,getdate());

Perhaps check with your SQL administrator and inform them that the database user Orion uses needs to be able to run commands like the above.

What version of SQL are you running?

ahh, searched google...you must be running SQL 2005 or 2008. Can't declare and set on same line in older versions.

I've adjusted the report and it should work now. download the latest and let me know the results.

thanks

check out this CONTENT DOWNLOAD. you may want to tweak like vendor='Cisco', etc...

Hello,

It sounds like what I'm looking for. However when I run it says

"SQL Error: Can not assign a default value to a local variable"

Please advise.

Thank you.

Hmm, that refers to part that sets date to 60 days ago

declare @prev60 smalldatetime=dateadd(dd,-60,getdate());

Perhaps check with your SQL administrator and inform them that the database user Orion uses needs to be able to run commands like the above.

What version of SQL are you running?

ahh, searched google...you must be running SQL 2005 or 2008. Can't declare and set on same line in older versions.

I've adjusted the report and it should work now. download the latest and let me know the results.

thanks

It works beautifully. I changed the last line to

"order by InterfaceName" to make it easier for us to track.

Thank you.